Yelp Facebook LinkedIn YouTube Twitter Instagram

SQL Level II

Intermediate SQL Classes in NYC

In this intermediate level course, you'll build on your knowledge of SQL fundamentals to enhance your skills in using SQL to analyze data.

You'll learn how to find data that meets your specific search criteria using views, subqueries, math functions, and logic statements. You'll also learn how to use data conversion functions to manipulate data and increase report readability.

Ultimately, the functions and features taught in this course make SQL easier to use; by the end of SQL II, you'll have a strong command of how to use SQL to meet your specific data analysis needs.

SQL Level II is taught at our affiliate school, NYIM Training, in Midtown Manhattan.

Read more
  • Small Classes
  • Computer Provided
  • Book included
  • Free Retake

Register for a Class
  • $325
  • 8 Hours
  • PC only
  • 185 Madison Ave, NYC

Corporate training available

Email

This course is offered at our business training school, NYIM Training, in Midtown Manhattan. Register for this course directly on NYIM’s website.

Register at training-nyc.com

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
View full syllabus

SQL Level II Class Syllabus

Saving Queries Programmatically
  • Benefits versus Shortcomings
  • Views
  • Functions
  • Stored Procedures
  • Layered Views
  • Protect Views with Schema binding
  • Create Top Value Views
Sub Queries
  • What is a Sub Query?
  • Clarity and Transparency
  • Single Table Sub Query
  • Multiple Table Sub Query
  • Exists versus In Operators
  • Any versus All Operator
Math, Advanced Functions and Logic Statements
  • Basic Math
  • Advanced Date and Time Functions
  • Advanced Text Functions
  • Case When Then Logic Statements
  • Variables and User Functions
Data Conversion Functions
  • String Functions
  • Cast Function
  • Convert Function
  • Rounding Functions
Student Labs
  • Creating Views
  • Sub Queries
  • Advanced Functions
  • Logic and Date Functions
  • Conversion Functions

Enhance Your Skills and Maximize Your Data Analysis Capabilities

Market yourself to employers and clients as a capable and confident data analyst. In this course, our expert instructors guide you through advanced functions and queries to help you generate and read high-quality data reports. All of our SQL courses incorporate hands-on activities to learn and practice techniques as well as a culminating project-based lab to master the skills presented.

5
4.9
4.9

Expert Instructors

Our instructors are industry professionals who draw on their experience to teach practical techniques and time-saving strategies for database management. Extend your knowledge beyond beginner-level features while learning how to maximize your efficiency within your professional context. 

Instructor teaching student SQL

Activity-Based Learning with Real-World Examples

Engage in activities and projects that use relevant, real-world examples to introduce and practice new concepts. Through immediate, purposeful practice with step-by-step support, you'll learn quickly and be able to practice and apply new skills in no time! 

SQL database class example

Related Classes & Certificates

SQL Bootcamp

18 Hours

$975

More details

SQL Server Bootcamp

24 Hours

$915

More details

SQL Level I

8 Hours

$325

More details
See all related classes & certificates