Table Relations and Normalization
In the fourth lesson of this SQL Intermediate course, you’ll focus on how to create and normalize database tables to increase your knowledge of SQL and add knowledge of relational database concepts to your toolbox. On occasion, you will be asked to create a database by yourself or to normalize a database. This mission will get you up-to-speed on relational database concepts so you can have a complete conceptual idea of how everything works when using SQL.
Using our platform’s SQLite shell, you’ll get hands-on practice with creating a database tables, inserting data into tables and more. You will also learn about primary and foreign keys, which are critical concepts to understand the underlying concept of the types of joins we learning about in the Joining Data in SQL mission. In addition, you will have learn about database normalization, which is a process to minimize duplicated data, avoid data modification issues, and to simplify queries!
- 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
- The SQLite Shell
- Creating Tables
- Primary and Foreign Keys
- Database Normalization
- Inserting and Deleting Rows
- Adding Columns to a Table
- Adding Values to Existing Rows
- Challenge: Adding Sales Tax Capabilities
- Next Steps