MISSION 192

Table Relations and Normalization

Learn how to create and modify databases.

Objectives

  • How to use the SQLite shell to work with databases
  • How to 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

Course Info:

SQL Intermediate: Table Relations and Joins

Intermediate

The average completion time for this course is 10-hours.

This course requires a basic subscription and has six 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

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit