Introduction to SQL
A comprehensive introduction to SQL covering database fundamentals, query syntax, filtering, joining tables, aggregations, and working with data.
Topic 1: SQL Introduction and Fundamentals
Learn what SQL is, why it exists, how it differs from other languages, and fundamental concepts before writing queries.
Topic 2: Database Fundamentals
Learn what databases are, why they exist, relational database concepts, tables, rows, columns, keys, and relationships.
Topic 3: Writing SQL Queries
Learn how to write SQL queries including SELECT statements, WHERE clauses, filtering, and sorting results.
Topic 4: Sorting and Summarizing Data
Learn how to sort results with ORDER BY and summarize data using aggregate functions like COUNT, SUM, AVG, MIN, MAX, and GROUP BY.
Topic 5: Joining Tables
Learn how to join multiple tables together using INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.
Topic 6: Improving Your SQL Thinking
Learn how to think about SQL queries, approach problem-solving, and write effective SQL queries.
Course Progress
Enroll to start learning!
Course Stats
- Total Topics 6
- Total Lessons 11
- Total Sessions 25
- Total Notes 26
- Estimated Time 10.3 hours
This course is only available through program enrollment.
View Program: Full Stack Development