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.
Need a custom curriculum for your team? Contact us
What You Will Learn
Build a solid foundation with core concepts and essential skills.
Course Curriculum
2 modulesDay 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
- Write SELECT queries with filtering, sorting, and aggregation
- Join multiple tables to combine related data
- Use string, date, and conditional functions in queries
- Understand relational database design principles
Who Is This For
- Data analysts and business intelligence professionals
- Developers working with databases
- Anyone who needs to query and manage relational data
Prerequisites
Basic data literacy. No prior SQL experience required for the Fundamental level.
Frequently Asked Questions
Do 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.
Which 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.
Is 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.
How 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.
Will 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.
Can 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.
Ready to master SQL?
Get in touch to discuss scheduling, group rates, or a customized curriculum for your team.