Database Foundations: Data Structures [Updated: 10/24/2024]
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 3h 41m | 618 MB
Instructor: Adam Wilbert

This course focuses on seven core concepts: data types, designing a normalized database, identifying rows with primary keys, linking data with foreign keys, formalizing data relationships, indexes, and constraints. Database expert Adam Wilbert describes techniques that database developers use to protect their data. He explains why data types are important in creating a consistent data storage environment, then walks you through several common data types. Adam shows you the three normal forms of good database design.

Adam steps you through how to incorporate primary keys and foreign keys into the design of your database tables. He walks through data relationships, indexes, and constraints, then concludes with other courses you may find useful.

Learning objectives

• Assess the impact of precision levels for time-based data types in databases.
  
• Evaluate suitable data types for storing currency values in a multinational scenario.
  
• Differentiate between primary keys in relational databases and data organization in spreadsheets.
  
• Apply many-to-many relationships through linking tables.
  
• Explain the role of indexing primary key columns in data retrieval efficiency.
  
• Demonstrate understanding of default value behavior during row insertions in databases.
  

[To see links please register or login]