Ditch Stackoverflow and get a comfortable grasp on the most important language in data and software engineering. Suitable for those who are brand new to SQL, or engineers who have managed to squeak by with a limited knowledge of SQL (most of us, probably). Define database table schemas, write moderately complex queries to SELECT/UPDATE/DELETE data, and perform actions like JOINs and aggregates.
What You'll Learn
- Defining tables from scratch with proper indexes and data types
- Internalize everyday queries to select or modify data
- Effectively designing tables to leverage foreign key relations
- Execute and fully understand JOINs
- Aggregate data to extract deeper meaning from SQL tables
For those who...
- Are new to SQL or relational databases
- Have mediocre knowledge of SQL and could benefit from filling the gaps
- Have PHDs in statistics but think they can get by without knowing SQL