Relational Databases Essential Training

Course details

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.

Learning objectives
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

Concepts

0. Introduction

01 - Organize data with the relational model
02 - What you should know

1. Get to Know Relational Databases

03 - A brief introduction to data storage
04 - E.F. Codd's relational model
05 - What the CRUD
06 - Relations, tuples, tables, and records

2. Entity Relationship Diagrams

07 - Develop a model of the real world
08 - Choose an ER design tool
09 - Design a table
10 - Attribute data types
11 - Use primary keys to identify records
12 - Object naming considerations

3. Data Integrity and Validation

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

4. Relationships

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

5. Normalization

27 - Relational database normal forms
28 - When not to normalize

6. Structured Query Language

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

7. Beyond the Relational Model

34 - Graph databases
35 - Document databases

Conclusion

36 - Next steps