Welcome to SQL

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