Working with the Relational Data Model

Working with the Relational Data Model

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 0h 51m | 302 MB

Learn the basics of working with relational data in relational databases by learning about tables, attributes, relationships, primary keys, and foreign keys, and build a foundation for working with massively large databases.

Table of Contents

00:00:00 Introduction
00:01:03 Relational Model Overview
00:15:38 Storing Entities
00:16:56 Creating a Table (Demo)
00:23:10 Removing a Table
00:24:19 Dropping a Table (Demo)
00:26:05 Defining Entity Attributes
00:28:41 Exploring Data Types (Demo)
00:34:17 Entity IDs
00:36:31 Generating IDs and Primary Keys (Demo)
00:42:26 Entity Relationships
00:44:12 Creating Foreign Keys (Demo)
00:51:51 Conclusion