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

CodeSignal

Advanced Query Techniques and Conditional Logic in SQL

via CodeSignal

Overview

This course is designed to help you deepen your SQL expertise, focusing on mastering subqueries, AND/OR logical operators, and conditional statements like LIKE, IN, and BETWEEN. Ideal for those with a basic understanding of SQL, looking to enhance their data querying capabilities.

Syllabus

  • Lesson 1: Mastering Logical Operators: The Art of Data Filtering with AND/OR in SQL
    • Fixing SQL Queries with Logical Operators
    • Mastering Logical Operators in SQL Queries
    • Using OR Operator in SQL Queries
    • Fixing Logical Errors in SQL Queries
    • Filtering Songs Using Logical Operators
  • Lesson 2: Mastering SQL Conditional Operators: Harnessing LIKE, IN, and BETWEEN
    • Fix the Bug: SQL Query Mishap
    • Fetching Songs from Specific Albums
    • Fetch Songs from Specific Albums
    • Mastering the BETWEEN Operator in SQL
    • Fixing the SQL Query Mishap
    • Retrieving Songs Within Specific Duration Range
  • Lesson 3: Mastering Subqueries for Elevated Data Analysis
    • Fixing Subqueries: Retrieving High Energy Songs
    • Subqueries with Average Function in Real World Situation
    • Filtering Songs by Energy and Danceability Using Subqueries
    • Fixing a Subquery for Energy Analysis
    • Mastering Subqueries: Songs Above Average Energy
  • Lesson 4: Mastering Conditional Logic with IF and CASE Statements in SQL
    • Fixing Errors in Song Popularity Categorization
    • Implementing Conditional Logic in SQL
    • Classifying Song Energy Levels with SQL
    • Unraveling SQL Query Bug
    • Categorizing Song Energy Levels in an Album

Reviews

Start your review of Advanced Query Techniques and Conditional Logic in SQL

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.