Download Lynda - Database Foundations: Data Structures torrent

Lynda - Database Foundations: Data Structures

Torrent:	Lynda - Database Foundations: Data Structures
Description:	Description This course focuses on seven core concepts: data types, designing a normalized database, identifying rows with primary keys, linking data with foreign keys, formalizing data relationships, indexes, and constraints. Database expert Adam Wilbert describes techniques that database developers use to protect their data. He explains why data types are important in creating a consistent data storage environment, then walks you through several common data types. Adam shows you the three normal forms of good database design. In order to work with the data stored in each row in a table, the table must contain a primary key column, or set of columns. Foreign keys provide the glue that the entire system is built on. Adam steps you through how to incorporate primary keys and foreign keys into the design of your database tables. He walks through data relationships, indexes, and constraints, then concludes with other courses you may find useful. Last Updated 12/17/2020
Downloads:	189
Category:	Other /Tutorials
Size:	523.7 MB
Show Files »	Database Foundations - Data Structures [TutsNode.com] - Database Foundations - Data Structures 19_Establish the table's primary key.mp4 (22.8 MB) 01_Organizing data in a database.en.srt (1.7 KB) 01_Organizing data in a database.mp4 (6.8 MB) 02_What you should know.en.srt (1.4 KB) 02_What you should know.mp4 (1.5 MB) 03_Making the most of the exercise files.en.srt (2.0 KB) 03_Making the most of the exercise files.mp4 (2.2 MB) 04_Set up the database servers.en.srt (10.8 KB) 04_Set up the database servers.mp4 (16.0 MB) 05_Data integrity concepts.en.srt (8.3 KB) 05_Data integrity concepts.mp4 (22.2 MB) 06_The role of data types.en.srt (7.1 KB) 06_The role of data types.mp4 (13.3 MB) 07_Numeric data types.en.srt (10.8 KB) 07_Numeric data types.mp4 (15.8 MB) 08_Character data types.en.srt (11.4 KB) 08_Character data types.mp4 (18.0 MB) 09_Date and time data types.en.srt (11.3 KB) 09_Date and time data types.mp4 (18.5 MB) 10_Additional common types.en.srt (9.4 KB) 10_Additional common types.mp4 (12.8 MB) 11_Challenge - Choosing data types.en.srt (2.1 KB) 11_Challenge - Choosing data types.mp4 (3.8 MB) 12_Solution - Choosing data types.en.srt (14.0 KB) 12_Solution - Choosing data types.mp4 (20.0 MB) 13_Protect data integrity with normalization.en.srt (7.4 KB) 13_Protect data integrity with normalization.mp4 (13.2 MB) 14_First normal form.en.srt (5.7 KB) 14_First normal form.mp4 (5.3 MB) 15_Second normal form.en.srt (5.7 KB) 15_Second normal form.mp4 (5.9 MB) 16_Third normal form.en.srt (5.1 KB) 16_Third normal form.mp4 (4.7 MB) 17_Denormalization considerations.en.srt (7.2 KB) 17_Denormalization considerations.mp4 (11.6 MB) 18_Purpose of a primary key.en.srt (6.7 KB) 18_Purpose of a primary key.mp4 (7.8 MB) 19_Establish the table's primary key.en.srt (13.0 KB) 20_Natural keys.en.srt (4.7 KB) 20_Natural keys.mp4 (11.7 MB) 21_Composite keys.en.srt (8.7 KB) 21_Composite keys.mp4 (17.3 MB) 22_Surrogate keys.en.srt (8.0 KB) 22_Surrogate keys.mp4 (14.1 MB) 23_Challenge - Add a primary key to a table.en.srt (1.4 KB) 23_Challenge - Add a primary key to a table.mp4 (2.9 MB) 24_Solution - Add a primary key to a table.en.srt (10.6 KB) 24_Solution - Add a primary key to a table.mp4 (17.3 MB) 25_What are foreign keys.en.srt (3.6 KB) 25_What are foreign keys.mp4 (9.3 MB) 26_Add a foreign key column to a table.en.srt (8.5 KB) 26_Add a foreign key column to a table.mp4 (15.1 MB) 27_Create a relationship between tables.en.srt (12.0 KB) 27_Create a relationship between tables.mp4 (21.7 MB) 28_IDENTITY column sequences.en.srt (2.8 KB) 28_IDENTITY column sequences.mp4 (4.1 MB) 29_One-to-many relationships.en.srt (3.4 KB) 29_One-to-many relationships.mp4 (5.7 MB) 30_One-to-one relationships.en.srt (2.5 KB) 30_One-to-one relationships.mp4 (2.5 MB) 31_Many-to-many relationships.en.srt (4.0 KB) 31_Many-to-many relationships.mp4 (3.8 MB) 32_Self-referencing relationships.en.srt (3.2 KB) 32_Self-referencing relationships.mp4 (7.2 MB) 33_Cascade updates and deletes.en.srt (7.8 KB) 33_Cascade updates and deletes.mp4 (14.6 MB) 34_Challenge - Link tables with keys.en.srt (1.8 KB) 34_Challenge - Link tables with keys.mp4 (3.5 MB) 35_Solution - Link tables with keys.en.srt (11.1 KB) 35_Solution - Link tables with keys.mp4 (19.7 MB) 36_Table indexes.en.srt (6.0 KB) 36_Table indexes.mp4 (11.2 MB) 37_Add indexes to a table.en.srt (6.0 KB) 37_Add indexes to a table.mp4 (12.1 MB) 38_View index statistics.en.srt (11.7 KB) 38_View index statistics.mp4 (21.6 MB) 39_Validate data with constraints.en.srt (5.3 KB) 39_Validate data with constraints.mp4 (11.5 MB) 40_Null constraints.en.srt (9.9 KB) 40_Null constraints.mp4 (17.9 MB) 41_Unique constraints.en.srt (6.7 KB) 41_Unique constraints.mp4 (11.7 MB) 42_Setting default values.en.srt (5.8 KB) 42_Setting default values.mp4 (10.0 MB) 43_Check constraints.en.srt (5.6 KB) 43_Check constraints.mp4 (9.7 MB) 44_Challenge - Add constraints to a table.en.srt (1.2 KB) 44_Challenge - Add constraints to a table.mp4 (2.7 MB) 45_Solution - Add constraints to a table.en.srt (11.1 KB) 45_Solution - Add constraints to a table.mp4 (20.6 MB) 46_Next steps.en.srt (1.2 KB) 46_Next steps.mp4 (1.6 MB) Ex_Files_DB_Found_Data_Structures.zip (15.0 KB) TutsNode.com.txt (0.1 KB) [TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB) files
Added:	2020-12-22 11:01:02
Language:	English
Peers:	Seeders : 30 , Leechers : 11
Release name:	Lynda - Database Foundations: Data Structures
Trackers:	udp://inferno.demonoid.pw:3391/announce udp://tracker.openbittorrent.com:80/announce udp://tracker.opentrackr.org:1337/announce udp://torrent.gresille.org:80/announce udp://glotorrents.pw:6969/announce udp://tracker.leechers-paradise.org:6969/announce udp://tracker.pirateparty.gr:6969/announce udp://tracker.coppersurfer.tk:6969/announce udp://ipv4.tracker.harry.lu:80/announce udp://9.rarbg.to:2710/announce udp://shadowshq.yi.org:6969/announce udp://tracker.zer0day.to:1337/announce