Learning SQL Programming

Learn the basics of SQL, the programming language for retrieving and editing data from databases such as SQL Server, MySQL, MariaDB, and PostgreSQL.

Introduction

• Learning SQL programming
• Exercise files
• Exploring DB Browser for SQLite
• What is a database?
• What is SQL?

1. Ask for Data from a Database

• Ask for data with SELECT
• Narrow down a query with WHERE
• Adding more criteria to a statement
• Broadening and limiting responses
• Organize responses with ORDER BY
• Find information about the data
• Challenge: Retrieve data from the database
• Solution: Retrieve data from the database

2. Ask for Data from Two or More Tables

• Ask for data across two or more tables
• Understand JOIN types
• Grouping results
• Challenge: Practice with JOINs
• Solution: Practice with JOINs

3. Data Types, Math, and Helpful Features

• Data types in SQL
• Math in SQL
• Compound Select
• Transforming data
• Creating aliases with AS
• Challenge: Calculate participant metrics
• Solution: Calculate participant metrics

4. Add or Modify Data

• Add data to a table
• Modify data in a table
• Removing data from a table
• Challenge: Practice working with data
• Solution: Practice working with data

Conclusion

• Overcoming common SQL mistakes
• Next steps