- Define efficient database structures and objects
- “Normalize” raw databases into logically organized tables
- Edit relational data and tables with DML
- Manage transactions
- Write effective, well-performing queries
- Categorize, summarize, sort, group, and restructure data
- Work with dates and times
- Join tables in queries, use subqueries, and combine multiple queries
- Master powerful query optimization techniques
- Administer databases and manage users
- Secure databases and protect data
- Use views, synonyms, and the system catalog
- Extend SQL to the enterprise and Internet
- Master important Oracle and Microsoft extensions to ANSI SQL
Author Biography
Computer developer turned author, Byron Francis graduated from university in Colorado with a degree in Computer Science & Engineering. As a child of the '80's growing up in the computer age, technology enthusiast he was always destined to follow this career path, although he did consider teaching software development, before being offered a job at a software house in Denver. Working as a developer, he gained extensive knowledge of computer programming languages working for clients across the globe, and progressed to deliver training, to colleagues and to the end users on writing programmes and using the software. To facilitate his training delivery, he began writing manuals on topics such as Linux, Raspberry Pi 3 and SQL, which proved very popular among his colleagues and so he published them to the wider public. He also writes articles for an online magazine, reviewing new apps and software releases. As Head of Development for the company, he started his career with, Byron now spends less time travelling and more time based in Colorado, where he lives with his wife and their two dogs. The Francis's like to spend their weekends away from the city trekking or camping, and are both keen horse riders.