Relational Databases Essential Training

Relational Databases Essential Training

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 12m | 244 MB

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.

Topics include:

  • The basics of data storage
  • Choosing an entity-relationship design tool
  • Using primary keys to identify records
  • What to consider when naming objects
  • Creating a unique constraint
  • Establishing table indexes
  • Relating tables with foreign keys
  • One-to-many and one-to-one relationships
  • Normalization
  • Writing SELECT queries in SQL
Table of Contents

1 Organize data with the relational model
2 What you should know
3 A brief introduction to data storage
4 E.F. Codd’s relational model
5 What the CRUD
6 Relations, tuples, tables, and records
7 Develop a model of the real world
8 Choose an ER design tool
9 Design a table
10 Attribute data types
11 Use primary keys to identify records
12 Object naming considerations
13 Data constraints
14 Create a unique constraint
15 Required attributes and null values
16 Define a default value
17 Establish table indexes
18 Add check constraints
19 Relate tables with foreign keys
20 Diagram a relationship
21 Relationship optionality and cardinality
22 One-to-many relationships
23 One-to-one relationships
24 Many-to-many relationships
25 Self joins
26 Cascade changes
27 Relational database normal forms
28 When not to normalize
29 Convert the ER diagram to a database
30 Data definition queries
31 Data manipulation queries
32 Write database select queries
33 Create a database view
34 Graph databases
35 Document databases
36 Next steps