Dr. Daniel Soper

@UCkuzGLn9nxFwlS0lY2ruuJg - 69.5K subscribers

Home Videos Live Playlists

Topic 07, Part 08 - Index Considerations and Guidelines

Topic 07, Part 08 - Index Considerations and Guidelines Dr. Daniel Soper

1.8K views - 3 years ago

Topic 07, Part 07 - Other Types of Indexes

Topic 07, Part 07 - Other Types of Indexes Dr. Daniel Soper

1.4K views - 3 years ago

Topic 07, Part 06 - Implementing Indexes in SQL Server

Topic 07, Part 06 - Implementing Indexes in SQL Server Dr. Daniel Soper

1.4K views - 3 years ago

Topic 07, Part 05 - Clustered vs. Non-Clustered Indexes

Topic 07, Part 05 - Clustered vs. Non-Clustered Indexes Dr. Daniel Soper

1.7K views - 3 years ago

Topic 07, Part 04 - B-Tree Indexes

Topic 07, Part 04 - B-Tree Indexes Dr. Daniel Soper

2.9K views - 3 years ago

Topic 07, Part 03 - Index Concepts

Topic 07, Part 03 - Index Concepts Dr. Daniel Soper

1.3K views - 3 years ago

Topic 07, Part 02 - An Intuitive Overview of Database Indexes

Topic 07, Part 02 - An Intuitive Overview of Database Indexes Dr. Daniel Soper

1.4K views - 3 years ago

Topic 07, Part 01 - Introduction to Database Indexes

Topic 07, Part 01 - Introduction to Database Indexes Dr. Daniel Soper

2.3K views - 3 years ago

Topic 06, Part 14 - Distributed Database Processing

Topic 06, Part 14 - Distributed Database Processing Dr. Daniel Soper

896 views - 3 years ago

Topic 06, Part 13 - Additional DBA Responsibilities

Topic 06, Part 13 - Additional DBA Responsibilities Dr. Daniel Soper

680 views - 3 years ago

Topic 06, Part 12 - Overview of Database Backup and Recovery

Topic 06, Part 12 - Overview of Database Backup and Recovery Dr. Daniel Soper

1.6K views - 3 years ago

Topic 06, Part 11 - Database Security - Permissions and Roles

Topic 06, Part 11 - Database Security - Permissions and Roles Dr. Daniel Soper

2.3K views - 3 years ago

Topic 06, Part 10 - Introduction to Database Security

Topic 06, Part 10 - Introduction to Database Security Dr. Daniel Soper

4.8K views - 3 years ago

Topic 06, Part 09 - Non-Scrollable vs. Scrollable Cursors

Topic 06, Part 09 - Non-Scrollable vs. Scrollable Cursors Dr. Daniel Soper

947 views - 3 years ago

Topic 06, Part 08 - ACID Transactions and Transaction Isolation Levels

Topic 06, Part 08 - ACID Transactions and Transaction Isolation Levels Dr. Daniel Soper

2.5K views - 3 years ago

Topic 06, Part 07 - Optimistic vs. Pessimistic Locking

Topic 06, Part 07 - Optimistic vs. Pessimistic Locking Dr. Daniel Soper

4.8K views - 3 years ago

Topic 06, Part 06 - Introduction to Resource Locking

Topic 06, Part 06 - Introduction to Resource Locking Dr. Daniel Soper

1.6K views - 3 years ago

Topic 06, Part 05 - Dirty Reads, Inconsistent Reads, and Phantom Reads

Topic 06, Part 05 - Dirty Reads, Inconsistent Reads, and Phantom Reads Dr. Daniel Soper

3.9K views - 3 years ago

Topic 06, Part 04 - The Lost Update Problem

Topic 06, Part 04 - The Lost Update Problem Dr. Daniel Soper

2.2K views - 3 years ago

Topic 06, Part 03 - Introduction to Database Transactions

Topic 06, Part 03 - Introduction to Database Transactions Dr. Daniel Soper

1.6K views - 3 years ago

Topic 06, Part 02 - Introduction to Concurrency Control

Topic 06, Part 02 - Introduction to Concurrency Control Dr. Daniel Soper

1K views - 3 years ago

Topic 06, Part 01 - The Database Processing Environment and Major Database Administration Functions

Topic 06, Part 01 - The Database Processing Environment and Major Database Administration Functions Dr. Daniel Soper

1.2K views - 3 years ago

Topic 05, Part 08 - Implementing and using Recursive Relationships

Topic 05, Part 08 - Implementing and using Recursive Relationships Dr. Daniel Soper

3.5K views - 3 years ago

Topic 05, Part 07 - Considerations for Modeling Many-to-Many Relationships

Topic 05, Part 07 - Considerations for Modeling Many-to-Many Relationships Dr. Daniel Soper

1.2K views - 3 years ago

Topic 05, Part 06 - Considerations for Modeling One-to-Many Binary Relationships

Topic 05, Part 06 - Considerations for Modeling One-to-Many Binary Relationships Dr. Daniel Soper

1.2K views - 3 years ago

Topic 05, Part 05 - Considerations for Modeling One-to-One Binary Relationships

Topic 05, Part 05 - Considerations for Modeling One-to-One Binary Relationships Dr. Daniel Soper

1.5K views - 3 years ago

Topic 05, Part 04 - Examples of Denormalization

Topic 05, Part 04 - Examples of Denormalization Dr. Daniel Soper

4.6K views - 3 years ago

Topic 05, Part 03 - Denormalization

Topic 05, Part 03 - Denormalization Dr. Daniel Soper

1.6K views - 3 years ago

Topic 05, Part 02 - A Review of Normalization

Topic 05, Part 02 - A Review of Normalization Dr. Daniel Soper

1.8K views - 3 years ago

Topic 05, Part 01 - Transitioning from a Data Model to a Database

Topic 05, Part 01 - Transitioning from a Data Model to a Database Dr. Daniel Soper

2.1K views - 3 years ago

Topic 04, Part 12 - Recursive Relationships

Topic 04, Part 12 - Recursive Relationships Dr. Daniel Soper

7.1K views - 3 years ago

Topic 04, Part 11 - Supertype and Subtype Entities

Topic 04, Part 11 - Supertype and Subtype Entities Dr. Daniel Soper

22.6K views - 3 years ago

Topic 04, Part 10 - Types of Weak Entities

Topic 04, Part 10 - Types of Weak Entities Dr. Daniel Soper

10.7K views - 3 years ago

Topic 04, Part 09 - Strong vs. Weak Entities

Topic 04, Part 09 - Strong vs. Weak Entities Dr. Daniel Soper

32.9K views - 3 years ago

Topic 04, Part 08 - Crow's Foot Symbols with Cardinalities

Topic 04, Part 08 - Crow's Foot Symbols with Cardinalities Dr. Daniel Soper

69.4K views - 3 years ago

Topic 04, Part 07 - Binary Relationships and Cardinalities

Topic 04, Part 07 - Binary Relationships and Cardinalities Dr. Daniel Soper

5.6K views - 3 years ago

Topic 04, Part 06 - Conceptual Crow's Foot Relationship Symbols

Topic 04, Part 06 - Conceptual Crow's Foot Relationship Symbols Dr. Daniel Soper

11.2K views - 3 years ago

Topic 04, Part 05 - Types of Conceptual Relationships in Entity Relationship Models

Topic 04, Part 05 - Types of Conceptual Relationships in Entity Relationship Models Dr. Daniel Soper

2.5K views - 3 years ago

Topic 04, Part 04 - Depicting Entities in Entity Relationship Diagrams

Topic 04, Part 04 - Depicting Entities in Entity Relationship Diagrams Dr. Daniel Soper

2.3K views - 3 years ago

Topic 04, Part 03 - Attributes (Columns) and Identifiers (Keys)

Topic 04, Part 03 - Attributes (Columns) and Identifiers (Keys) Dr. Daniel Soper

2.3K views - 3 years ago

Topic 04, Part 02 - Entity Classes vs. Entity Instances

Topic 04, Part 02 - Entity Classes vs. Entity Instances Dr. Daniel Soper

4.5K views - 3 years ago

Topic 04, Part 01 - The Stages of Database Development

Topic 04, Part 01 - The Stages of Database Development Dr. Daniel Soper

3.5K views - 3 years ago

Topic 03, Part 21 - Creating and using SQL Views

Topic 03, Part 21 - Creating and using SQL Views Dr. Daniel Soper

1.2K views - 3 years ago

Topic 03, Part 20 - Using OUTER JOINS in SQL

Topic 03, Part 20 - Using OUTER JOINS in SQL Dr. Daniel Soper

1.4K views - 3 years ago

Topic 03, Part 19 - An Overview of Joins and How to use INNER JOINS in SQL

Topic 03, Part 19 - An Overview of Joins and How to use INNER JOINS in SQL Dr. Daniel Soper

1.7K views - 3 years ago

Topic 03, Part 18 - Using Subqueries in SQL

Topic 03, Part 18 - Using Subqueries in SQL Dr. Daniel Soper

1.5K views - 3 years ago

Topic 03, Part 17 - Using the SQL GROUP BY and HAVING Statements

Topic 03, Part 17 - Using the SQL GROUP BY and HAVING Statements Dr. Daniel Soper

1.4K views - 3 years ago

Topic 03, Part 16 - Using Numeric Functions in SQL - COUNT, MIN, MAX, SUM, AVG, and STDEV

Topic 03, Part 16 - Using Numeric Functions in SQL - COUNT, MIN, MAX, SUM, AVG, and STDEV Dr. Daniel Soper

1.3K views - 3 years ago

Topic 03, Part 15 - Sorting Data in SQL using ORDER BY

Topic 03, Part 15 - Sorting Data in SQL using ORDER BY Dr. Daniel Soper

1.2K views - 3 years ago

Topic 03, Part 14 - Searching Based on Partial Values using the SQL LIKE Statement

Topic 03, Part 14 - Searching Based on Partial Values using the SQL LIKE Statement Dr. Daniel Soper

1.1K views - 3 years ago

Topic 03, Part 13 - Using IN, NOT, and BETWEEN in SQL Queries

Topic 03, Part 13 - Using IN, NOT, and BETWEEN in SQL Queries Dr. Daniel Soper

1.2K views - 3 years ago

Topic 03, Part 12 - Using AND and OR to Create Compound Conditions in SQL

Topic 03, Part 12 - Using AND and OR to Create Compound Conditions in SQL Dr. Daniel Soper

1.2K views - 3 years ago

Topic 03, Part 11 - Introduction to SQL SELECT Queries

Topic 03, Part 11 - Introduction to SQL SELECT Queries Dr. Daniel Soper

1.6K views - 3 years ago

Topic 03, Part 10 - Using SQL CHECK Constraints

Topic 03, Part 10 - Using SQL CHECK Constraints Dr. Daniel Soper

1.3K views - 3 years ago

Topic 03, Part 09 - Deleting Database Objects and Constraints with the SQL DROP Statement

Topic 03, Part 09 - Deleting Database Objects and Constraints with the SQL DROP Statement Dr. Daniel Soper

1.2K views - 3 years ago

Topic 03, Part 08 - Deleting Data using the SQL DELETE FROM Statement

Topic 03, Part 08 - Deleting Data using the SQL DELETE FROM Statement Dr. Daniel Soper

1.2K views - 3 years ago

Topic 03, Part 07 - Modifying Data using the SQL UPDATE Statement

Topic 03, Part 07 - Modifying Data using the SQL UPDATE Statement Dr. Daniel Soper

1.6K views - 3 years ago

Topic 03, Part 06 - Adding Data using the SQL INSERT INTO Statement

Topic 03, Part 06 - Adding Data using the SQL INSERT INTO Statement Dr. Daniel Soper

6K views - 3 years ago

Topic 03, Part 05 - Introduction to the Data Manipulation Language (DML)

Topic 03, Part 05 - Introduction to the Data Manipulation Language (DML) Dr. Daniel Soper

2.6K views - 3 years ago

Topic 03, Part 04 - The SQL ALTER Statement

Topic 03, Part 04 - The SQL ALTER Statement Dr. Daniel Soper

1.7K views - 3 years ago