TorBT - Torrents and Magnet Links Search Engine

Lynda. Relational Database Fundamentals

File Name
Size
02. Relational Database Basics/02_04-Moving through the database-development life cycle.mp4
18 MB
01. Introduction/01_01-Welcome.mp4
6.6 MB
01. Introduction/01_02-What you should know before watching this course.mp4
15 MB
01. Introduction/01_03-Using the exercise files.mp4
1.2 MB
02. Relational Database Basics/02_01-What is a database management system (DBMS).mp4
6.8 MB
02. Relational Database Basics/02_02-Understanding the relational structure.mp4
5.3 MB
02. Relational Database Basics/02_03-Getting to know your relational database management system (RDBMS) options.mp4
5.7 MB
03. Preventing Data Anomalies/03_01-Introducing relational database advantages.mp4
14 MB
03. Preventing Data Anomalies/03_02-Removing duplicate information.mp4
5.9 MB
03. Preventing Data Anomalies/03_03-Eliminating inconsistent data.mp4
6.3 MB
03. Preventing Data Anomalies/03_04-Breaking data down into its components.mp4
5.8 MB
03. Preventing Data Anomalies/03_05-Preventing data conflicts.mp4
4.2 MB
03. Preventing Data Anomalies/03_06-Requiring complete information.mp4
5.9 MB
03. Preventing Data Anomalies/03_07-Maintaining a consistent structure.mp4
6.7 MB
04. Gathering Requirements/04_01-Understanding the goal.mp4
5.2 MB
04. Gathering Requirements/04_02-Reviewing the current system.mp4
4.3 MB
04. Gathering Requirements/04_03-Discovering actors and tasks.mp4
6.0 MB
04. Gathering Requirements/04_04-Interviewing the client.mp4
5.8 MB
04. Gathering Requirements/04_05-Working with historical values.mp4
2.8 MB
04. Gathering Requirements/04_06-Identifying exceptions and irregularities.mp4
2.0 MB
05. Developing the Conceptual Data Model/05_01-Understanding entities and tables.mp4
5.3 MB
05. Developing the Conceptual Data Model/05_02-Developing relationships.mp4
7.5 MB
05. Developing the Conceptual Data Model/05_03-Developing subtypes and supertypes.mp4
4.2 MB
05. Developing the Conceptual Data Model/05_04-Utilizing lookup tables.mp4
3.7 MB
05. Developing the Conceptual Data Model/05_05-Drafting the initial data model.mp4
12 MB
06. Normalizing Your Data/06_01-Identifying key fields.mp4
9.4 MB
06. Normalizing Your Data/06_02-First normal form.mp4
5.9 MB
06. Normalizing Your Data/06_03-Second normal form.mp4
5.7 MB
06. Normalizing Your Data/06_04-Third normal form.mp4
5.6 MB
06. Normalizing Your Data/06_05-Denormalization.mp4
4.4 MB
07. Logical Design Considerations/07_01-Following a naming convention.mp4
7.1 MB
07. Logical Design Considerations/07_02-Data types and precision.mp4
7.4 MB
07. Logical Design Considerations/07_03-Creating junction tables.mp4
5.3 MB
07. Logical Design Considerations/07_04-Applying integrity constraints.mp4
3.9 MB
07. Logical Design Considerations/07_05-Enforcing referential integrity.mp4
3.1 MB
07. Logical Design Considerations/07_06-Building indexes.mp4
5.5 MB
08. Developing the Physical Database/08_01-Moving from planning to construction.mp4
12 MB
08. Developing the Physical Database/08_02-Creating the tables in Access.mp4
13 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.3 MB
08. Developing the Physical Database/08_05-Creating the tables in SQL Server.mp4
18 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.6 MB
09. Conclusion/09_01-Implementing the plan.mp4
11 MB
09. Conclusion/09_02-Next steps.mp4
9.3 MB
Ex_Files_rel_db_fund.zip
247 kB