Mastering Your Data with SQL

1. 1

   Get Your First Answers

   • Asking for what you want
   • Looking at specific columns
   • Giving your columns better names
   • Limiting the number of results
2. 2

   Finding Exactly What You Need

   • Filtering with simple rules
   • Using math to find ranges
   • Searching for text patterns
   • Checking for missing information
   • Combining multiple rules at once
   • Excluding the things you don't want
3. 3

   Organizing and Cleaning Your Results

   • Sorting from A to Z
   • Handling ties in your sorting
   • Removing duplicate rows
4. 4

   Summarizing Big Data

   • Counting your items
   • Finding totals and averages
   • Picking out the highs and lows
   • Grouping items into categories
   • Filtering your groups
5. 5

   Connecting Different Data Sources

   • The secret to why data is split up
   • Matching rows between two tables
   • Keeping data even when there is no match
   • Joining more than two tables
6. 6

   Smart Data Transformations

   • Doing math across columns
   • Creating 'If-Then' logic in your results
   • Cleaning up messy text
   • Working with dates and times
   • Changing data types on the fly
7. 7

   Advanced Questioning Techniques

   • Putting a query inside another query
   • Using temporary result sets
   • Comparing a row to the one before it
   • Ranking your data
8. 8

   Building and Changing Databases

   • Creating your own tables
   • Adding new rows of data
   • Updating existing information
   • Deleting what you don't need
   • Changing the structure of a table
   • Setting rules to keep data clean
9. 9

   Speed and Performance

   • Why some queries are slow
   • Using indexes to speed things up
   • Reading an execution plan
10. 10

    The Engine Under the Hood

    • How the database actually reads your code
    • The history of the SQL standard
    • Differences between MySQL, Postgres, and others
    • Designing a perfect database from scratch

10 sections · 44 units · 220 levels. Built to play, not to enroll.