YoVDO

Relational Databases Essential Training

Offered By: LinkedIn Learning

Tags

Relational Databases Courses SQL Courses Database Design Courses Data Integrity Courses Data Modeling Courses Normalization Courses Foreign Keys Courses

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
1. Get to Know Relational Databases
  • A brief introduction to data storage
  • E.F. Codd's relational model
  • What the CRUD?
  • Relations, tuples, tables, and records
2. Entity Relationship Diagrams
  • 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
3. Data Integrity and Validation
  • Data constraints
  • Create a unique constraint
  • Required attributes and null values
  • Define a default value
  • Establish table indexes
  • Add check constraints
4. Relationships
  • 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
5. Normalization
  • Relational database normal forms
  • When not to normalize
6. Structured Query Language
  • Convert the ER diagram to a database
  • Data definition queries
  • Data manipulation queries
  • Write database select queries
  • Create a database view
7. Beyond the Relational Model
  • Graph databases
  • Document databases
Conclusion
  • Next steps

Taught by

Adam Wilbert

Related Courses

Choosing the Right Database Service on GCP
A 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