This course provides a straightforward, concise resource for non-developers to learn enough about relational databases and SQL syntax to write simple queries.
Overview
Syllabus
Introduction
- How can SQL answer your data questions?
- What is SQL Server?
- Understanding servers, databases, and tables
- Relational database concepts
- Surrogate, primary, and foreign keys
- SQL data types and nullability
- Reading from a single table in SQL
- Filtering on a single condition in SQL
- Filtering on multiple conditions in SQL
- Inner joins
- Multiple inner joins
- Outer joins
- Subqueries
- Case statements
- Built-in functions
- Aggregates
- Query processing order
- Next steps
Taught by
Julianne Thouin