SQL
Learn SQL from your first SELECT statement to advanced joins, subqueries, and stored procedures. This course gives you the skills to query, analyze, and manage data in any relational database.
03
Levels
10
Modules
1:1
Live
What you will learn.
A snapshot of every topic covered across all three levels. Detailed daily curriculum is in the next section.
Three levels.
One path.
Start where you are. Each level builds on the last — from your first formula to enterprise-grade automation.
Build a solid foundation with core concepts and essential skills.
Modules
02 / TOTALDay 1: Querying Data with SQL
- Understanding relational databases, tables, and schemas
- Writing SELECT statements with WHERE, AND, OR, NOT
- Sorting results with ORDER BY and limiting with TOP/LIMIT
- Filtering with LIKE, IN, BETWEEN, and IS NULL
- Aggregate functions: COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING for summarized results
- Column aliases and basic expressions in queries
Day 2: Joins, Functions, and Data Types
- INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
- Joining multiple tables in a single query
- String functions: UPPER, LOWER, LEN, SUBSTRING, CONCAT
- Date functions: GETDATE, DATEADD, DATEDIFF, FORMAT
- CASE expressions for conditional logic in queries
- UNION and UNION ALL for combining result sets
- Introduction to database design and normalization basics
After this level
- 01Write SELECT queries with filtering, sorting, and aggregation
- 02Join multiple tables to combine related data
- 03Use string, date, and conditional functions in queries
- 04Understand relational database design principles
Built for doers.
Prerequisites
Basic data literacy. No prior SQL experience required for the Fundamental level.
- 01Data analysts and business intelligence professionals
- 02Developers working with databases
- 03Anyone who needs to query and manage relational data
01Do I need any prior programming experience to learn SQL?
No. The Fundamental level starts from scratch and assumes no prior SQL or programming experience. If you understand basic spreadsheet concepts, you can learn SQL.
02Which database system does this SQL course use?
We primarily use Microsoft SQL Server, but the SQL concepts apply to any relational database including PostgreSQL, MySQL, and Oracle. You will learn standard SQL that works everywhere.
03Is this SQL course available online?
Yes. All sessions are delivered live via virtual classroom. On-site training is also available for teams in Ottawa and Ontario.
04How long does it take to learn SQL?
Each level is 2 days of training. Most students can write useful queries after the Fundamental level. The full program is 6 days across all three levels.
05Will I receive a certificate?
Yes. You receive a GrowWM certificate of completion for each level that you can share with employers or add to your LinkedIn profile.
06Can I use SQL skills in Excel and Power BI?
Absolutely. SQL is the foundation for Power Query, Power BI data connections, and many analytics tools. SQL skills transfer directly to better data analysis in any platform.