Lynda Relational Database Fundamentals

1. 02. Relational Database Basics/02_04-Moving through the database-development life cycle.mp417.97MB
2. 01. Introduction/01_01-Welcome.mp46.62MB
3. 01. Introduction/01_02-What you should know before watching this course.mp415.22MB
4. 01. Introduction/01_03-Using the exercise files.mp41.15MB
5. 02. Relational Database Basics/02_01-What is a database management system (DBMS).mp46.78MB
6. 02. Relational Database Basics/02_02-Understanding the relational structure.mp45.28MB
7. 02. Relational Database Basics/02_03-Getting to know your relational database management system (RDBMS) options.mp45.73MB
8. 03. Preventing Data Anomalies/03_01-Introducing relational database advantages.mp414.15MB
9. 03. Preventing Data Anomalies/03_02-Removing duplicate information.mp45.95MB
10. 03. Preventing Data Anomalies/03_03-Eliminating inconsistent data.mp46.32MB
11. 03. Preventing Data Anomalies/03_04-Breaking data down into its components.mp45.82MB
12. 03. Preventing Data Anomalies/03_05-Preventing data conflicts.mp44.19MB
13. 03. Preventing Data Anomalies/03_06-Requiring complete information.mp45.87MB
14. 03. Preventing Data Anomalies/03_07-Maintaining a consistent structure.mp46.71MB
15. 04. Gathering Requirements/04_01-Understanding the goal.mp45.19MB
16. 04. Gathering Requirements/04_02-Reviewing the current system.mp44.25MB
17. 04. Gathering Requirements/04_03-Discovering actors and tasks.mp46.04MB
18. 04. Gathering Requirements/04_04-Interviewing the client.mp45.85MB
19. 04. Gathering Requirements/04_05-Working with historical values.mp42.84MB
20. 04. Gathering Requirements/04_06-Identifying exceptions and irregularities.mp42.02MB
21. 05. Developing the Conceptual Data Model/05_01-Understanding entities and tables.mp45.29MB
22. 05. Developing the Conceptual Data Model/05_02-Developing relationships.mp47.47MB
23. 05. Developing the Conceptual Data Model/05_03-Developing subtypes and supertypes.mp44.19MB
24. 05. Developing the Conceptual Data Model/05_04-Utilizing lookup tables.mp43.75MB
25. 05. Developing the Conceptual Data Model/05_05-Drafting the initial data model.mp412.05MB
26. 06. Normalizing Your Data/06_01-Identifying key fields.mp49.43MB
27. 06. Normalizing Your Data/06_02-First normal form.mp45.91MB
28. 06. Normalizing Your Data/06_03-Second normal form.mp45.74MB
29. 06. Normalizing Your Data/06_04-Third normal form.mp45.59MB
30. 06. Normalizing Your Data/06_05-Denormalization.mp44.41MB
31. 07. Logical Design Considerations/07_01-Following a naming convention.mp47.13MB
32. 07. Logical Design Considerations/07_02-Data types and precision.mp47.44MB
33. 07. Logical Design Considerations/07_03-Creating junction tables.mp45.34MB
34. 07. Logical Design Considerations/07_04-Applying integrity constraints.mp43.89MB
35. 07. Logical Design Considerations/07_05-Enforcing referential integrity.mp43.11MB
36. 07. Logical Design Considerations/07_06-Building indexes.mp45.47MB
37. 08. Developing the Physical Database/08_01-Moving from planning to construction.mp411.64MB
38. 08. Developing the Physical Database/08_02-Creating the tables in Access.mp412.72MB
39. 08. Developing the Physical Database/08_03-Establishing table relationships in Access.mp47.2MB
40. 08. Developing the Physical Database/08_04-Writing queries in Access.mp45.27MB
41. 08. Developing the Physical Database/08_05-Creating the tables in SQL Server.mp417.86MB
42. 08. Developing the Physical Database/08_06-Establishing table relationships in SQL Server.mp49.9MB
43. 08. Developing the Physical Database/08_07-Creating views in SQL Server.mp48.57MB
44. 09. Conclusion/09_01-Implementing the plan.mp410.7MB
45. 09. Conclusion/09_02-Next steps.mp49.3MB