Don't like banners? Log in and we will make sure you see no banners. For free.
Database Foundations - Data Structures

Database Foundations - Data Structures

Other
Size
524 MB
Seeders
4
Leechers
0
Files
94
Category
Other
Added
at 5:19pm GMT+1
Infohash
99fbc2290d0999aa5efed2c89094e8a32458c110
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

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

File list
  • Database Foundations - Data Structures
  • 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 15 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
497 MB01