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