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