Download link
File List
-
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
Download Info
-
Tips
“Lynda. Relational Database Fundamentals” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.