Lynda - Learning Relational Databases 2017
File List
| File | Size |
|---|---|
| Exercise Files/LearningRelationalDatabases2017.pdf | 418.75 KB |
| 00. Introduction/03 - Exercise files.MP4 | 1.06 MB |
| 08. Conclusion/02 - Next steps.MP4 | 1.11 MB |
| 08. Conclusion/01 - Implement the plan.MP4 | 1.15 MB |
| 04. Developing the Conceptual Data Model/05 - Draft the initial data model.MP4 | 1.22 MB |
| 02. Preventing Data Anomalies/01 - Relational database advantages.MP4 | 1.48 MB |
| 03. Gathering Requirements/06 - Identify exceptions and irregularities.MP4 | 1.65 MB |
| 00. Introduction/02 - What you should know.MP4 | 1.71 MB |
| 03. Gathering Requirements/05 - Work with historical values.MP4 | 2.33 MB |
| 00. Introduction/01 - Welcome.MP4 | 2.36 MB |
| 06. Logical Design Considerations/05 - Enforce referential integrity.MP4 | 2.49 MB |
| 04. Developing the Conceptual Data Model/04 - Utilize lookup tables.MP4 | 3.12 MB |
| 06. Logical Design Considerations/04 - Apply integrity constraints.MP4 | 3.13 MB |
| 03. Gathering Requirements/02 - Review the current system.MP4 | 3.32 MB |
| 04. Developing the Conceptual Data Model/03 - Develop subtypes and supertypes.MP4 | 3.48 MB |
| 05. Normalizing Your Data/05 - Denormalization.MP4 | 3.64 MB |
| 03. Gathering Requirements/01 - Understand the goal.MP4 | 3.65 MB |
| 02. Preventing Data Anomalies/05 - Prevent data conflicts.MP4 | 3.74 MB |
| 07. Developing the Physical Database/01 - Move from planning to construction.MP4 | 3.76 MB |
| 04. Developing the Conceptual Data Model/01 - Understand entities and tables.MP4 | 4.09 MB |
| 01. Relational Database Basics/02 - Relational structures.MP4 | 4.5 MB |
| 03. Gathering Requirements/04 - Interview the client.MP4 | 4.55 MB |
| 01. Relational Database Basics/03 - Get to know your RDBMS options.MP4 | 4.71 MB |
| 06. Logical Design Considerations/03 - Create junction tables.MP4 | 4.72 MB |
| 06. Logical Design Considerations/06 - Build indexes.MP4 | 4.73 MB |
| 03. Gathering Requirements/03 - Discover actors and tasks.MP4 | 4.75 MB |
| 05. Normalizing Your Data/04 - Third normal form.MP4 | 4.77 MB |
| 05. Normalizing Your Data/03 - Second normal form.MP4 | 4.85 MB |
| 05. Normalizing Your Data/02 - First normal form.MP4 | 4.88 MB |
| 02. Preventing Data Anomalies/06 - Require complete information.MP4 | 5.11 MB |
| 02. Preventing Data Anomalies/04 - Break data down into its components.MP4 | 5.22 MB |
| 02. Preventing Data Anomalies/02 - Remove duplicate information.MP4 | 5.26 MB |
| 06. Logical Design Considerations/01 - Follow a naming convention.MP4 | 5.49 MB |
| 01. Relational Database Basics/01 - Database management systems (DBMS).MP4 | 5.49 MB |
| 07. Developing the Physical Database/04 - Write queries in Access.MP4 | 5.62 MB |
| 02. Preventing Data Anomalies/03 - Eliminate inconsistent data.MP4 | 5.93 MB |
| 02. Preventing Data Anomalies/07 - Maintain a consistent structure.MP4 | 6.01 MB |
| 06. Logical Design Considerations/02 - Data types and precision.MP4 | 6.3 MB |
| 04. Developing the Conceptual Data Model/02 - Develop relationships.MP4 | 6.33 MB |
| 07. Developing the Physical Database/03 - Establish relationships in Access.MP4 | 6.42 MB |
| 01. Relational Database Basics/04 - The database development lifecycle.MP4 | 6.72 MB |
| 07. Developing the Physical Database/07 - Create views in SQL Server.MP4 | 7.45 MB |
| 07. Developing the Physical Database/06 - Establish relationships in SQL Server.MP4 | 8.59 MB |
| 05. Normalizing Your Data/01 - Identify key fields.MP4 | 8.81 MB |
| 07. Developing the Physical Database/02 - Create the tables in Access.MP4 | 11.86 MB |
| 07. Developing the Physical Database/05 - Create the tables in SQL Server.MP4 | 13.49 MB |
Trackers
No trackers found.