Relational Databases Essential Training

Focused View

Adam Wilbert

2:14:07

128 View

01 - Introduction

01 - Organize data with the relational model.mp4

00:42

02 - What you should know.mp4

00:31

02 - 1. Get to Know Relational Databases

01 - A brief introduction to data storage.mp4

04:15

02 - E.F. Codds relational model.mp4

04:03

03 - What the CRUD.mp4

03:48

04 - Relations, tuples, tables, and records.mp4

03:21

03 - 2. Entity Relationship Diagrams

01 - Develop a model of the real world.mp4

06:20

02 - Choose an ER design tool.mp4

05:07

03 - Design a table.mp4

03:39

04 - Attribute data types.mp4

06:00

05 - Use primary keys to identify records.mp4

06:00

06 - Object naming considerations.mp4

03:05

04 - 3. Data Integrity and Validation

01 - Data constraints.mp4

01:44

02 - Create a unique constraint.mp4

05:46

03 - Required attributes and null values.mp4

03:57

04 - Define a default value.mp4

03:58

05 - Establish table indexes.mp4

04:49

06 - Add check constraints.mp4

05:24

05 - 4. Relationships

01 - Relate tables with foreign keys.mp4

04:57

02 - Diagram a relationship.mp4

02:42

03 - Relationship optionality and cardinality.mp4

05:15

04 - One-to-many relationships.mp4

02:10

05 - One-to-one relationships.mp4

01:10

06 - Many-to-many relationships.mp4

02:21

07 - Self joins.mp4

02:17

08 - Cascade changes.mp4

02:17

06 - 5. Normalization

01 - Relational database normal forms.mp4

05:15

02 - When not to normalize.mp4

02:29

07 - 6. Structured Query Language

01 - Convert the ER diagram to a database.mp4

07:00

02 - Data definition queries.mp4

06:22

03 - Data manipulation queries.mp4

04:52

04 - Write database select queries.mp4

05:38

05 - Create a database view.mp4

02:44

08 - 7. Beyond the Relational Model

01 - Graph databases.mp4

01:38

02 - Document databases.mp4

01:32

09 - Conclusion

01 - Next steps.mp4

00:59

Description

In today’s big-data world, understanding how to model phenomena with a relational database is an invaluable skill. A variety of different users—from government agency employees to gamers—rely on relational databases for everyday operations. In this course, join Adam Wilbert as he covers the fundamentals of the relational model for creating databases of real-world situations. Adam goes over concepts that are applicable to a wide variety of platforms, including SQL Server, Oracle, Access, MySQL, and PostgreSQL. Learn the basics of data storage, review the structure of a data table, and learn how to plan your relational database using an entity-relationship design tool. Plus, explore data integrity and validation, table relationships, writing queries, and more.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

MySQL

Database Programming

Microsoft SQL

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.