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).
Register for a Class
Choose a date below to add it to your cart. At checkout, you can change the quantity for multiple registrants, add other classes, and change your dates.
Corporate training available
What You'll Learn:
- 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
- Format data for reporting with data conversion techniques
“Great Class. Super intense. Love the fact that you can retake it once free of charge.”
Full Course SyllabusDownload PDF Outline
Saving Queries Programmatically
1) Benefits versus Shortcomings
4) Stored Procedures
5) Layered Views
6) Protect Views with Schema binding
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
Data Conversion Functions
19) String Functions
20) Cast Function
21) Convert Function
22) Rounding Functions
23) Creating Views
24) Sub Queries
25) Advanced Functions
26) Logic and Date Functions
27) Conversion Functions
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.