Intro to SQL with Taylor Swift

Journey into SQL with Taylor SwiftIntro to SQL with Taylor Swift

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.

Lessons and practices

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

Interested in this course? Learn and practice with Cosmo!

Practice is how you turn knowledge into actual skills.