Databases Course
4.0
(1)
7 learners
What you'll learn
This course includes
- 11.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 69 lessons • 11.5 hours of video
Databases Course
69 lessons
• 11.5 hours
Databases Course
69 lessons
• 11.5 hours
- Introduction to Databases | Database Tutorial 1 27:38
- Relational Model - Example Database | Database Tutorial 2a 02:52
- Relational Model - Database Schemas | Database Tutorial 2b 06:39
- Relational Model - Database States | Database Tutorial 2c 03:45
- Relational Model - NULL Values in SQL | Database Tutorial 2d 07:34
- Relational Model - Integrity Constraints in SQL | Database Tutorial 2e 05:52
- Relational Model - Keys in SQL | Database Tutorial 2f 15:06
- Relational Model - Foreign Keys in SQL | Database Tutorial 2g 08:18
- Database Design Phases | Database Tutorial 3a 02:43
- Entity-Relationship Model - Basics | Database Tutorial 3b 10:14
- Entity-Relationship Model - Cardinality Limits | Database Tutorial 3c 09:45
- Entity-Relationship Model - Relationship Sets with Attributes | Database Tutorial 3d 04:34
- Entity-Relationship Model - Weak Entity Sets | Database Tutorial 3e 11:28
- Entity-Relationship Model - ISA Inheritance | Database Tutorial 3f 06:26
- Entity-Relationship Model - Aggregation | Database Tutorial 3g 02:42
- Entity-Relationship Model - Notation Summary | Database Tutorial 3h 02:56
- Unified Modelling Language (UML) | Database Tutorial 3i 06:25
- From Conceptual to Relational Model - Basic Translation | Database Tutorial 4a 04:03
- From Conceptual to Relational Model - Optimized Translation | Database Tutorial 4b 06:33
- From Conceptual to Relational Model - Cardinalities via Constraints | Database Tutorial 4c 09:31
- From Conceptual to Relational Model - Composite, Multivalued Attributes | Database Tutorial 4d 02:32
- From Conceptual to Relational Model - ISA Inheritance | Database Tutorial 4e 06:44
- From Conceptual to Relational Model - Keys & Recursive Relations | Database Tutorial 4f 05:18
- SQL Tutorial - Example Database | Database Tutorial 5a 02:55
- SQL Tutorial - Basic Syntax | Database Tutorial 5b 09:16
- SQL Tutorial - Querying Multiple Tables | Database Tutorial 5c 22:34
- SQL Tutorial - Self Joins | Database Tutorial 5d 12:37
- SQL Tutorial - Duplicate Elimination using DISTINCT | Database Tutorial 5e 11:44
- SQL Tutorial - Inner and OuterJoins: LEFT JOIN, RIGHT JOIN, FULL JOIN | Database Tutorial 5f 26:28
- SQL Tutorial - Non-Monotonic Queries | Database Tutorial 5g 03:18
- SQL Tutorial - NOT IN | Database Tutorial 5h 08:32
- SQL Tutorial - NOT EXISTS | Database Tutorial 5i 11:55
- SQL Tutorial - Expressing "FOR ALL" via "NOT EXISTS NOT" | Database Tutorial 5j 08:59
- SQL Tutorial - Nested Subqueries | Database Tutorial 5k 15:22
- SQL Tutorial - ALL, SOME, ANY | Database Tutorial 5l 05:02
- SQL Tutorial - Single Value Subqueries | Database Tutorial 5m 04:30
- SQL Tutorial - Subqueries under FROM | Database Tutorial 5n 07:04
- SQL Tutorial - Aggregation Functions COUNT, SUM, AVG, MAX, MIN | Database Tutorial 5o 15:46
- SQL Tutorial - Aggregations with GROUP BY and HAVING | Database Tutorial 5p 16:17
- SQL Tutorial - Aggregation Subqueries | Database Tutorial 5q 12:37
- SQL Tutorial - Case Distinctions with UNION, CASE, COALESCE | Database Tutorial 5r 14:27
- SQL Tutorial - Sorting Output with ORDER BY | Database Tutorial 5s 04:38
- Database Normalization - Introduction | Database Tutorial 6a 06:53
- Database Normalization - Functional Dependencies | Database Tutorial 6b 20:20
- Database Normalization - Implication of Functional Dependencies | Database Tutorial 6c 14:17
- Database Normalization - Canonical Sets of Functional Dependencies | Database Tutorial 6d 20:22
- Database Normalization - Determining Keys | Database Tutorial 6e 20:29
- Database Normalization - Determinants | Database Tutorial 6f 10:37
- Database Normalization - Consequences of Bad Design | Database Tutorial 6g 03:39
- Database Normalization - Boyce-Codd Normal Form (BCNF) | Database Tutorial 6h 12:27
- Database Normalization - Third Normal Form (3NF) | Database Tutorial 6i 07:35
- Database Normalization - Splitting Relations | Database Tutorial 6j 15:05
- Database Normalization - Transformation to Boyce-Codd Normal Form (BCNF) | Database Tutorial 6k 21:46
- Database Normalization - Transformation to Third Normal Form (3NF) | Database Tutorial 6l 14:57
- Database Normalization - Multivalued Dependencies and Fourth Normal Form | Database Tutorial 6m 16:39
- Database Normalization - Normal Forms and Conceptual Design | Database Tutorial 6n 07:56
- Database Normalization - Denormalization | Database Tutorial 6o 04:25
- Database Normalization - Other Constraints (Database Tutorial 6p) 05:14
- Transactions - Concurrency Anomalies | Database Tutorial 7a 15:47
- Transactions - Schedules and Serializability | Database Tutorial 7b 33:42
- Transactions - Two Phase Locking | Database Tutorial 7c 19:48
- Transactions - Two Phase Locking - Deadlock Handling | Database Tutorial 7d 03:51
- Transactions - Two Phase Locking - Cascading Rollbacks | Database Tutorial 7e 09:04
- Transactions - Two Phase Locking - Strict and Preclaiming | Database Tutorial 7f 06:39
- Transactions - Two Phase Locking - Granularity of Locking | Database Tutorial 7g 10:55
- Transactions - Isolation Levels in SQL | Database Tutorial 7h 07:47
- Transactions - Optimistic Concurrency Control | Database Tutorial 7i 05:47
- Transactions - Multiversion Concurrency Control | Database Tutorial 7j 07:45
- Optimizing Database Performance | Database Tutorial 7k 03:21
Take this course with you
Download the app to continue lessons from your phone anytime.
