From the Book - Third edition.
1. A little background Introduction to databases What is SQL? What is MySQL? SQL unplugged What's in store 2. Creating and populating a database Creating a MySQL database Using the mysql command-line tool MySQL data types Table creation Populating and modifying tables When good statements go bad The Sakila database 3. Query primer Query mechanics Query clauses The select clause The from clause The where clause The group by and having clauses The order by clause 4. Filtering Condition evaluation Building a condition Condition types Null : that four-letter word
5. Querying multiple tables What is a join? Joining three or more tables Self-joins 6. Working with sets Set theory primer Set theory in practice Set operators Set operation rules 7. Data generation, manipulation, and conversion Working with string data Working with numeric data Working with temporal data Conversion functions 8. Grouping and aggregates Grouping concepts Aggregate functions Generating groups Group filter conditions
9. Subqueries What is a subquery? Subquery types Noncorrelated subqueries Correlated subqueries When to use subqueries Subquery wrap-up 10. Joins revisited Outer joins Cross joins Natural joins 11. Conditional logic What is conditional logic? The case expressions Examples of case expressions 12. Transactions Multiuser databases What is a transaction? 13. Indexes and constraints Indexes Constraints
Analytic function concepts
17. Working with large databases
Introduction to Apache Drill
Quering files using Drill
Quering MySQL using Drill
Querying MongoDB using Drill
Drill with multiple data sources
Appendix A : ER diagram for example database
Appendix B : solutions to exercises.
