Lynda Relational Database Fundamentals | C8693DC869CA7D75AD3AA23D06383BCD0FF2553B

Lynda Relational Database Fundamentals

Name	Lynda. Relational Database Fundamentals	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	339.3 MB
Total Files	46
Hash	C8693DC869CA7D75AD3AA23D06383BCD0FF2553B

/02. Relational Database Basics/
02_04-Moving through the database-development life cycle.mp4	18.8 MB
02_01-What is a database management system (DBMS).mp4	7.1 MB
02_02-Understanding the relational structure.mp4	5.5 MB
02_03-Getting to know your relational database management system (RDBMS) options.mp4	6.0 MB
/01. Introduction/
01_01-Welcome.mp4	6.9 MB
01_02-What you should know before watching this course.mp4	16.0 MB
01_03-Using the exercise files.mp4	1.2 MB
/03. Preventing Data Anomalies/
03_01-Introducing relational database advantages.mp4	14.8 MB
03_02-Removing duplicate information.mp4	6.2 MB
03_03-Eliminating inconsistent data.mp4	6.6 MB
03_04-Breaking data down into its components.mp4	6.1 MB
03_05-Preventing data conflicts.mp4	4.4 MB
03_06-Requiring complete information.mp4	6.2 MB
03_07-Maintaining a consistent structure.mp4	7.0 MB
/04. Gathering Requirements/
04_01-Understanding the goal.mp4	5.4 MB
04_02-Reviewing the current system.mp4	4.5 MB
04_03-Discovering actors and tasks.mp4	6.3 MB
04_04-Interviewing the client.mp4	6.1 MB
04_05-Working with historical values.mp4	3.0 MB
04_06-Identifying exceptions and irregularities.mp4	2.1 MB
/05. Developing the Conceptual Data Model/
05_01-Understanding entities and tables.mp4	5.6 MB
05_02-Developing relationships.mp4	7.8 MB
05_03-Developing subtypes and supertypes.mp4	4.4 MB
05_04-Utilizing lookup tables.mp4	3.9 MB
05_05-Drafting the initial data model.mp4	12.6 MB
/06. Normalizing Your Data/
06_01-Identifying key fields.mp4	9.9 MB
06_02-First normal form.mp4	6.2 MB
06_03-Second normal form.mp4	6.0 MB
06_04-Third normal form.mp4	5.9 MB
06_05-Denormalization.mp4	4.6 MB
/07. Logical Design Considerations/
07_01-Following a naming convention.mp4	7.5 MB
07_02-Data types and precision.mp4	7.8 MB
07_03-Creating junction tables.mp4	5.6 MB
07_04-Applying integrity constraints.mp4	4.1 MB
07_05-Enforcing referential integrity.mp4	3.3 MB
07_06-Building indexes.mp4	5.7 MB
/08. Developing the Physical Database/
08_01-Moving from planning to construction.mp4	12.2 MB
08_02-Creating the tables in Access.mp4	13.3 MB
08_03-Establishing table relationships in Access.mp4	7.6 MB
08_04-Writing queries in Access.mp4	5.5 MB
08_05-Creating the tables in SQL Server.mp4	18.7 MB
08_06-Establishing table relationships in SQL Server.mp4	10.4 MB
08_07-Creating views in SQL Server.mp4	9.0 MB
/09. Conclusion/
09_01-Implementing the plan.mp4	11.2 MB
09_02-Next steps.mp4	9.8 MB
/
Ex_Files_rel_db_fund.zip	253.0 KB
Total files 46