Lynda Relational Database Fundamentals
File List
| File | Size |
|---|---|
| 02. Relational Database Basics/02_04-Moving through the database-development life cycle.mp4 | 17.97 MB |
| 01. Introduction/01_01-Welcome.mp4 | 6.62 MB |
| 01. Introduction/01_02-What you should know before watching this course.mp4 | 15.22 MB |
| 01. Introduction/01_03-Using the exercise files.mp4 | 1.15 MB |
| 02. Relational Database Basics/02_01-What is a database management system (DBMS).mp4 | 6.78 MB |
| 02. Relational Database Basics/02_02-Understanding the relational structure.mp4 | 5.28 MB |
| 02. Relational Database Basics/02_03-Getting to know your relational database management system (RDBMS) options.mp4 | 5.73 MB |
| 03. Preventing Data Anomalies/03_01-Introducing relational database advantages.mp4 | 14.15 MB |
| 03. Preventing Data Anomalies/03_02-Removing duplicate information.mp4 | 5.95 MB |
| 03. Preventing Data Anomalies/03_03-Eliminating inconsistent data.mp4 | 6.32 MB |
| 03. Preventing Data Anomalies/03_04-Breaking data down into its components.mp4 | 5.82 MB |
| 03. Preventing Data Anomalies/03_05-Preventing data conflicts.mp4 | 4.19 MB |
| 03. Preventing Data Anomalies/03_06-Requiring complete information.mp4 | 5.87 MB |
| 03. Preventing Data Anomalies/03_07-Maintaining a consistent structure.mp4 | 6.71 MB |
| 04. Gathering Requirements/04_01-Understanding the goal.mp4 | 5.19 MB |
| 04. Gathering Requirements/04_02-Reviewing the current system.mp4 | 4.25 MB |
| 04. Gathering Requirements/04_03-Discovering actors and tasks.mp4 | 6.04 MB |
| 04. Gathering Requirements/04_04-Interviewing the client.mp4 | 5.85 MB |
| 04. Gathering Requirements/04_05-Working with historical values.mp4 | 2.84 MB |
| 04. Gathering Requirements/04_06-Identifying exceptions and irregularities.mp4 | 2.02 MB |
| 05. Developing the Conceptual Data Model/05_01-Understanding entities and tables.mp4 | 5.29 MB |
| 05. Developing the Conceptual Data Model/05_02-Developing relationships.mp4 | 7.47 MB |
| 05. Developing the Conceptual Data Model/05_03-Developing subtypes and supertypes.mp4 | 4.19 MB |
| 05. Developing the Conceptual Data Model/05_04-Utilizing lookup tables.mp4 | 3.75 MB |
| 05. Developing the Conceptual Data Model/05_05-Drafting the initial data model.mp4 | 12.05 MB |
| 06. Normalizing Your Data/06_01-Identifying key fields.mp4 | 9.43 MB |
| 06. Normalizing Your Data/06_02-First normal form.mp4 | 5.91 MB |
| 06. Normalizing Your Data/06_03-Second normal form.mp4 | 5.74 MB |
| 06. Normalizing Your Data/06_04-Third normal form.mp4 | 5.59 MB |
| 06. Normalizing Your Data/06_05-Denormalization.mp4 | 4.41 MB |
| 07. Logical Design Considerations/07_01-Following a naming convention.mp4 | 7.13 MB |
| 07. Logical Design Considerations/07_02-Data types and precision.mp4 | 7.44 MB |
| 07. Logical Design Considerations/07_03-Creating junction tables.mp4 | 5.34 MB |
| 07. Logical Design Considerations/07_04-Applying integrity constraints.mp4 | 3.89 MB |
| 07. Logical Design Considerations/07_05-Enforcing referential integrity.mp4 | 3.11 MB |
| 07. Logical Design Considerations/07_06-Building indexes.mp4 | 5.47 MB |
| 08. Developing the Physical Database/08_01-Moving from planning to construction.mp4 | 11.64 MB |
| 08. Developing the Physical Database/08_02-Creating the tables in Access.mp4 | 12.72 MB |
| 08. Developing the Physical Database/08_03-Establishing table relationships in Access.mp4 | 7.2 MB |
| 08. Developing the Physical Database/08_04-Writing queries in Access.mp4 | 5.27 MB |
| 08. Developing the Physical Database/08_05-Creating the tables in SQL Server.mp4 | 17.86 MB |
| 08. Developing the Physical Database/08_06-Establishing table relationships in SQL Server.mp4 | 9.9 MB |
| 08. Developing the Physical Database/08_07-Creating views in SQL Server.mp4 | 8.57 MB |
| 09. Conclusion/09_01-Implementing the plan.mp4 | 10.7 MB |
| 09. Conclusion/09_02-Next steps.mp4 | 9.3 MB |
| Ex_Files_rel_db_fund.zip | 247.03 KB |
Trackers
No trackers found.