SQL for Non-Programmers

Introduction

• Why SQL and why now?
• What you should know
• Set up with SQLite and SQLiteStudio

1. Getting Started with Relational Databases, SQL, and DQL

• Relational databases
• Database structuring through normalization
• The power of SQL
• DQL for all

2. Basic Commands

• Getting started with SQL
• Retrieving data with SELECT
• Formatting your query
• Putting order to your data with ORDER BY
• Filtering your data with WHERE
• Filtering your data with multiple conditions
• Challenge: Practice with basic commands
• Solution: Basic commands solved

3. Aggregate Functions

• Getting started with aggregate functions
• Making aggregate functions work for you
• Group data using GROUP BY
• Filter on groups of data with HAVING
• Challenge: Practice with aggregate functions
• Solution: Aggregate functions solved

4. Multiple Table Joins

• Combining tables with an Equijoin
• From Equijoins to Inner Joins
• Other types of SQL joins
• Challenge: Practice with multiple table joins
• Solution: Multiple table joins solved

5. Advanced Commands

• Categorize data with CASE
• Beyond basic CASE statements
• Creating Calculated Fields
• Matching data with wildcards
• Combining data with UNION
• Challenge: Practice with advanced commands
• Solution: Advanced commands solved

6. Conclusion

• Recommendations and next steps