01 - Organizing data in a database.mp4 (6.8 MB)
MP4
02 - What you should know.mp4 (1.5 MB)
MP4
03 - Making the most of the exercise files.mp4 (2.23 MB)
MP4
04 - Set up the database servers.mp4 (14.46 MB)
MP4
01 - Data integrity concepts.mp4 (22.17 MB)
MP4
02 - The role of data types.mp4 (13.3 MB)
MP4
03 - Numeric data types.mp4 (15.81 MB)
MP4
04 - Character data types.mp4 (18.02 MB)
MP4
05 - Date and time data types.mp4 (18.53 MB)
MP4
06 - Additional common types.mp4 (12.75 MB)
MP4
07 - Challenge Choosing data types.mp4 (3.75 MB)
MP4
08 - Solution Choosing data types.mp4 (19.98 MB)
MP4
01 - Protect data integrity with normalization.mp4 (13.18 MB)
MP4
02 - First normal form.mp4 (5.32 MB)
MP4
03 - Second normal form.mp4 (5.91 MB)
MP4
04 - Third normal form.mp4 (4.65 MB)
MP4
05 - Denormalization considerations.mp4 (11.57 MB)
MP4
01 - Purpose of a primary key.mp4 (7.83 MB)
MP4
02 - Establish the table's primary key.mp4 (22.78 MB)
MP4
03 - Natural keys.mp4 (11.69 MB)
MP4
04 - Composite keys.mp4 (17.34 MB)
MP4
05 - Surrogate keys.mp4 (14.13 MB)
MP4
06 - Challenge Add a primary key to a table.mp4 (2.91 MB)
MP4
07 - Solution Add a primary key to a table.mp4 (17.25 MB)
MP4
01 - What are foreign keys.mp4 (9.31 MB)
MP4
02 - Add a foreign key column to a table.mp4 (15.14 MB)
MP4
03 - Create a relationship between tables.mp4 (21.74 MB)
MP4
04 - IDENTITY column sequences.mp4 (4.07 MB)
MP4
01 - One-to-many relationships.mp4 (5.68 MB)
MP4
02 - One-to-one relationships.mp4 (2.53 MB)
MP4
03 - Many-to-many relationships.mp4 (3.76 MB)
MP4
04 - Self-referencing relationships.mp4 (7.24 MB)
MP4
05 - Cascade updates and deletes.mp4 (14.6 MB)
MP4
06 - Challenge Link tables with keys.mp4 (3.5 MB)
MP4
07 - Solution Link tables with keys.mp4 (19.72 MB)
MP4
01 - Table indexes.mp4 (11.25 MB)
MP4
02 - Add indexes to a table.mp4 (12.15 MB)
MP4
03 - View index statistics.mp4 (21.6 MB)
MP4
01 - Validate data with constraints.mp4 (11.5 MB)
MP4
02 - Null constraints.mp4 (17.93 MB)
MP4
03 - Unique constraints.mp4 (11.72 MB)
MP4
04 - Setting default values.mp4 (9.96 MB)
MP4
05 - Check constraints.mp4 (9.69 MB)
MP4
06 - Challenge Add constraints to a table.mp4 (2.68 MB)
MP4
07 - Solution Add constraints to a table.mp4 (20.57 MB)
MP4
01 - Next steps.mp4 (1.58 MB)
MP4