Database Design & Management Class!
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.0
(6)
45 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
This course includes
- 18.3 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 81 lessons • 18.3 hours of video
Comprehensive Guide to Database Systems and SQL
81 lessons
• 18.3 hours
Comprehensive Guide to Database Systems and SQL
81 lessons
• 18.3 hours
- Topic 01, Part 01 - The Purpose of a Database 06:52
- Topic 01, Part 02 - Problems with Storing Data in a List 08:57
- Topic 01, Part 03 - List Modification Issues 16:33
- Topic 01, Part 04 - Introduction to Relational Databases 19: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 Systems 11:43
- Topic 01, Part 07 - Users and Databases - Components of a Database System 23:11
- Topic 01, Part 08 - The DBMS and Database Applications - Components of a Database System 15:20
- Topic 01, Part 09 - Personal vs. Enterprise-Level Database Systems 08:08
- Topic 02, Part 01 - Database Entities 09:20
- Topic 02, Part 02 - Characteristics of Relations 15:10
- Topic 02, Part 03 - Introduction to Database Keys 10:28
- Topic 02, Part 04 - Composite Keys 09:16
- Topic 02, Part 05 - Candidate Keys 07:55
- Topic 02, Part 06 - Primary Keys and Surrogate Keys 09:34
- Topic 02, Part 07 - Foreign Keys and Relationships Between Tables 28:03
- Topic 02, Part 08 - Null Values 12:08
- Topic 02, Part 09 - Functional Dependencies 04:25
- Topic 02, Part 10 - Normalization and Normal Forms 24:33
- Topic 03, Part 01 - Introduction to SQL 10:00
- Topic 03, Part 02 - Introduction to the SQL CREATE TABLE Statement 26:34
- Topic 03, Part 03 - Creating Primary Keys and Foreign Keys using SQL 35:07
- Topic 03, Part 04 - The SQL ALTER Statement 08:37
- Topic 03, Part 05 - Introduction to the Data Manipulation Language (DML) 04:09
- Topic 03, Part 06 - Adding Data using the SQL INSERT INTO Statement 11:38
- Topic 03, Part 07 - Modifying Data using the SQL UPDATE Statement 07:31
- Topic 03, Part 08 - Deleting Data using the SQL DELETE FROM Statement 03:26
- Topic 03, Part 09 - Deleting Database Objects and Constraints with the SQL DROP Statement 04:38
- Topic 03, Part 10 - Using SQL CHECK Constraints 06:05
- Topic 03, Part 11 - Introduction to SQL SELECT Queries 24:03
- Topic 03, Part 12 - Using AND and OR to Create Compound Conditions in SQL 12:24
- Topic 03, Part 13 - Using IN, NOT, and BETWEEN in SQL Queries 09:18
- Topic 03, Part 14 - Searching Based on Partial Values using the SQL LIKE Statement 08:22
- Topic 03, Part 15 - Sorting Data in SQL using ORDER BY 09:39
- Topic 03, Part 16 - Using Numeric Functions in SQL - COUNT, MIN, MAX, SUM, AVG, and STDEV 10:00
- Topic 03, Part 17 - Using the SQL GROUP BY and HAVING Statements 16:52
- Topic 03, Part 18 - Using Subqueries in SQL 15:09
- Topic 03, Part 19 - An Overview of Joins and How to use INNER JOINS in SQL 13:33
- Topic 03, Part 20 - Using OUTER JOINS in SQL 11:25
- Topic 03, Part 21 - Creating and using SQL Views 07:34
- Topic 04, Part 01 - The Stages of Database Development 19:52
- Topic 04, Part 02 - Entity Classes vs. Entity Instances 08:20
- Topic 04, Part 03 - Attributes (Columns) and Identifiers (Keys) 07:16
- Topic 04, Part 04 - Depicting Entities in Entity Relationship Diagrams 08:22
- Topic 04, Part 05 - Types of Conceptual Relationships in Entity Relationship Models 07:17
- Topic 04, Part 06 - Conceptual Crow's Foot Relationship Symbols 06:22
- Topic 04, Part 07 - Binary Relationships and Cardinalities 26:57
- Topic 04, Part 08 - Crow's Foot Symbols with Cardinalities 12:03
- Topic 04, Part 09 - Strong vs. Weak Entities 06:09
- Topic 04, Part 10 - Types of Weak Entities 13:07
- Topic 04, Part 11 - Supertype and Subtype Entities 16:34
- Topic 04, Part 12 - Recursive Relationships 06:02
- Topic 05, Part 01 - Transitioning from a Data Model to a Database 16:42
- Topic 05, Part 02 - A Review of Normalization 15:48
- Topic 05, Part 03 - Denormalization 27:54
- Topic 05, Part 04 - Examples of Denormalization 19:01
- Topic 05, Part 05 - Considerations for Modeling One-to-One Binary Relationships 16:52
- Topic 05, Part 06 - Considerations for Modeling One-to-Many Binary Relationships 14:53
- Topic 05, Part 07 - Considerations for Modeling Many-to-Many Relationships 22:39
- Topic 05, Part 08 - Implementing and using Recursive Relationships 22:09
- Topic 06, Part 01 - The Database Processing Environment and Major Database Administration Functions 06:23
- Topic 06, Part 02 - Introduction to Concurrency Control 05:12
- Topic 06, Part 03 - Introduction to Database Transactions 15:38
- Topic 06, Part 04 - The Lost Update Problem 13:19
- Topic 06, Part 05 - Dirty Reads, Inconsistent Reads, and Phantom Reads 06:02
- Topic 06, Part 06 - Introduction to Resource Locking 19:45
- Topic 06, Part 07 - Optimistic vs. Pessimistic Locking 22:26
- Topic 06, Part 08 - ACID Transactions and Transaction Isolation Levels 19:17
- Topic 06, Part 09 - Non-Scrollable vs. Scrollable Cursors 14:19
- Topic 06, Part 10 - Introduction to Database Security 18:18
- Topic 06, Part 11 - Database Security - Permissions and Roles 24:46
- Topic 06, Part 12 - Overview of Database Backup and Recovery 14:48
- Topic 06, Part 13 - Additional DBA Responsibilities 04:42
- Topic 07, Part 01 - Introduction to Database Indexes 07:52
- Topic 07, Part 02 - An Intuitive Overview of Database Indexes 26:55
- Topic 07, Part 03 - Index Concepts 14:37
- Topic 07, Part 04 - B-Tree Indexes 26:50
- Topic 07, Part 05 - Clustered vs. Non-Clustered Indexes 13:23
- Topic 07, Part 06 - Implementing Indexes in SQL Server 11:33
- Topic 07, Part 07 - Other Types of Indexes 13:13
- Topic 07, Part 08 - Index Considerations and Guidelines 08:30
Related learning topics
Take this course with you
Download the app to continue lessons from your phone anytime.
