Introduction
Welcome
What you should know before watching this course
Using the exercise files

1. Relational Database Basics
What is a database management system (DBMS)?
Understanding the relational structure
Getting to know your relational database management system (RDBMS) options
Moving through the database-development life cycle

2. Preventing Data Anomalies
Introducing relational database advantages
Removing duplicate information
Eliminating inconsistent data
Breaking data down into its components
Preventing data conflicts
Requiring complete information
Maintaining a consistent structure

3. Gathering Requirements
Understanding the goal
Reviewing the current system
Discovering actors and tasks
Interviewing the client
Working with historical values
Identifying exceptions and irregularities

4. Developing the Conceptual Data Model
Understanding entities and tables
Developing relationships
Developing subtypes and supertypes
Utilizing lookup tables
Drafting the initial data model

5. Normalizing Your Data
Identifying key fields
First normal form
Second normal form
Third normal form
Denormalization

6. Logical Design Considerations
Following a naming convention
Data types and precision
Creating junction tables
Applying integrity constraints
Enforcing referential integrity
Building indexes

7. Developing the Physical Database
Moving from planning to construction
Creating the tables in Access
Establishing table relationships in Access
Writing queries in Access
Creating the tables in SQL Server
Establishing table relationships in SQL Server
Creating views in SQL Server

Conclusion
Implementing the plan
Next steps