Lynda Learning Relational Databases/8. 7. Developing the Physical Database/41. Create the tables in SQL Server.mp4 |
16.6 MB |
Lynda Learning Relational Databases/1. Introduction/01. Welcome.mp4 |
5.7 MB |
Lynda Learning Relational Databases/1. Introduction/02. What you should know.en.srt |
3 KB |
Lynda Learning Relational Databases/1. Introduction/02. What you should know.mp4 |
1.9 MB |
Lynda Learning Relational Databases/1. Introduction/03. Exercise files.en.srt |
2 KB |
Lynda Learning Relational Databases/1. Introduction/03. Exercise files.mp4 |
1.4 MB |
Lynda Learning Relational Databases/2. 1. Relational Database Basics/04. Database management systems (DBMS).en.srt |
9 KB |
Lynda Learning Relational Databases/2. 1. Relational Database Basics/04. Database management systems (DBMS).mp4 |
6.2 MB |
Lynda Learning Relational Databases/2. 1. Relational Database Basics/05. Relational structures.en.srt |
8 KB |
Lynda Learning Relational Databases/2. 1. Relational Database Basics/05. Relational structures.mp4 |
5 MB |
Lynda Learning Relational Databases/2. 1. Relational Database Basics/06. Get to know your RDBMS options.en.srt |
8 KB |
Lynda Learning Relational Databases/2. 1. Relational Database Basics/06. Get to know your RDBMS options.mp4 |
5.4 MB |
Lynda Learning Relational Databases/2. 1. Relational Database Basics/07. The database development lifecycle.en.srt |
12 KB |
Lynda Learning Relational Databases/2. 1. Relational Database Basics/07. The database development lifecycle.mp4 |
7.5 MB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/08. Relational database advantages.en.srt |
3 KB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/08. Relational database advantages.mp4 |
1.6 MB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/09. Remove duplicate information.en.srt |
9 KB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/09. Remove duplicate information.mp4 |
5.9 MB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/10. Eliminate inconsistent data.en.srt |
11 KB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/10. Eliminate inconsistent data.mp4 |
6.6 MB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/11. Break data down into its components.en.srt |
9 KB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/11. Break data down into its components.mp4 |
5.7 MB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/12. Prevent data conflicts.en.srt |
6 KB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/12. Prevent data conflicts.mp4 |
4.1 MB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/13. Require complete information.en.srt |
9 KB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/13. Require complete information.mp4 |
5.6 MB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/14. Maintain a consistent structure.en.srt |
10 KB |
Lynda Learning Relational Databases/3. 2. Preventing Data Anomalies/14. Maintain a consistent structure.mp4 |
6.5 MB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/15. Understand the goal.en.srt |
6 KB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/15. Understand the goal.mp4 |
4.3 MB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/16. Review the current system.en.srt |
6 KB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/16. Review the current system.mp4 |
3.8 MB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/17. Discover actors and tasks.en.srt |
9 KB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/17. Discover actors and tasks.mp4 |
5.5 MB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/18. Interview the client.en.srt |
8 KB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/18. Interview the client.mp4 |
5.2 MB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/19. Work with historical values.en.srt |
4 KB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/19. Work with historical values.mp4 |
2.6 MB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/20. Identify exceptions and irregularities.en.srt |
3 KB |
Lynda Learning Relational Databases/4. 3. Gathering Requirements/20. Identify exceptions and irregularities.mp4 |
1.9 MB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/21. Understand entities and tables.en.srt |
7 KB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/21. Understand entities and tables.mp4 |
4.7 MB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/22. Develop relationships.en.srt |
11 KB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/22. Develop relationships.mp4 |
7 MB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/23. Develop subtypes and supertypes.en.srt |
6 KB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/23. Develop subtypes and supertypes.mp4 |
3.9 MB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/24. Utilize lookup tables.en.srt |
6 KB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/24. Utilize lookup tables.mp4 |
3.5 MB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/25. Draft the initial data model.en.srt |
2 KB |
Lynda Learning Relational Databases/5. 4. Developing the Conceptual Data Model/25. Draft the initial data model.mp4 |
1.4 MB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/26. Identify key fields.en.srt |
15 KB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/26. Identify key fields.mp4 |
9.6 MB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/27. First normal form.en.srt |
9 KB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/27. First normal form.mp4 |
5.5 MB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/28. Second normal form.en.srt |
8 KB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/28. Second normal form.mp4 |
5.3 MB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/29. Third normal form.en.srt |
8 KB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/29. Third normal form.mp4 |
5.2 MB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/30. Denormalization.en.srt |
6 KB |
Lynda Learning Relational Databases/6. 5. Normalizing Your Data/30. Denormalization.mp4 |
4.1 MB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/31. Follow a naming convention.en.srt |
11 KB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/31. Follow a naming convention.mp4 |
6.2 MB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/32. Data types and precision.en.srt |
11 KB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/32. Data types and precision.mp4 |
7.1 MB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/33. Create junction tables.en.srt |
9 KB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/33. Create junction tables.mp4 |
5.1 MB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/34. Apply integrity constraints.en.srt |
5 KB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/34. Apply integrity constraints.mp4 |
3.5 MB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/35. Enforce referential integrity.en.srt |
4 KB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/35. Enforce referential integrity.mp4 |
2.8 MB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/36. Build indexes.en.srt |
9 KB |
Lynda Learning Relational Databases/7. 6. Logical Design Considerations/36. Build indexes.mp4 |
5.3 MB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/37. Move from planning to construction.en.srt |
7 KB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/37. Move from planning to construction.mp4 |
4.3 MB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/38. Create the tables in Access.en.srt |
17 KB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/38. Create the tables in Access.mp4 |
14.6 MB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/39. Establish relationships in Access.en.srt |
10 KB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/39. Establish relationships in Access.mp4 |
7.7 MB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/40. Write queries in Access.en.srt |
9 KB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/40. Write queries in Access.mp4 |
6.7 MB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/41. Create the tables in SQL Server.en.srt |
19 KB |
Lynda Learning Relational Databases/1. Introduction/01. Welcome.en.srt |
2 KB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/42. Establish relationships in SQL Server.en.srt |
12 KB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/42. Establish relationships in SQL Server.mp4 |
10.8 MB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/43. Create views in SQL Server.en.srt |
10 KB |
Lynda Learning Relational Databases/8. 7. Developing the Physical Database/43. Create views in SQL Server.mp4 |
9.5 MB |
Lynda Learning Relational Databases/9. Conclusion/44. Implement the plan.en.srt |
2 KB |
Lynda Learning Relational Databases/9. Conclusion/44. Implement the plan.mp4 |
1.3 MB |
Lynda Learning Relational Databases/9. Conclusion/45. Next steps.en.srt |
2 KB |
Lynda Learning Relational Databases/9. Conclusion/45. Next steps.mp4 |
1.4 MB |
Lynda Learning Relational Databases/Exercise Files/LearningRelationalDatabases2017.pdf |
419 KB |