2014
Lynda
Adam Wilbert
2:40
English
Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don't know how to speak their language? This course will help you overcome these hurdles. Adam Wilbert teaches the basics of relational database design, regardless of whether you are using Access, FileMaker, Open Office, or SQL Server. Learn common database mistakes to look out for, discover how to diagram use cases and requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views.
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
Download File Size:302.91 MB