Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Noble Desktop

SQL Level 3

via Noble Desktop

Go to class Write review

Overview

This advanced course will take your SQL skills to the next level, where you will learn about subqueries, views, variables, functions, stored procedures, and more. Gain a deeper understanding of SQL techniques that will better prepare you for roles in data analysis, data science, and database management.

Syllabus

Advanced Query Techniques

Subqueries

  • Subqueries: Queries within queries
  • Single-Value vs Multi-Value vs Table-Value Subqueries

Aggregate Window Functions

  • Using OVER and PARTITION BY to apply Aggregate Functions

Conditionals with CASE

  • Adding If-Else Logic with CASE
  • Simple CASE vs Searched CASE
  • IIF (Inline IF)

String Functions

  • Manipulating text using string functions
  • Using SUBSTRING, LEFT/RIGHT, CHARINDEX, UPPER, etc.
  • Combining with Inline IF statements (IIF)

Self Join

  • How a Self Join is different from other types of joins
  • Using a Self Join

Taught by

Dan Rodney and Garfield Stinvil

Reviews

4.8 rating at Noble Desktop based on 257 ratings

Start your review of SQL Level 3

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.