Comprehensive Guide to Databases and SQL Mastery
Unlock the Power of Databases: From Fundamentals to Advanced SQL Techniques! Dive deep into database purpose, design, and optimization with Dr. Daniel Soper's comprehensive course—your gateway to mastering data management and analytics!
4.2 (28)
334 learners
What you'll learn
Understand the purpose and structure of relational databases
Execute basic and advanced SQL queries for data management
Design and model database schemas incorporating keys and relationships
Implement database security, backup, and recovery methods
Execute basic and advanced SQL queries for data management
Design and model database schemas incorporating keys and relationships
Implement database security, backup, and recovery methods
This course includes
- 18.4 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 81 lessons • 18.4 hours of video
Comprehensive Guide to Database Systems and SQL
81 lessons • 18.4 hours
▶
Comprehensive Guide to Database Systems and SQL
81 lessons • 18.4 hours
- Topic 01, Part 01 - The Purpose of a Database06:52
- Topic 01, Part 02 - Problems with Storing Data in a List08:56
- Topic 01, Part 03 - List Modification Issues16:33
- Topic 01, Part 04 - Introduction to Relational Databases19:51
- Topic 01, Part 05 - The Purpose and Value of the Structured Query Language (SQL)07:36
- Topic 01, Part 06 - An Overview of Database Systems11:43
- Topic 01, Part 07 - Users and Databases - Components of a Database System23:10
- Topic 01, Part 08 - The DBMS and Database Applications - Components of a Database System15:19
- Topic 01, Part 09 - Personal vs. Enterprise-Level Database Systems08:08
- Topic 02, Part 01 - Database Entities09:20
- Topic 02, Part 02 - Characteristics of Relations15:10
- Topic 02, Part 03 - Introduction to Database Keys10:28
- Topic 02, Part 04 - Composite Keys09:15
- Topic 02, Part 05 - Candidate Keys07:54
- Topic 02, Part 06 - Primary Keys and Surrogate Keys09:33
- Topic 02, Part 07 - Foreign Keys and Relationships Between Tables28:02
- Topic 02, Part 08 - Null Values12:07
- Topic 02, Part 09 - Functional Dependencies04:24
- Topic 02, Part 10 - Normalization and Normal Forms24:33
- Topic 03, Part 01 - Introduction to SQL09:59
- Topic 03, Part 02 - Introduction to the SQL CREATE TABLE Statement26:34
- Topic 03, Part 03 - Creating Primary Keys and Foreign Keys using SQL35:07
- Topic 03, Part 04 - The SQL ALTER Statement08:37
- Topic 03, Part 05 - Introduction to the Data Manipulation Language (DML)04:08
- Topic 03, Part 06 - Adding Data using the SQL INSERT INTO Statement11:37
- Topic 03, Part 07 - Modifying Data using the SQL UPDATE Statement07:31
- Topic 03, Part 08 - Deleting Data using the SQL DELETE FROM Statement03:26
- Topic 03, Part 09 - Deleting Database Objects and Constraints with the SQL DROP Statement04:38
- Topic 03, Part 10 - Using SQL CHECK Constraints06:04
- Topic 03, Part 11 - Introduction to SQL SELECT Queries24:02
- Topic 03, Part 12 - Using AND and OR to Create Compound Conditions in SQL12:23
- Topic 03, Part 13 - Using IN, NOT, and BETWEEN in SQL Queries09:18
- Topic 03, Part 14 - Searching Based on Partial Values using the SQL LIKE Statement08:22
- Topic 03, Part 15 - Sorting Data in SQL using ORDER BY09:39
- Topic 03, Part 16 - Using Numeric Functions in SQL - COUNT, MIN, MAX, SUM, AVG, and STDEV09:59
- Topic 03, Part 17 - Using the SQL GROUP BY and HAVING Statements16:51
- Topic 03, Part 18 - Using Subqueries in SQL15:09
- Topic 03, Part 19 - An Overview of Joins and How to use INNER JOINS in SQL13:33
- Topic 03, Part 20 - Using OUTER JOINS in SQL11:24
- Topic 03, Part 21 - Creating and using SQL Views07:33
- Topic 04, Part 01 - The Stages of Database Development19:52
- Topic 04, Part 02 - Entity Classes vs. Entity Instances08:20
- Topic 04, Part 03 - Attributes (Columns) and Identifiers (Keys)07:15
- Topic 04, Part 04 - Depicting Entities in Entity Relationship Diagrams08:21
- Topic 04, Part 05 - Types of Conceptual Relationships in Entity Relationship Models07:17
- Topic 04, Part 06 - Conceptual Crow's Foot Relationship Symbols06:22
- Topic 04, Part 07 - Binary Relationships and Cardinalities26:56
- Topic 04, Part 08 - Crow's Foot Symbols with Cardinalities12:03
- Topic 04, Part 09 - Strong vs. Weak Entities06:08
- Topic 04, Part 10 - Types of Weak Entities13:06
- Topic 04, Part 11 - Supertype and Subtype Entities16:33
- Topic 04, Part 12 - Recursive Relationships06:01
- Topic 05, Part 01 - Transitioning from a Data Model to a Database16:41
- Topic 05, Part 02 - A Review of Normalization15:48
- Topic 05, Part 03 - Denormalization27:54
- Topic 05, Part 04 - Examples of Denormalization19:00
- Topic 05, Part 05 - Considerations for Modeling One-to-One Binary Relationships16:52
- Topic 05, Part 06 - Considerations for Modeling One-to-Many Binary Relationships14:53
- Topic 05, Part 07 - Considerations for Modeling Many-to-Many Relationships22:39
- Topic 05, Part 08 - Implementing and using Recursive Relationships22:08
- Topic 06, Part 01 - The Database Processing Environment and Major Database Administration Functions06:22
- Topic 06, Part 02 - Introduction to Concurrency Control05:12
- Topic 06, Part 03 - Introduction to Database Transactions15:38
- Topic 06, Part 04 - The Lost Update Problem13:18
- Topic 06, Part 05 - Dirty Reads, Inconsistent Reads, and Phantom Reads06:01
- Topic 06, Part 06 - Introduction to Resource Locking19:45
- Topic 06, Part 07 - Optimistic vs. Pessimistic Locking22:26
- Topic 06, Part 08 - ACID Transactions and Transaction Isolation Levels19:17
- Topic 06, Part 09 - Non-Scrollable vs. Scrollable Cursors14:19
- Topic 06, Part 10 - Introduction to Database Security18:18
- Topic 06, Part 11 - Database Security - Permissions and Roles24:45
- Topic 06, Part 12 - Overview of Database Backup and Recovery14:48
- Topic 06, Part 13 - Additional DBA Responsibilities04:42
- Topic 07, Part 01 - Introduction to Database Indexes07:51
- Topic 07, Part 02 - An Intuitive Overview of Database Indexes26:55
- Topic 07, Part 03 - Index Concepts14:37
- Topic 07, Part 04 - B-Tree Indexes26:49
- Topic 07, Part 05 - Clustered vs. Non-Clustered Indexes13:23
- Topic 07, Part 06 - Implementing Indexes in SQL Server11:32
- Topic 07, Part 07 - Other Types of Indexes13:13
- Topic 07, Part 08 - Index Considerations and Guidelines08:30