Relational Databases Essential Training

English | 2h 12m | Video 720p

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

 

Homepage:

https://www.lynda.com/IT-tutorials/Relational-Databases-Essential-Training/2811721-2.html