Take your SQL skills to the next level by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and performing advanced JOINs. Unlock the power of SQL to extract and analyze data with precision and turn it into actionable insights.
.jpg?auto=format%2Cenhance%2Ccompress&crop=entropy&fit=crop&h=480&ixlib=php-1.2.1&q=60&w=720)
Great experience, I learned a good deal and feel much more confident in my skills after this class. It’s the right value for what I paid for. I had finished a couple of free tutorials on sql before this intermediate class and was able to hold my own.
Expand your SQL skills by learning how to group data with aggregate functions, filter groups with HAVING, work with dates/time, perform advanced JOINS such as Self Join and Union, and more.
In this intermediate SQL course, you’ll build on your knowledge of SQL fundamentals, enhancing your skills to filter, group, and analyze data.
You’ll learn how to group data and perform common statistical calculations using aggregate functions. Working with data requires the ability to change the data type when it’s not what you need (using CAST), and to be able to work with and format date and time information. Finally, you’ll learn additional types of joins such as self join and union.
By the end of this intermediate hands-on course, you’ll know more SQL techniques to extract and analyze the specific data you want from the database. This will enable you to more easily turn raw data into actionable insights.
Prerequisite:
SQL proficiency equivalent to our SQL Level 1 course is required, including basic querying, fundamentals of filtering (WHERE, LIKE, and wildcards), and inner JOINs.
Learn more about SQL Level II 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 who took SQL Level II found the class to be a great experience and felt more confident in their skills afterwards. They appreciated the value for the price they paid. The instructor, Professor Peter, was praised for his ability to cover a lot of material in a smooth fashion and for being patient and helpful. Students also enjoyed the fast pace of the class and the fact that they could retake it for free if needed. Overall, the class was described as informative, well-paced, and a great opportunity for continued learning. Quotes: 1. "This class was as good as the 1st! Peter was the instructor and he does an amazing job teaching all the material and going over it." 2. "The instructor, Pete, knows the material very well and uses business situations to demonstrate." 3. "The course covered what I needed to know, and was run at about the level I was hoping for."
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 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.
CourseHorse Staff
CourseHorse Gift Card
