Advanced SQL
This course will take learners from just being comfortable with SQL to being 100% confident in their knowledge and ability to apply it effectively in the real-world. This journey includes having full confidence in query accuracy, maintainability/understandability, and efficiency. The course will focus on bringing all of these topics together to leave learners confident they can assess, improve, and maintain complex SQL code on realistic data.
Course taught by expert instructors
Meredith Alder
Founding Engineer at Bluesky
Meredith is a founding engineer at Bluesky, a leading SaaS tool that provides intelligent workload optimization and cost governance. She has extensive experience with data architecture using Snowflake, Amazon Redshift, Microsoft Azure, and Google Cloud Platform. Her years of consulting have given her a realistic perspective on the challenges data teams face today. Meredith is always excited to share her own experiences with other team leaders and data practitioners.
The course
Learn and apply skills with real-world projects.
Junior Analytics Engineer. Some experience with SQL, and want to get more comfortable
Data Scientist / SWE who wants to get more comfortable with SQL
Basic SQL proficiency; You are comfortable writing simple SQL queries but are not as comfortable with complicated joins, window functions, etc.
Try these prep courses first
- Learn
- Data types in SQL
- Data cleaning
- Pivoting & unpivoting
- Nested and semi-structured data
- Flattening & unflattening data
- Nested object queries
Use SQL to answer questions within a complex dataset.
- Learn
- The SQL style guide
- Complex joins
- Subqueries & CTEs
- Aliases
- Window functions
- UDFs
Rework a query to improve its readability.
- Learn
- SQL performance fundamentals
- SQL in Snowflake
- Query plans
- Tuning queries & joins
- Fanout
Write an event-based query that will scale with business growth.
- Learn
- SQL tech exercises for candidates
- Key business terms & metrics
- Data discovery
- Documentation
- Evaluating a sample tech exercise
Evaluate a candidate's SQL tech exercise.
Real-world projects
Work on projects that bring your learning to life.
Made to be directly applicable in your work.
Live access to experts
Sessions and Q&As with our expert instructors, along with real-world projects.
Network & community
Core reviews a study groups. Share experiences and learn alongside a global network of professionals.
Support & accountability
We have a system in place to make sure you complete the course, and to help nudge you along the way.
Get reimbursed by your company
More than half of learners get their Courses and Memberships reimbursed by their company.
Hundreds of companies have dedicated L&D and education budgets that have covered the costs.
