MISSION 192

Table Relations and Normalization

Master SQL and learn how to create and modify databases.

Objectives

  • How to use the SQLite shell to work with databases
  • Master SQL concepts and create and normalize database tables
  • How to insert and update data in database tables

Mission Outline

1. The SQLite Shell
2. Creating Tables
3. Primary and Foreign Keys
4. Database Normalization
5. Inserting and Deleting Rows
6. Adding Columns to a Table
7. Adding Values to Existing Rows
8. Challenge: Adding Sales Tax Capabilities
9. Next Steps
10. Takeaways

sql-joins-relations

Course Info:

SQL Intermediate: Table Relations and Joins

Intermediate

The median completion time for this course is 6.8 hours.

This course requires a basic subscription and has four mission including two guided projects. It is the 12th course in the Data Analyst in Python path and Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside