Skip to content

Lynda Learning Relational Databases

Unverified source. This magnet is from an unverified source. The content may be unsafe or mislabeled. Proceed with caution.
Title: Lynda Learning Relational DatabasesGroup: NOGRPSource: Lynda
Info Hash
0D708E91FD16437BF6278F1CF6144C4E358B067B
Source
Unverified
Total Size
246.67 MB
Total Files
91
Seeders
1
Leechers
0
Health
1.00
Score
2
Type
Bookware

File List

FileSize
8. 7. Developing the Physical Database/41. Create the tables in SQL Server.mp416.65 MB
1. Introduction/01. Welcome.mp45.67 MB
1. Introduction/02. What you should know.en.srt2.99 KB
1. Introduction/02. What you should know.mp41.88 MB
1. Introduction/03. Exercise files.en.srt1.75 KB
1. Introduction/03. Exercise files.mp41.38 MB
2. 1. Relational Database Basics/04. Database management systems (DBMS).en.srt9.2 KB
2. 1. Relational Database Basics/04. Database management systems (DBMS).mp46.25 MB
2. 1. Relational Database Basics/05. Relational structures.en.srt8.26 KB
2. 1. Relational Database Basics/05. Relational structures.mp45.03 MB
2. 1. Relational Database Basics/06. Get to know your RDBMS options.en.srt8.08 KB
2. 1. Relational Database Basics/06. Get to know your RDBMS options.mp45.36 MB
2. 1. Relational Database Basics/07. The database development lifecycle.en.srt12.36 KB
2. 1. Relational Database Basics/07. The database development lifecycle.mp47.53 MB
3. 2. Preventing Data Anomalies/08. Relational database advantages.en.srt2.78 KB
3. 2. Preventing Data Anomalies/08. Relational database advantages.mp41.61 MB
3. 2. Preventing Data Anomalies/09. Remove duplicate information.en.srt9.42 KB
3. 2. Preventing Data Anomalies/09. Remove duplicate information.mp45.94 MB
3. 2. Preventing Data Anomalies/10. Eliminate inconsistent data.en.srt10.62 KB
3. 2. Preventing Data Anomalies/10. Eliminate inconsistent data.mp46.56 MB
3. 2. Preventing Data Anomalies/11. Break data down into its components.en.srt9.1 KB
3. 2. Preventing Data Anomalies/11. Break data down into its components.mp45.67 MB
3. 2. Preventing Data Anomalies/12. Prevent data conflicts.en.srt6.35 KB
3. 2. Preventing Data Anomalies/12. Prevent data conflicts.mp44.11 MB
3. 2. Preventing Data Anomalies/13. Require complete information.en.srt9.27 KB
3. 2. Preventing Data Anomalies/13. Require complete information.mp45.64 MB
3. 2. Preventing Data Anomalies/14. Maintain a consistent structure.en.srt10.38 KB
3. 2. Preventing Data Anomalies/14. Maintain a consistent structure.mp46.53 MB
4. 3. Gathering Requirements/15. Understand the goal.en.srt5.99 KB
4. 3. Gathering Requirements/15. Understand the goal.mp44.31 MB
4. 3. Gathering Requirements/16. Review the current system.en.srt5.76 KB
4. 3. Gathering Requirements/16. Review the current system.mp43.77 MB
4. 3. Gathering Requirements/17. Discover actors and tasks.en.srt8.62 KB
4. 3. Gathering Requirements/17. Discover actors and tasks.mp45.53 MB
4. 3. Gathering Requirements/18. Interview the client.en.srt7.71 KB
4. 3. Gathering Requirements/18. Interview the client.mp45.18 MB
4. 3. Gathering Requirements/19. Work with historical values.en.srt4.09 KB
4. 3. Gathering Requirements/19. Work with historical values.mp42.63 MB
4. 3. Gathering Requirements/20. Identify exceptions and irregularities.en.srt2.8 KB
4. 3. Gathering Requirements/20. Identify exceptions and irregularities.mp41.94 MB
5. 4. Developing the Conceptual Data Model/21. Understand entities and tables.en.srt7.12 KB
5. 4. Developing the Conceptual Data Model/21. Understand entities and tables.mp44.69 MB
5. 4. Developing the Conceptual Data Model/22. Develop relationships.en.srt11.07 KB
5. 4. Developing the Conceptual Data Model/22. Develop relationships.mp47.03 MB
5. 4. Developing the Conceptual Data Model/23. Develop subtypes and supertypes.en.srt5.77 KB
5. 4. Developing the Conceptual Data Model/23. Develop subtypes and supertypes.mp43.91 MB
5. 4. Developing the Conceptual Data Model/24. Utilize lookup tables.en.srt5.55 KB
5. 4. Developing the Conceptual Data Model/24. Utilize lookup tables.mp43.49 MB
5. 4. Developing the Conceptual Data Model/25. Draft the initial data model.en.srt2.45 KB
5. 4. Developing the Conceptual Data Model/25. Draft the initial data model.mp41.35 MB
6. 5. Normalizing Your Data/26. Identify key fields.en.srt15.21 KB
6. 5. Normalizing Your Data/26. Identify key fields.mp49.63 MB
6. 5. Normalizing Your Data/27. First normal form.en.srt8.59 KB
6. 5. Normalizing Your Data/27. First normal form.mp45.51 MB
6. 5. Normalizing Your Data/28. Second normal form.en.srt8.4 KB
6. 5. Normalizing Your Data/28. Second normal form.mp45.35 MB
6. 5. Normalizing Your Data/29. Third normal form.en.srt8.02 KB
6. 5. Normalizing Your Data/29. Third normal form.mp45.2 MB
6. 5. Normalizing Your Data/30. Denormalization.en.srt6.06 KB
6. 5. Normalizing Your Data/30. Denormalization.mp44.08 MB
7. 6. Logical Design Considerations/31. Follow a naming convention.en.srt10.57 KB
7. 6. Logical Design Considerations/31. Follow a naming convention.mp46.21 MB
7. 6. Logical Design Considerations/32. Data types and precision.en.srt10.58 KB
7. 6. Logical Design Considerations/32. Data types and precision.mp47.1 MB
7. 6. Logical Design Considerations/33. Create junction tables.en.srt8.51 KB
7. 6. Logical Design Considerations/33. Create junction tables.mp45.14 MB
7. 6. Logical Design Considerations/34. Apply integrity constraints.en.srt5.48 KB
7. 6. Logical Design Considerations/34. Apply integrity constraints.mp43.55 MB
7. 6. Logical Design Considerations/35. Enforce referential integrity.en.srt4.44 KB
7. 6. Logical Design Considerations/35. Enforce referential integrity.mp42.85 MB
7. 6. Logical Design Considerations/36. Build indexes.en.srt9 KB
7. 6. Logical Design Considerations/36. Build indexes.mp45.34 MB
8. 7. Developing the Physical Database/37. Move from planning to construction.en.srt6.53 KB
8. 7. Developing the Physical Database/37. Move from planning to construction.mp44.27 MB
8. 7. Developing the Physical Database/38. Create the tables in Access.en.srt17.15 KB
8. 7. Developing the Physical Database/38. Create the tables in Access.mp414.57 MB
8. 7. Developing the Physical Database/39. Establish relationships in Access.en.srt10.44 KB
8. 7. Developing the Physical Database/39. Establish relationships in Access.mp47.66 MB
8. 7. Developing the Physical Database/40. Write queries in Access.en.srt9.17 KB
8. 7. Developing the Physical Database/40. Write queries in Access.mp46.73 MB
8. 7. Developing the Physical Database/41. Create the tables in SQL Server.en.srt19.1 KB
1. Introduction/01. Welcome.en.srt2.14 KB
8. 7. Developing the Physical Database/42. Establish relationships in SQL Server.en.srt12.46 KB
8. 7. Developing the Physical Database/42. Establish relationships in SQL Server.mp410.85 MB
8. 7. Developing the Physical Database/43. Create views in SQL Server.en.srt9.85 KB
8. 7. Developing the Physical Database/43. Create views in SQL Server.mp49.51 MB
9. Conclusion/44. Implement the plan.en.srt2.08 KB
9. Conclusion/44. Implement the plan.mp41.31 MB
9. Conclusion/45. Next steps.en.srt1.68 KB
9. Conclusion/45. Next steps.mp41.42 MB
Exercise Files/LearningRelationalDatabases2017.pdf418.75 KB

Trackers

No trackers found.