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 and 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.