Lynda Foundations of Programming Databases 2015 | 6786D77138524224A2DFC901E70AB5E37D294348

Lynda Foundations of Programming Databases 2015

Name	Lynda - Foundations of Programming - Databases (2015)	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	565.8 MB
Total Files	40
Hash	6786D77138524224A2DFC901E70AB5E37D294348

/01. Introduction/
01_01-Welcome.mp4	22.3 MB
01_02-What you need to know.mp4	10.3 MB
/02. Understanding Databases/
02_01-What are databases.mp4	47.0 MB
02_02-Exploring databases and database management systems.mp4	22.0 MB
/03. Database Fundamentals/
03_01-The features of a relational database.mp4	8.5 MB
03_02-Exploring unique values and primary keys.mp4	6.7 MB
03_03-Defining table relationships.mp4	22.2 MB
03_04-Describing manytomany relationships.mp4	20.3 MB
03_05-Transactions and the ACID test.mp4	15.6 MB
03_06-Introduction to Structured Query Language SQL.mp4	19.9 MB
/04. Database Modeling Tables/
04_01-Introduction to database modeling.mp4	21.1 MB
04_02-Planning your database.mp4	22.2 MB
04_03-Identifying columns and selecting data types.mp4	36.2 MB
04_04-Choosing primary keys.mp4	6.5 MB
04_05-Using composite keys.mp4	8.1 MB
/05. Database Modeling Relationships/
05_01-Creating relationships.mp4	4.2 MB
05_02-Defining onetomany relationships.mp4	9.2 MB
05_03-Exploring onetoone relationships.mp4	5.4 MB
05_04-Exploring manytomany relationships.mp4	8.3 MB
05_05-Understanding relationship rules and referential integrity.mp4	8.0 MB
/06. Database Modeling Optimization/
06_01-Understanding normalization.mp4	12.8 MB
06_02-First normal form.mp4	20.5 MB
06_03-Second normal form.mp4	16.3 MB
06_04-Third normal form.mp4	13.1 MB
06_05-Database denormalization.mp4	16.1 MB
/07. Database Modeling Querying/
07_01-Creating SQL queries.mp4	8.9 MB
07_02-Structuring the WHERE clause.mp4	10.4 MB
07_03-Sorting query results.mp4	4.7 MB
07_04-Using aggregate functions.mp4	7.8 MB
07_05-Joining tables.mp4	13.8 MB
07_06-Inserting, updating, and deleting.mp4	10.8 MB
07_07-The data definition language.mp4	7.7 MB
/08. Database Modeling Indexing and Optimization/
08_01-Understanding indexes.mp4	15.8 MB
08_02-Understanding write conflicts.mp4	15.9 MB
08_03-Understanding stored procedures and injection attacks.mp4	12.3 MB
/09. Database Options/
09_01-Desktop databases.mp4	10.0 MB
09_02-Relational database management systems.mp4	13.5 MB
09_03-Objectbased and XMLbased databases.mp4	6.7 MB
09_04-NoSQL databases.mp4	16.2 MB
/10. Conclusion/
10_01-Final thoughts.mp4	8.6 MB
Total files 40