SQL Level III
Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.
- Advanced
- 18 and older
- $425
- 185 Madison Ave, New York, NY & Virtually Online
Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.
No Booking Fees. Lowest Price Guaranteed. Earn Rewards.
Give as a Gift Save to WishList58 people wishlisted
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.
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!"
Get quick answers from CourseHorse and past students.
People who viewed this class also viewed the following classes
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 NYC educator.
NYC Career Centers
Midtown, Manhattan
185 Madison Ave Suite 1104
At E 34th St
New York, New York 10016 Midtown, Manhattan
185 Madison Ave Suite 1104
At E 34th St
New York, New York 10016
We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.
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.
More in Microsoft Servers
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.