LinkedIn Learning – Relational Databases Essential Training

LinkedIn Learning – Relational Databases Essential Training
English | Tutorial | Size: 248.80 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.

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

ALFAFILE
alfafile.net/file/AZKK5/LinkedIn%20Learning%20-%20Relational%20Databases%20Essential%20Training.rar