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. To write high-quality SQL, it’s important to make sure that the results are accurate, the code is understandable to others, and the query performs efficiently. This course will cover all of these topics with examples, live-coding sessions and projects that are designed to emulate real-world data challenges. Learners will use Snowflake to write SQL and this course will cover the essentials of writing and analyzing SQL queries in Snowflake.
Course taught by expert instructors
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.
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
Use SQL to answer questions within a complex dataset.
- Data types in SQL
- Data cleaning
- Pivoting & unpivoting
- Nested and semi-structured data
- Flattening & unflattening data
- Nested object queries
Rework a query to improve its readability.
- The SQL style guide
- Complex joins
- Subqueries & CTEs
- Window functions
Write an event-based query that will scale with business growth.
- SQL performance fundamentals
- SQL in Snowflake
- Query plans
- Tuning queries & joins
Evaluate a candidate's SQL tech exercise.
- SQL tech exercises for candidates
- Key business terms & metrics
- Data discovery
- Evaluating a sample tech exercise
A course you'll actually complete. AI-powered learning that drives results.
Transform your learning programs with personalized learning. Real-time feedback, hints at just the right moment, and the support for learners when they need it, driving 15x engagement.
Live courses by leading experts
Our instructors are renowned experts in AI, data, engineering, product, and business. Deep dive through always-current live sessions and round-the-clock support.
Practice on the cutting edge
Accelerate your learning with projects that mirror the work done at industry-leading tech companies. Put your skills to the test and start applying them today.
Flexible schedule for busy professionals
We know you’re busy, so we made it flexible. Attend live events or review the materials at your own pace. Our course team and global community will support you every step of the way.
Each course comes with a certificate for learners to add to their resume.
15-20x engagement compared to async courses
Support & accountability
You are never alone, we provide support throughout the course.
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.