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
