Learning Relational Databases
Offered By: LinkedIn Learning
Course Description
Overview
Learn how databases work and how you can start designing one of your own.
Syllabus
Introduction
- Welcome
- What you should know
- Exercise files
- Database management systems (DBMS)
- Relational structures
- Get to know your RDBMS options
- The database development lifecycle
- Relational database advantages
- Remove duplicate information
- Eliminate inconsistent data
- Break data down into its components
- Prevent data conflicts
- Require complete information
- Maintain a consistent structure
- Understand the goal
- Review the current system
- Discover actors and tasks
- Interview the client
- Work with historical values
- Identify exceptions and irregularities
- Understand entities and tables
- Develop relationships
- Develop subtypes and supertypes
- Utilize lookup tables
- Draft the initial data model
- Identify key fields
- First normal form
- Second normal form
- Third normal form
- Denormalization
- Follow a naming convention
- Data types and precision
- Create junction tables
- Apply integrity constraints
- Enforce referential integrity
- Build indexes
- Move from planning to construction
- Create the tables in Access
- Establish relationships in Access
- Write queries in Access
- Create the tables in SQL Server
- Establish relationships in SQL Server
- Create views in SQL Server
- Implement the plan
- Next steps
Taught by
Adam Wilbert
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity MongoDB for Developers
MongoDB University MongoDB for DBAs
MongoDB University MongoDB for Java Developers
MongoDB University