Lynda Learning Relational Databases

File Name

Size

8. 7. Developing the Physical Database/41. Create the tables in SQL Server.mp4

17 MB

1. Introduction/01. Welcome.mp4

5.7 MB

1. Introduction/02. What you should know.en.srt

3.0 kB

1. Introduction/02. What you should know.mp4

1.9 MB

1. Introduction/03. Exercise files.en.srt

1.8 kB

1. Introduction/03. Exercise files.mp4

1.4 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.2 MB

2. 1. Relational Database Basics/05. Relational structures.en.srt

8.3 kB

2. 1. Relational Database Basics/05. Relational structures.mp4

5.0 MB

2. 1. Relational Database Basics/06. Get to know your RDBMS options.en.srt

8.1 kB

2. 1. Relational Database Basics/06. Get to know your RDBMS options.mp4

5.4 MB

2. 1. Relational Database Basics/07. The database development lifecycle.en.srt

12 kB

2. 1. Relational Database Basics/07. The database development lifecycle.mp4

7.5 MB

3. 2. Preventing Data Anomalies/08. Relational database advantages.en.srt

2.8 kB

3. 2. Preventing Data Anomalies/08. Relational database advantages.mp4

1.6 MB

3. 2. Preventing Data Anomalies/09. Remove duplicate information.en.srt

9.4 kB

3. 2. Preventing Data Anomalies/09. Remove duplicate information.mp4

5.9 MB

3. 2. Preventing Data Anomalies/10. Eliminate inconsistent data.en.srt

11 kB

3. 2. Preventing Data Anomalies/10. Eliminate inconsistent data.mp4

6.6 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.7 MB

3. 2. Preventing Data Anomalies/12. Prevent data conflicts.en.srt

6.4 kB

3. 2. Preventing Data Anomalies/12. Prevent data conflicts.mp4

4.1 MB

3. 2. Preventing Data Anomalies/13. Require complete information.en.srt

9.3 kB

3. 2. Preventing Data Anomalies/13. Require complete information.mp4

5.6 MB

3. 2. Preventing Data Anomalies/14. Maintain a consistent structure.en.srt

10 kB

3. 2. Preventing Data Anomalies/14. Maintain a consistent structure.mp4

6.5 MB

4. 3. Gathering Requirements/15. Understand the goal.en.srt

6.0 kB

4. 3. Gathering Requirements/15. Understand the goal.mp4

4.3 MB

4. 3. Gathering Requirements/16. Review the current system.en.srt

5.8 kB

4. 3. Gathering Requirements/16. Review the current system.mp4

3.8 MB

4. 3. Gathering Requirements/17. Discover actors and tasks.en.srt

8.6 kB

4. 3. Gathering Requirements/17. Discover actors and tasks.mp4

5.5 MB

4. 3. Gathering Requirements/18. Interview the client.en.srt

7.7 kB

4. 3. Gathering Requirements/18. Interview the client.mp4

5.2 MB

4. 3. Gathering Requirements/19. Work with historical values.en.srt

4.1 kB

4. 3. Gathering Requirements/19. Work with historical values.mp4

2.6 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.9 MB

5. 4. Developing the Conceptual Data Model/21. Understand entities and tables.en.srt

7.1 kB

5. 4. Developing the Conceptual Data Model/21. Understand entities and tables.mp4

4.7 MB

5. 4. Developing the Conceptual Data Model/22. Develop relationships.en.srt

11 kB

5. 4. Developing the Conceptual Data Model/22. Develop relationships.mp4

7.0 MB

5. 4. Developing the Conceptual Data Model/23. Develop subtypes and supertypes.en.srt

5.8 kB

5. 4. Developing the Conceptual Data Model/23. Develop subtypes and supertypes.mp4

3.9 MB

5. 4. Developing the Conceptual Data Model/24. Utilize lookup tables.en.srt

5.5 kB

5. 4. Developing the Conceptual Data Model/24. Utilize lookup tables.mp4

3.5 MB

5. 4. Developing the Conceptual Data Model/25. Draft the initial data model.en.srt

2.4 kB

5. 4. Developing the Conceptual Data Model/25. Draft the initial data model.mp4

1.4 MB

6. 5. Normalizing Your Data/26. Identify key fields.en.srt

15 kB

6. 5. Normalizing Your Data/26. Identify key fields.mp4

9.6 MB

6. 5. Normalizing Your Data/27. First normal form.en.srt

8.6 kB

6. 5. Normalizing Your Data/27. First normal form.mp4

5.5 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.3 MB

6. 5. Normalizing Your Data/29. Third normal form.en.srt

8.0 kB

6. 5. Normalizing Your Data/29. Third normal form.mp4

5.2 MB

6. 5. Normalizing Your Data/30. Denormalization.en.srt

6.1 kB

6. 5. Normalizing Your Data/30. Denormalization.mp4

4.1 MB

7. 6. Logical Design Considerations/31. Follow a naming convention.en.srt

11 kB

7. 6. Logical Design Considerations/31. Follow a naming convention.mp4

6.2 MB

7. 6. Logical Design Considerations/32. Data types and precision.en.srt

11 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.5 kB

7. 6. Logical Design Considerations/33. Create junction tables.mp4

5.1 MB

7. 6. Logical Design Considerations/34. Apply integrity constraints.en.srt

5.5 kB

7. 6. Logical Design Considerations/34. Apply integrity constraints.mp4

3.5 MB

7. 6. Logical Design Considerations/35. Enforce referential integrity.en.srt

4.4 kB

7. 6. Logical Design Considerations/35. Enforce referential integrity.mp4

2.8 MB

7. 6. Logical Design Considerations/36. Build indexes.en.srt

9.0 kB

7. 6. Logical Design Considerations/36. Build indexes.mp4

5.3 MB

8. 7. Developing the Physical Database/37. Move from planning to construction.en.srt

6.5 kB

8. 7. Developing the Physical Database/37. Move from planning to construction.mp4

4.3 MB

8. 7. Developing the Physical Database/38. Create the tables in Access.en.srt

17 kB

8. 7. Developing the Physical Database/38. Create the tables in Access.mp4

15 MB

8. 7. Developing the Physical Database/39. Establish relationships in Access.en.srt

10 kB

8. 7. Developing the Physical Database/39. Establish relationships in Access.mp4

7.7 MB

8. 7. Developing the Physical Database/40. Write queries in Access.en.srt

9.2 kB

8. 7. Developing the Physical Database/40. Write queries in Access.mp4

6.7 MB

8. 7. Developing the Physical Database/41. Create the tables in SQL Server.en.srt

19 kB

1. Introduction/01. Welcome.en.srt

2.1 kB

8. 7. Developing the Physical Database/42. Establish relationships in SQL Server.en.srt

12 kB

8. 7. Developing the Physical Database/42. Establish relationships in SQL Server.mp4

11 MB

8. 7. Developing the Physical Database/43. Create views in SQL Server.en.srt

9.8 kB

8. 7. Developing the Physical Database/43. Create views in SQL Server.mp4

9.5 MB

9. Conclusion/44. Implement the plan.en.srt

2.1 kB

9. Conclusion/44. Implement the plan.mp4

1.3 MB

9. Conclusion/45. Next steps.en.srt

1.7 kB

9. Conclusion/45. Next steps.mp4

1.4 MB

Exercise Files/LearningRelationalDatabases2017.pdf

419 kB