Learning SQL Programming

Introduction

• Learning SQL programming
• Exercise files
• Exploring DB Browser for SQLite
• CoderPad tour
• 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
• 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
• 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
• Solution: State score metrics

4. Add or Modify Data

• Add data to a table
• Modify data in a table
• Removing data from a table
• Solution: Identifying the correct record

Conclusion

• Overcoming common SQL mistakes
• Next steps