Overview
Learn the basics of SQL, the programming language for retrieving and editing data from databases such as SQL Server, MySQL, MariaDB, and PostgreSQL.
Syllabus
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