Lynda - Relational Database Fundamentals Tutorial-kEISO

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.

Topics include:
What is a database management system (DBMS)
Moving through the database development cycle
Preventing duplicate, inconsistent, and conflicting data entries
Gathering requirements
Developing relationships
Identifying key fields
Following a naming convention
Developing the actual database



Introduction 3m 15s
Welcome 1m 10s
What you should know before watching this course 1m 26s
Using the exercise files 39s

1. Relational Database Basics 18m 12s
What is a database management system (DBMS)? 4m 36s
Understanding the relational structure 3m 57s
Getting to know your relational database management system (RDBMS) options 3m 49s
Moving through the database-development life cycle 5m 50s

2. Preventing Data Anomalies 26m 47s
Introducing relational database advantages 1m 19s
Removing duplicate information 4m 7s
Eliminating inconsistent data 4m 56s
Breaking data down into its components 4m 16s
Preventing data conflicts 3m 9s
Requiring complete information 4m 13s
Maintaining a consistent structure 4m 47s

3. Gathering Requirements 17m 3s
Understanding the goal 2m 56s
Reviewing the current system 2m 50s
Discovering actors and tasks 4m 4s
Interviewing the client 3m 52s
Working with historical values 1m 58s
Identifying exceptions and irregularities 1m 23s

4. Developing the Conceptual Data Model 15m 19s
Understanding entities and tables 3m 24s
Developing relationships 5m 31s
Developing subtypes and supertypes 2m 47s
Utilizing lookup tables 2m 38s
Drafting the initial data model 59s

5. Normalizing Your Data 22m 1s
Identifying key fields 6m 54s
First normal form 4m 5s
Second normal form 4m 8s
Third normal form 3m 58s
Denormalization 2m 56s

6. Logical Design Considerations 22m 27s
Following a naming convention 4m 45s
Data types and precision 5m 9s
Creating junction tables 3m 54s
Applying integrity constraints 2m 34s
Enforcing referential integrity 2m 4s
Building indexes 4m 1s

7. Developing the Physical Database 33m 14s
Moving from planning to construction 57s
Creating the tables in Access 7m 6s
Establishing table relationships in Access 4m 28s
Writing queries in Access 3m 10s
Creating the tables in SQL Server 9m 17s
Establishing table relationships in SQL Server 4m 42s
Creating views in SQL Server 3m 34s

Conclusion 1m 45s
Implementing the plan 56s
Next steps 49s


Screenshots: