Relational Databases Essential Training
Offered By: LinkedIn Learning
Course Description
Overview
Modeling phenomena with a relational database is an invaluable skill in today’s big-data world. This course covers the fundamentals of the relational model for creating databases.
Syllabus
Introduction
- Organize data with the relational model
- What you should know
- A brief introduction to data storage
- E.F. Codd's relational model
- What the CRUD?
- Relations, tuples, tables, and records
- Develop a model of the real world
- Choose an ER design tool
- Design a table
- Attribute data types
- Use primary keys to identify records
- Object naming considerations
- Data constraints
- Create a unique constraint
- Required attributes and null values
- Define a default value
- Establish table indexes
- Add check constraints
- Relate tables with foreign keys
- Diagram a relationship
- Relationship optionality and cardinality
- One-to-many relationships
- One-to-one relationships
- Many-to-many relationships
- Self joins
- Cascade changes
- Relational database normal forms
- When not to normalize
- Convert the ER diagram to a database
- Data definition queries
- Data manipulation queries
- Write database select queries
- Create a database view
- Graph databases
- Document databases
- Next steps
Taught by
Adam Wilbert
Related Courses
Choosing the Right Database Service on GCPA Cloud Guru Choosing the Right Database Service on AWS
A Cloud Guru Database Administration and SQL Language Basics
A Cloud Guru DP-900 Azure Data Fundamentals
A Cloud Guru ETL and ELT Basics
A Cloud Guru