Database Foundations: Data Structures

Focused View

Adam Wilbert

2:55:35

0 View

01 Introduction

001 Organizing data in a database.mp4

00:54

002 What you should know.mp4

00:40

003 Making the most of the exercise files.mp4

01:04

004 Set up the database servers.mp4

06:06

02 Data Types

001 Data integrity concepts.mp4

04:52

002 The role of data types.mp4

03:55

003 Numeric data types.mp4

06:21

004 Character data types.mp4

06:33

005 Date and time data types.mp4

06:24

006 Additional common types.mp4

05:34

007 Challenge Choosing data types.mp4

01:16

008 Solution Choosing data types.mp4

07:21

03 Design a Normalized Database

001 Protect data integrity with normalization.mp4

04:10

002 First normal form.mp4

03:16

003 Second normal form.mp4

03:27

004 Third normal form.mp4

03:03

005 Denormalization considerations.mp4

04:11

04 Identify Rows with Primary Keys

001 Purpose of a primary key.mp4

03:55

002 Establish the tables primary key.mp4

06:59

003 Natural keys.mp4

02:42

004 Composite keys.mp4

05:33

005 Surrogate keys.mp4

04:40

006 Challenge Add a primary key to a table.mp4

00:53

007 Solution Add a primary key to a table.mp4

05:51

05 Link Data with Foreign Keys

001 What are foreign keys .mp4

02:01

002 Add a foreign key column to a table.mp4

04:37

003 Create a relationship between tables.mp4

06:50

004 IDENTITY column sequences.mp4

01:36

06 Formalize Data Relationships

001 One-to-many relationships.mp4

02:13

002 One-to-one relationships.mp4

01:27

003 Many-to-many relationships.mp4

02:14

004 Self-referencing relationships.mp4

01:56

005 Cascade updates and deletes.mp4

04:35

006 Challenge Link tables with keys.mp4

01:08

007 Solution Link tables with keys.mp4

06:23

07 Indexes

001 Table indexes.mp4

03:31

002 Add indexes to a table.mp4

03:37

003 View index statistics.mp4

06:57

08 Constraints

001 Validate data with constraints.mp4

03:09

002 Null constraints.mp4

05:34

003 Unique constraints.mp4

03:46

004 Setting default values.mp4

03:14

005 Check constraints.mp4

03:08

006 Challenge Add constraints to a table.mp4

00:46

007 Solution Add constraints to a table.mp4

06:29

09 Conclusion

001 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.