SQL Server Level III

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 will learn how to complete complex tasks in Microsoft SQL Server through hands-on projects.

Learn how to employ If-Else logic to queries through CASE statements, use string functions to extract specific text, and retrieve data from anywhere in a database via subqueries. You'll also find out how to query using Views instead of tables when you do not have the required database permissions and become knowledgeable about functions and stored procedures to make your SQL code reusable, adaptable, and reproducible.

Upon completion of this course, you will be better equipped to pursue a career in data analysis, data science, or any other role that requires you to use SQL to manipulate data in relational databases.

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.

What You’ll Learn at a Glance

• Use Subqueries to grab data from anywhere in a database and use that result in another query
• Query from Views instead of tables
• Add If-Else logic to queries using CASE
• Learn how to use Functions, and execute reusable Stored Procedures
• Use String Functions to get just the part of text you need

Course Syllabus

• Advanced Query Techniques
• Subqueries
• Aggregate Window Functions
• Conditionals with CASE
• String Functions
• Self Join
• Views, Functions, & Stored Procedures
• Using Views
• User-Defined Functions with Parameters
• Executing Stored Procedures

Learn more about SQL Server Level III at NYIM Training.