17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Database Foundations - Data Structures
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
TutsNode.com.txt
63 B
[TutsNode.com] - Database Foundations - Data Structures/01_Organizing data in a database.en.srt
1.7 KB
[TutsNode.com] - Database Foundations - Data Structures/01_Organizing data in a database.mp4
6.8 MB
[TutsNode.com] - Database Foundations - Data Structures/02_What you should know.en.srt
1.4 KB
[TutsNode.com] - Database Foundations - Data Structures/02_What you should know.mp4
1.5 MB
[TutsNode.com] - Database Foundations - Data Structures/03_Making the most of the exercise files.en.srt
2 KB
[TutsNode.com] - Database Foundations - Data Structures/03_Making the most of the exercise files.mp4
2.2 MB
[TutsNode.com] - Database Foundations - Data Structures/04_Set up the database servers.en.srt
10.8 KB
[TutsNode.com] - Database Foundations - Data Structures/04_Set up the database servers.mp4
16 MB
[TutsNode.com] - Database Foundations - Data Structures/05_Data integrity concepts.en.srt
8.3 KB
[TutsNode.com] - Database Foundations - Data Structures/05_Data integrity concepts.mp4
22.2 MB
[TutsNode.com] - Database Foundations - Data Structures/06_The role of data types.en.srt
7.1 KB
[TutsNode.com] - Database Foundations - Data Structures/06_The role of data types.mp4
13.3 MB
[TutsNode.com] - Database Foundations - Data Structures/07_Numeric data types.en.srt
10.8 KB
[TutsNode.com] - Database Foundations - Data Structures/07_Numeric data types.mp4
15.8 MB
[TutsNode.com] - Database Foundations - Data Structures/08_Character data types.en.srt
11.4 KB
[TutsNode.com] - Database Foundations - Data Structures/08_Character data types.mp4
18 MB
[TutsNode.com] - Database Foundations - Data Structures/09_Date and time data types.en.srt
11.3 KB
[TutsNode.com] - Database Foundations - Data Structures/09_Date and time data types.mp4
18.5 MB
[TutsNode.com] - Database Foundations - Data Structures/10_Additional common types.en.srt
9.4 KB
[TutsNode.com] - Database Foundations - Data Structures/10_Additional common types.mp4
12.8 MB
[TutsNode.com] - Database Foundations - Data Structures/11_Challenge - Choosing data types.en.srt
2.1 KB
[TutsNode.com] - Database Foundations - Data Structures/11_Challenge - Choosing data types.mp4
3.8 MB
[TutsNode.com] - Database Foundations - Data Structures/12_Solution - Choosing data types.en.srt
14 KB
[TutsNode.com] - Database Foundations - Data Structures/12_Solution - Choosing data types.mp4
20 MB
[TutsNode.com] - Database Foundations - Data Structures/13_Protect data integrity with normalization.en.srt
7.4 KB
[TutsNode.com] - Database Foundations - Data Structures/13_Protect data integrity with normalization.mp4
13.2 MB
[TutsNode.com] - Database Foundations - Data Structures/14_First normal form.en.srt
5.7 KB
[TutsNode.com] - Database Foundations - Data Structures/14_First normal form.mp4
5.3 MB
[TutsNode.com] - Database Foundations - Data Structures/15_Second normal form.en.srt
5.7 KB
[TutsNode.com] - Database Foundations - Data Structures/15_Second normal form.mp4
5.9 MB
[TutsNode.com] - Database Foundations - Data Structures/16_Third normal form.en.srt
5.1 KB
[TutsNode.com] - Database Foundations - Data Structures/16_Third normal form.mp4
4.7 MB
[TutsNode.com] - Database Foundations - Data Structures/17_Denormalization considerations.en.srt
7.2 KB
[TutsNode.com] - Database Foundations - Data Structures/17_Denormalization considerations.mp4
11.6 MB
[TutsNode.com] - Database Foundations - Data Structures/18_Purpose of a primary key.en.srt
6.7 KB
[TutsNode.com] - Database Foundations - Data Structures/18_Purpose of a primary key.mp4
7.8 MB
[TutsNode.com] - Database Foundations - Data Structures/19_Establish the table's primary key.en.srt
13 KB
[TutsNode.com] - Database Foundations - Data Structures/19_Establish the table's primary key.mp4
22.8 MB
[TutsNode.com] - Database Foundations - Data Structures/20_Natural keys.en.srt
4.7 KB
[TutsNode.com] - Database Foundations - Data Structures/20_Natural keys.mp4
11.7 MB
[TutsNode.com] - Database Foundations - Data Structures/21_Composite keys.en.srt
8.7 KB
[TutsNode.com] - Database Foundations - Data Structures/21_Composite keys.mp4
17.3 MB
[TutsNode.com] - Database Foundations - Data Structures/22_Surrogate keys.en.srt
8 KB
[TutsNode.com] - Database Foundations - Data Structures/22_Surrogate keys.mp4
14.1 MB
[TutsNode.com] - Database Foundations - Data Structures/23_Challenge - Add a primary key to a table.en.srt
1.4 KB
[TutsNode.com] - Database Foundations - Data Structures/23_Challenge - Add a primary key to a table.mp4
2.9 MB
[TutsNode.com] - Database Foundations - Data Structures/24_Solution - Add a primary key to a table.en.srt
10.6 KB
[TutsNode.com] - Database Foundations - Data Structures/24_Solution - Add a primary key to a table.mp4
17.3 MB
[TutsNode.com] - Database Foundations - Data Structures/25_What are foreign keys.en.srt
3.6 KB
[TutsNode.com] - Database Foundations - Data Structures/25_What are foreign keys.mp4
9.3 MB
[TutsNode.com] - Database Foundations - Data Structures/26_Add a foreign key column to a table.en.srt
8.5 KB
[TutsNode.com] - Database Foundations - Data Structures/26_Add a foreign key column to a table.mp4
15.1 MB
[TutsNode.com] - Database Foundations - Data Structures/27_Create a relationship between tables.en.srt
12 KB
[TutsNode.com] - Database Foundations - Data Structures/27_Create a relationship between tables.mp4
21.7 MB
[TutsNode.com] - Database Foundations - Data Structures/28_IDENTITY column sequences.en.srt
2.8 KB
[TutsNode.com] - Database Foundations - Data Structures/28_IDENTITY column sequences.mp4
4.1 MB
[TutsNode.com] - Database Foundations - Data Structures/29_One-to-many relationships.en.srt
3.4 KB
[TutsNode.com] - Database Foundations - Data Structures/29_One-to-many relationships.mp4
5.7 MB
[TutsNode.com] - Database Foundations - Data Structures/30_One-to-one relationships.en.srt
2.5 KB
[TutsNode.com] - Database Foundations - Data Structures/30_One-to-one relationships.mp4
2.5 MB
[TutsNode.com] - Database Foundations - Data Structures/31_Many-to-many relationships.en.srt
4 KB
[TutsNode.com] - Database Foundations - Data Structures/31_Many-to-many relationships.mp4
3.8 MB
[TutsNode.com] - Database Foundations - Data Structures/32_Self-referencing relationships.en.srt
3.2 KB
[TutsNode.com] - Database Foundations - Data Structures/32_Self-referencing relationships.mp4
7.2 MB
[TutsNode.com] - Database Foundations - Data Structures/33_Cascade updates and deletes.en.srt
7.8 KB
[TutsNode.com] - Database Foundations - Data Structures/33_Cascade updates and deletes.mp4
14.6 MB
[TutsNode.com] - Database Foundations - Data Structures/34_Challenge - Link tables with keys.en.srt
1.8 KB
[TutsNode.com] - Database Foundations - Data Structures/34_Challenge - Link tables with keys.mp4
3.5 MB
[TutsNode.com] - Database Foundations - Data Structures/35_Solution - Link tables with keys.en.srt
11.1 KB
[TutsNode.com] - Database Foundations - Data Structures/35_Solution - Link tables with keys.mp4
19.7 MB
[TutsNode.com] - Database Foundations - Data Structures/36_Table indexes.en.srt
6 KB
[TutsNode.com] - Database Foundations - Data Structures/36_Table indexes.mp4
11.2 MB
[TutsNode.com] - Database Foundations - Data Structures/37_Add indexes to a table.en.srt
6 KB
[TutsNode.com] - Database Foundations - Data Structures/37_Add indexes to a table.mp4
12.1 MB
[TutsNode.com] - Database Foundations - Data Structures/38_View index statistics.en.srt
11.7 KB
[TutsNode.com] - Database Foundations - Data Structures/38_View index statistics.mp4
21.6 MB
[TutsNode.com] - Database Foundations - Data Structures/39_Validate data with constraints.en.srt
5.3 KB
[TutsNode.com] - Database Foundations - Data Structures/39_Validate data with constraints.mp4
11.5 MB
[TutsNode.com] - Database Foundations - Data Structures/40_Null constraints.en.srt
9.9 KB
[TutsNode.com] - Database Foundations - Data Structures/40_Null constraints.mp4
17.9 MB
[TutsNode.com] - Database Foundations - Data Structures/41_Unique constraints.en.srt
6.7 KB
[TutsNode.com] - Database Foundations - Data Structures/41_Unique constraints.mp4
11.7 MB
[TutsNode.com] - Database Foundations - Data Structures/42_Setting default values.en.srt
5.8 KB
[TutsNode.com] - Database Foundations - Data Structures/42_Setting default values.mp4
10 MB
[TutsNode.com] - Database Foundations - Data Structures/43_Check constraints.en.srt
5.6 KB
[TutsNode.com] - Database Foundations - Data Structures/43_Check constraints.mp4
9.7 MB
[TutsNode.com] - Database Foundations - Data Structures/44_Challenge - Add constraints to a table.en.srt
1.2 KB
[TutsNode.com] - Database Foundations - Data Structures/44_Challenge - Add constraints to a table.mp4
2.7 MB
[TutsNode.com] - Database Foundations - Data Structures/45_Solution - Add constraints to a table.en.srt
11.1 KB
[TutsNode.com] - Database Foundations - Data Structures/45_Solution - Add constraints to a table.mp4
20.6 MB
[TutsNode.com] - Database Foundations - Data Structures/46_Next steps.en.srt
1.2 KB
[TutsNode.com] - Database Foundations - Data Structures/46_Next steps.mp4
1.6 MB
[TutsNode.com] - Database Foundations - Data Structures/Ex_Files_DB_Found_Data_Structures.zip
