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

CodeSignal

Intro to SQL with Taylor Swift

via CodeSignal

Overview

Kick off your data analysis journey by diving into SQL, guided by the music of Taylor Swift's discography. This course is designed to help you ask the right questions to a database, find specific information, and comprehend basic data relationships. Perfect for beginners, all you need is a love for music and the curiosity for data.

Syllabus

  • Lesson 1: Discovering SQL and Taylor Swift's Discography - Your First Database Query
    • Running Your First SQL Queries
    • Unveiling all Records from an Album Table
    • Unveiling Specific Album Details
    • Unveiling the database's tables
    • Exploring Database Tables with SQL
  • Lesson 2: Navigating the SQL SELECT Statement
    • Retrieving Specific Columns from a Table
    • Renaming Columns in SQL Output
    • Reverse the Query Order
    • Fetching and Renaming Columns in SQL
    • Writing SQL Statement from Scratch
  • Lesson 3: Filtering the Hits: Using WHERE Clause in SQL
    • Running Your First WHERE Clause
    • Fetch Albums Released After 2012
    • Selecting Albums Released After a Specific Year
    • Debugging the SQL Query
    • Album Hunt with SQL After 2010
  • Lesson 4: Mastering Logical Operators in SQL with Taylor's Tunes
    • Logical AND Operator in Action
    • Discovering Popular or Long Songs
    • Selecting Songs: Mastering the IN Operator
    • Mastering the NOT Operator in SQL
    • Combining SQL Operators: A Deep Dive
  • Lesson 5: Understanding the ORDER BY Clause in SQL
    • Start from All Album Query
    • Sorting Swift's Albums by Release Date
    • Descending into the Music: Album Sorting
    • Sorting Albums after Specific Year
    • Filtering Taylor Swift's Albums by Release Date
    • Mastering Descending Order in SQL Queries

Reviews

Start your review of Intro to SQL with Taylor Swift

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.