Database 08: Introduction to Relational Database Design #1

In this video I'll show you the absolute basics of Database design. What to think about when designing a database, and how it can affect the future of your data if not done correctly. You'll see how to: 1) Create a database/schema 2) Create a table within that database 3) Insert data into the table 4) Creating additional tables related to your first using the model editor 5) Some things NOT to do 6) What happens if you make a mistake in the design Bill Sky the Database Guy Playlist: https://www.youtube.com/playlist?list=PLdG1SnrYXH0HiW1Swn_loPFFk2gjTjrwS Database 09 (Next): Designing the Basics of a Real Database: https://youtu.be/WjODlAzqqdA 00:00 Introduction and Importance of Design 03:00 Parts of designing a database 07:06 Creating a Database in MySQL Workbench 08:32 Viewing the DDL that creates the database 10:21 Creating a Table with Columns/Attributes 11:21 Some Column data types 14:46 A tables DDL statements when creating one 16:00 Deciding upon a Primary Key 20:57 Modifying the Table with a Related Table 21:47 Using the Modeling tool to Design your Database Correctly 24:00 Creating a second, related table 31:42 Synchronizing your Model with the actual Database 35:24 Viewing and inserting data using the workbench 38:21 Modifying your design - I did it wrong the first time! 40:06 Inserting data and its related Data 43:50 Improving your design by adding another table to the database 53:12 In Summary