Lesson 1: Setting Up the Work Environment
Lesson 2: Let's Start Learning SQL Code
Lesson 3: Working with Characters & Numbers
Lesson 4: Using SQL Wildcards
Lesson 5: Indentifying Rows & Connecting Tables
Lesson 6: Inner vs. Outer Joins
Lesson 7: Changing Data Types
Lesson 8: Working with Dates
Lesson 9: Organizing Statistical Results Into Categories
Lesson 10: Subqueries
Lesson 11: Aggregate Window Functions
Lesson 12: Conditionals
Lesson 13: Views
Lesson 14: String Functions
Lesson 15: Additional Resources
Lesson 16: AI and SQL
- 42 video lessons
- 10 hours and 25 minutes of class content
- Streaming access on desktop and mobile browsers
- 100% satisfaction guarantee
Turn information stored in databases into useful insights by writing SQL queries. Once you understand the basics of tables, columns, and rows, you will learn how to write queries that return the exact information you need.
You will learn how to filter data, group results, and transform raw information into meaningful insights. The course also covers how to combine data from multiple tables using joins, along with more advanced topics such as aggregate functions, subqueries, and functions with parameters.
In this hands-on course, you will use PostgreSQL and the free DBeaver application to explore databases and run the SQL queries you write. The concepts you learn in PostgreSQL can also be applied to other SQL systems, including Microsoft SQL Server and MySQL, with only minor syntax differences.
Why Learn SQL?
SQL allows you to answer questions using data stored in databases, which remain the primary way most organizations store and manage information. As nearly every industry becomes more data-driven, SQL can help you play a larger role in decision-making wherever you work.
SQL is valuable for professionals in business and in many data-focused roles, including Business Analysts, Data Analysts, Data Scientists, Web Developers, and others who work with information on a regular basis.
