Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.
Super helpful. Peter is a great teacher and he makes sure nobody falls behind. And we have covered all the material in-depth! Definitely recommend!
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.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
For cancellations and reschedules, please email us at [email protected]
Students have much positive feedback about classes at SQL Level III, particularly praising the instructor, Peter. They describe him as amazing, clear, well-structured, informative, helpful, and a great teacher. Students appreciate that Peter ensures nobody falls behind and that the material is covered in-depth. As a result, students feel confident in recommending these classes. Quotes: 1. "Peter is a great teacher and he makes sure nobody falls behind." 2. "Very clear, well structured." 3. "And we have covered all the material in-depth!"
Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.
Our courses are instructor-led in small class sizes, located in our state-of-the-art training...
Read more about NYC Career Centers
This school has been carefully vetted by CourseHorse and is a verified Online educator.
Booking this class for a group? Find great private group events
Or see all Professional Group Events
Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.