Database Foundations: Data Structures

Focused View

Adam Wilbert

2:56:52

70 View

01 - Introduction

01 - Organizing data in a database.mp4

00:54

02 - What you should know.mp4

00:40

03 - Making the most of the exercise files.mp4

01:04

04 - Set up the database servers.mp4

07:23

02 - 1. Data Types

01 - Data integrity concepts.mp4

04:52

02 - The role of data types.mp4

03:55

03 - Numeric data types.mp4

06:21

04 - Character data types.mp4

06:33

05 - Date and time data types.mp4

06:24

06 - Additional common types.mp4

05:34

07 - Challenge Choosing data types.mp4

01:16

08 - Solution Choosing data types.mp4

07:21

03 - 2. Design a Normalized Database

01 - Protect data integrity with normalization.mp4

04:10

02 - First normal form.mp4

03:16

03 - Second normal form.mp4

03:27

04 - Third normal form.mp4

03:03

05 - Denormalization considerations.mp4

04:11

04 - 3. Identify Rows with Primary Keys

01 - Purpose of a primary key.mp4

03:55

02 - Establish the tables primary key.mp4

06:59

03 - Natural keys.mp4

02:42

04 - Composite keys.mp4

05:33

05 - Surrogate keys.mp4

04:40

06 - Challenge Add a primary key to a table.mp4

00:53

07 - Solution Add a primary key to a table.mp4

05:51

05 - 4. Link Data with Foreign Keys

01 - What are foreign keys.mp4

02:01

02 - Add a foreign key column to a table.mp4

04:37

03 - Create a relationship between tables.mp4

06:50

04 - IDENTITY column sequences.mp4

01:36

06 - 5. Formalize Data Relationships

01 - One-to-many relationships.mp4

02:13

02 - One-to-one relationships.mp4

01:27

03 - Many-to-many relationships.mp4

02:14

04 - Self-referencing relationships.mp4

01:56

05 - Cascade updates and deletes.mp4

04:35

06 - Challenge Link tables with keys.mp4

01:08

07 - Solution Link tables with keys.mp4

06:23

07 - 6. Indexes

01 - Table indexes.mp4

03:31

02 - Add indexes to a table.mp4

03:37

03 - View index statistics.mp4

06:57

08 - 7. Constraints

01 - Validate data with constraints.mp4

03:09

02 - Null constraints.mp4

05:34

03 - Unique constraints.mp4

03:46

04 - Setting default values.mp4

03:14

05 - Check constraints.mp4

03:08

06 - Challenge Add constraints to a table.mp4

00:46

07 - Solution Add constraints to a table.mp4

06:29

09 - Conclusion

01 - Next steps.mp4

00:44

Description

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.

In order to work with the data stored in each row in a table, the table must contain a primary key column, or set of columns. Foreign keys provide the glue that the entire system is built on. 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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Structures

Database Programming

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.