SQL Level III (Live Online)

Take your SQL skills to the next level in this advanced course. You’ll learn about subqueries, views, functions, stored procedures, and more.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 the how variables, functions, and stored procedures can be used to make SQL code more reusable, flexible, and repeatable.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.This course has a prerequisite: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.Learn more about SQL Level III at NYC Career Centers.