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 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

  • Lesson 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 Match Details
  • Lesson 2: Utilizing Conditional Operators - LIKE, IN, and BETWEEN
    • First Half Match Events
    • Filtering Match Events with BETWEEN
    • Finding Matches from 2005
    • Utilizing Conditional Operators in SQL
    • Utilize SQL Conditional Operators
  • Lesson 3: Mastering Subqueries for Data Analysis
    • Fixing Errors in Subqueries
    • Subqueries in Action
    • Refining Event Timing Queries
    • Mastering Subqueries for Data Analysis
    • Subquery Magic in Action
  • Lesson 4: Complex Queries and Conditional Logic
    • Categorize Matches with IF Function
    • Categorize Matches by Date
    • Categorize Match Events by Minutes
    • Creating and Querying Match Statistics in SQL
    • Categorizing Match Events with SQL

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.