In this advanced SQL course, you’ll learn how to add If-Else logic to queries using CASE statements, and how to use string functions to get just the part of text you need. Subqueries enable you to dynamically grab data from anywhere in a database and use that result in another query.
You (or someone else) may not have the database permissions to query tables directly, so learn how to query using Views instead of tables. Finally, you’ll learn how to use functions with parameters and how to execute reusable stored procedures.
By the end of this advanced hands-on course, you’ll know more in-depth SQL techniques that better prepare you for a job in data analysis, data science, or any role requiring you to use SQL to work with data in databases.
SQL proficiency equivalent to our SQL Level 2 course is required, including JOINs, aggregate functions, GROUP BY and HAVING, as well as working with CAST and date/time.
Build practical skills by working through guided projects designed to reinforce learning
Course resources are shaped through repeated instruction to support outcomes
Amazing experience. The professor really broke down the material and made sure I understood it. I would definitely recommend this class or school to anyone. Truly loved it!
— David G.
Classes are led by professionals who combine real-world expertise with proven teaching abilities
Return to the course at no cost to review concepts and strengthen your skills
Attend this course live online or as self-paced training. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
Unlike other providers, these are not mass open-enrollment classes. At CreativeLive, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
Learn at your own pace with pre-recorded video lessons and hands-on exercises. Work through the material on your schedule with access to course content and resources.
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
We offer a single free retake of the class within a year.
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
Learn practical skills by working on real projects with instructor guidance and lectures to strengthen and improve your skill.
