Lynda Learning Relational Databases
File List
| File | Size |
|---|---|
| 8. 7. Developing the Physical Database/41. Create the tables in SQL Server.mp4 | 16.65 MB |
| 1. Introduction/01. Welcome.mp4 | 5.67 MB |
| 1. Introduction/02. What you should know.en.srt | 2.99 KB |
| 1. Introduction/02. What you should know.mp4 | 1.88 MB |
| 1. Introduction/03. Exercise files.en.srt | 1.75 KB |
| 1. Introduction/03. Exercise files.mp4 | 1.38 MB |
| 2. 1. Relational Database Basics/04. Database management systems (DBMS).en.srt | 9.2 KB |
| 2. 1. Relational Database Basics/04. Database management systems (DBMS).mp4 | 6.25 MB |
| 2. 1. Relational Database Basics/05. Relational structures.en.srt | 8.26 KB |
| 2. 1. Relational Database Basics/05. Relational structures.mp4 | 5.03 MB |
| 2. 1. Relational Database Basics/06. Get to know your RDBMS options.en.srt | 8.08 KB |
| 2. 1. Relational Database Basics/06. Get to know your RDBMS options.mp4 | 5.36 MB |
| 2. 1. Relational Database Basics/07. The database development lifecycle.en.srt | 12.36 KB |
| 2. 1. Relational Database Basics/07. The database development lifecycle.mp4 | 7.53 MB |
| 3. 2. Preventing Data Anomalies/08. Relational database advantages.en.srt | 2.78 KB |
| 3. 2. Preventing Data Anomalies/08. Relational database advantages.mp4 | 1.61 MB |
| 3. 2. Preventing Data Anomalies/09. Remove duplicate information.en.srt | 9.42 KB |
| 3. 2. Preventing Data Anomalies/09. Remove duplicate information.mp4 | 5.94 MB |
| 3. 2. Preventing Data Anomalies/10. Eliminate inconsistent data.en.srt | 10.62 KB |
| 3. 2. Preventing Data Anomalies/10. Eliminate inconsistent data.mp4 | 6.56 MB |
| 3. 2. Preventing Data Anomalies/11. Break data down into its components.en.srt | 9.1 KB |
| 3. 2. Preventing Data Anomalies/11. Break data down into its components.mp4 | 5.67 MB |
| 3. 2. Preventing Data Anomalies/12. Prevent data conflicts.en.srt | 6.35 KB |
| 3. 2. Preventing Data Anomalies/12. Prevent data conflicts.mp4 | 4.11 MB |
| 3. 2. Preventing Data Anomalies/13. Require complete information.en.srt | 9.27 KB |
| 3. 2. Preventing Data Anomalies/13. Require complete information.mp4 | 5.64 MB |
| 3. 2. Preventing Data Anomalies/14. Maintain a consistent structure.en.srt | 10.38 KB |
| 3. 2. Preventing Data Anomalies/14. Maintain a consistent structure.mp4 | 6.53 MB |
| 4. 3. Gathering Requirements/15. Understand the goal.en.srt | 5.99 KB |
| 4. 3. Gathering Requirements/15. Understand the goal.mp4 | 4.31 MB |
| 4. 3. Gathering Requirements/16. Review the current system.en.srt | 5.76 KB |
| 4. 3. Gathering Requirements/16. Review the current system.mp4 | 3.77 MB |
| 4. 3. Gathering Requirements/17. Discover actors and tasks.en.srt | 8.62 KB |
| 4. 3. Gathering Requirements/17. Discover actors and tasks.mp4 | 5.53 MB |
| 4. 3. Gathering Requirements/18. Interview the client.en.srt | 7.71 KB |
| 4. 3. Gathering Requirements/18. Interview the client.mp4 | 5.18 MB |
| 4. 3. Gathering Requirements/19. Work with historical values.en.srt | 4.09 KB |
| 4. 3. Gathering Requirements/19. Work with historical values.mp4 | 2.63 MB |
| 4. 3. Gathering Requirements/20. Identify exceptions and irregularities.en.srt | 2.8 KB |
| 4. 3. Gathering Requirements/20. Identify exceptions and irregularities.mp4 | 1.94 MB |
| 5. 4. Developing the Conceptual Data Model/21. Understand entities and tables.en.srt | 7.12 KB |
| 5. 4. Developing the Conceptual Data Model/21. Understand entities and tables.mp4 | 4.69 MB |
| 5. 4. Developing the Conceptual Data Model/22. Develop relationships.en.srt | 11.07 KB |
| 5. 4. Developing the Conceptual Data Model/22. Develop relationships.mp4 | 7.03 MB |
| 5. 4. Developing the Conceptual Data Model/23. Develop subtypes and supertypes.en.srt | 5.77 KB |
| 5. 4. Developing the Conceptual Data Model/23. Develop subtypes and supertypes.mp4 | 3.91 MB |
| 5. 4. Developing the Conceptual Data Model/24. Utilize lookup tables.en.srt | 5.55 KB |
| 5. 4. Developing the Conceptual Data Model/24. Utilize lookup tables.mp4 | 3.49 MB |
| 5. 4. Developing the Conceptual Data Model/25. Draft the initial data model.en.srt | 2.45 KB |
| 5. 4. Developing the Conceptual Data Model/25. Draft the initial data model.mp4 | 1.35 MB |
| 6. 5. Normalizing Your Data/26. Identify key fields.en.srt | 15.21 KB |
| 6. 5. Normalizing Your Data/26. Identify key fields.mp4 | 9.63 MB |
| 6. 5. Normalizing Your Data/27. First normal form.en.srt | 8.59 KB |
| 6. 5. Normalizing Your Data/27. First normal form.mp4 | 5.51 MB |
| 6. 5. Normalizing Your Data/28. Second normal form.en.srt | 8.4 KB |
| 6. 5. Normalizing Your Data/28. Second normal form.mp4 | 5.35 MB |
| 6. 5. Normalizing Your Data/29. Third normal form.en.srt | 8.02 KB |
| 6. 5. Normalizing Your Data/29. Third normal form.mp4 | 5.2 MB |
| 6. 5. Normalizing Your Data/30. Denormalization.en.srt | 6.06 KB |
| 6. 5. Normalizing Your Data/30. Denormalization.mp4 | 4.08 MB |
| 7. 6. Logical Design Considerations/31. Follow a naming convention.en.srt | 10.57 KB |
| 7. 6. Logical Design Considerations/31. Follow a naming convention.mp4 | 6.21 MB |
| 7. 6. Logical Design Considerations/32. Data types and precision.en.srt | 10.58 KB |
| 7. 6. Logical Design Considerations/32. Data types and precision.mp4 | 7.1 MB |
| 7. 6. Logical Design Considerations/33. Create junction tables.en.srt | 8.51 KB |
| 7. 6. Logical Design Considerations/33. Create junction tables.mp4 | 5.14 MB |
| 7. 6. Logical Design Considerations/34. Apply integrity constraints.en.srt | 5.48 KB |
| 7. 6. Logical Design Considerations/34. Apply integrity constraints.mp4 | 3.55 MB |
| 7. 6. Logical Design Considerations/35. Enforce referential integrity.en.srt | 4.44 KB |
| 7. 6. Logical Design Considerations/35. Enforce referential integrity.mp4 | 2.85 MB |
| 7. 6. Logical Design Considerations/36. Build indexes.en.srt | 9 KB |
| 7. 6. Logical Design Considerations/36. Build indexes.mp4 | 5.34 MB |
| 8. 7. Developing the Physical Database/37. Move from planning to construction.en.srt | 6.53 KB |
| 8. 7. Developing the Physical Database/37. Move from planning to construction.mp4 | 4.27 MB |
| 8. 7. Developing the Physical Database/38. Create the tables in Access.en.srt | 17.15 KB |
| 8. 7. Developing the Physical Database/38. Create the tables in Access.mp4 | 14.57 MB |
| 8. 7. Developing the Physical Database/39. Establish relationships in Access.en.srt | 10.44 KB |
| 8. 7. Developing the Physical Database/39. Establish relationships in Access.mp4 | 7.66 MB |
| 8. 7. Developing the Physical Database/40. Write queries in Access.en.srt | 9.17 KB |
| 8. 7. Developing the Physical Database/40. Write queries in Access.mp4 | 6.73 MB |
| 8. 7. Developing the Physical Database/41. Create the tables in SQL Server.en.srt | 19.1 KB |
| 1. Introduction/01. Welcome.en.srt | 2.14 KB |
| 8. 7. Developing the Physical Database/42. Establish relationships in SQL Server.en.srt | 12.46 KB |
| 8. 7. Developing the Physical Database/42. Establish relationships in SQL Server.mp4 | 10.85 MB |
| 8. 7. Developing the Physical Database/43. Create views in SQL Server.en.srt | 9.85 KB |
| 8. 7. Developing the Physical Database/43. Create views in SQL Server.mp4 | 9.51 MB |
| 9. Conclusion/44. Implement the plan.en.srt | 2.08 KB |
| 9. Conclusion/44. Implement the plan.mp4 | 1.31 MB |
| 9. Conclusion/45. Next steps.en.srt | 1.68 KB |
| 9. Conclusion/45. Next steps.mp4 | 1.42 MB |
| Exercise Files/LearningRelationalDatabases2017.pdf | 418.75 KB |
Trackers
No trackers found.