Lynda. Relational Database Fundamentals

mp4   Hot:574   Size:323.57 MB   Created:2017-08-26 10:02:11   Update:2021-12-04 07:25:44  

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.