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

Go to class Write review

Overview

This advanced SQL course will enhance your ability to write complex queries, use conditional logic, and conduct sophisticated data analysis. Ideal for learners who have mastered basic SQL and are eager to tackle more challenging problems.

Syllabus

  • Unit 1: Logical Operations with AND in SQL Queries
    • Fix SQL Query Syntax Error
    • Logical Operations in SQL Queries
    • Refining SQL Queries with Conditions
    • Logical Operations with AND/OR in SQL Queries
    • Retrieve Specific Order Details
  • Unit 2: Utilizing Conditional Operators - LIKE, IN, and BETWEEN
    • Fix the SQL Query for Retrieving Products
    • Filtering Products with BETWEEN
    • Finding Orders from 2022
    • Utilizing Conditional Operators in SQL
    • Utilize SQL Conditional Operators
  • Unit 3: Mastering Subqueries for Data Analysis
    • Fixing Errors in Subqueries
    • Subqueries in Action
    • Refining Product Pricing Queries
    • Mastering Subqueries for Data Analysis
    • Subquery Magic in Action
  • Unit 4: Complex Queries and Conditional Logic
    • Categorize Orders with IF Function
    • Categorize Orders by Date
    • Categorize Products by Price
    • Creating and Querying Products Statistics in SQL
    • Categorizing Products with SQL

Reviews

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

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.