Master views, subqueries, logic statements, and data conversions in SQL Level 2. Combine advanced SQL functions with fundamentals like inner and outer joins to proof your work. Develop your skills in SQL by writing advanced functions to gain more control in your relational DBMS (Database Management System).
Corporate training available
Video Training and Workbook Included
Students get a workbook and lifetime access to self-paced training videos, a $95 value.
Modern computer classroom with a PC for each student to work on.
Small In-Person Classes
Get personalized attention in small groups with an expert instructor in the classroom.
Refresh the course materials within six months for free as long as there's space in the class.
What You'll Learn:
- Use outer joins to analyze data
- Write and save queries to the server
- Create and edit views
- Use subqueries as an alternative to inner and outer joins
- Calculate new data field using math functions
“Great Class. Super intense. Love the fact that you can retake it once free of charge.”
Full Course SyllabusDownload PDF Outline
1) Self Joins
2) Union Joins
3) Cross Joins
Saving Queries Programmatically
6) Layered Views
7) Create Top Value Views
8) What is a Sub Query?
9) Clarity and Transparency
10) Single Table Sub Query
11) Multiple Table Sub Query
12) Exists versus In Operators
13) Any versus All Operator
Math, Advanced Functions and Logic Statements
14) Basic Math
15) Advanced Date and Time Functions
16) Advanced Text Functions
17) Case When Then Logic Statements
18) Variables and User Functions
19) Creating Views
20) Sub Queries
21) Advanced Functions
22) Logic and Date Functions
Frequently Asked Questions
Do I need to bring a computer?
No. We provide a computer with the necessary software for each attendee. This course is available on Windows PC only.
Are discounts available for this course?
No. This course is not eligible for any discounts.
We offer discounts for packages of classes, including our Excel Bootcamp, SQL Bootcamp, Data Analytics, and PowerPoint Bootcamp.
We also provide discounts for ten or more classes purchased together. Please reach out for more information on our voucher programs.
Does this course come with a book?
Yes. This course includes a complimentary book or manual at no additional cost.
What if I need to retake this course? May I retake it for free?
Yes. You may retake this course for free once within six months, provided that the class is running with an available seat. For more information, visit our policies page.
Intermediate SQL Classes New York City
Develop Advanced SQL Functions—Create subqueries and logic statements
SQL Level II dives into the functions and features that make SQL easier to use. Find rows that meet specific criteria with views and subqueries. Write advanced functions and logic statements with conditions. Manipulate data to facilitate scanning and increase readability of reports.
Like our other SQL courses, SQL Level 2 ends with a project-based lab. Activities completed in SQL Levels 1 and 2 help students retain and build upon skills. Labs in SQL Level II require students to create and edit views, write subqueries and logic and date functions, and more.
At the end of this course, you’ll be able to do the following:
Save queries to a server for all users to utilize
Create views to restrict data and draw up reports
Identify when and how to write subqueries to maximize efficiency
Perform count, sum, average and other math functions
Use data conversion functions to facilitate scanning
Take Your SQL Skills to the Next Level and Save 15%
Do you want to master all that SQL has to offer? Get the most out of your investment by enrolling in SQL bootcamp. NYIM’s SQL bootcamp delivers comprehensive instruction in beginner, intermediate, and advanced SQL in just three days. Receive 15% off when you enroll now!
In-Depth Course Overview
In SQL Level 2, you’ll learn tools and techniques related to the following commands:
Create Views - Create views to review a subset of data, and learn the advantages and restrictions when working with SQL views
Subqueries - Learn how to write subqueries and the benefits of using them instead of inner and outer table joins
Math Functions and Logic Statements - Calculate basic math functions and write logic statements to find data that meets certain conditions
Data Conversion Functions - Use data conversion functions to display numbers as text, round decimals, and format other data types
SQL Level 2 begins with lessons on SQL views. Start by reviewing the benefits and disadvantages of using views. For example, if variables are used in queries, then views won’t work. Next, you’ll jump into subqueries. Although subqueries can produce the same information as inner and outer joins, it can do so more quickly and efficiently.
Following subqueries students will learn how to write commands for basic math functions. Use SQL commands to add, subtract, multiply, and divide fields or calculate sums, averages, and counts. With logic statements, such as “CASE WHEN THEN” statements, you’ll group data into specific categories.
Finally, you’ll learn how to use data conversion functions to manipulate data types and appearance. For example, apply commas, decimals, and dollar signs to numerical data types to make it easier to scan prices in a report. The course ends with a lab, in which you’ll practice using the commands described above.
NYIM’s Advanced SQL Courses in New York City
Free course retake within six months
Custom training workbook with instructions
Small and personalized classes
Access to PC computer with SQL Server installed
NYIM offers the most practical, affordable SQL Server courses in NYC. NYIM's advanced SQL course will teach you how to harness the full power of DBMS (Database Management Systems). Our live, in-person SQL classes are instructor-led with custom training materials and comprehensive review exercises each session.