Dr. Daniel Soper

Topic 07, Part 08 - Index Considerations and Guidelines
Topic 07, Part 08 - Index Considerations and Guidelines
Topic 07, Part 07 - Other Types of Indexes
Topic 07, Part 07 - Other Types of Indexes
Topic 07, Part 06 - Implementing Indexes in SQL Server
Topic 07, Part 06 - Implementing Indexes in SQL Server
Topic 07, Part 05 - Clustered vs. Non-Clustered Indexes
Topic 07, Part 05 - Clustered vs. Non-Clustered Indexes
Topic 07, Part 04 - B-Tree Indexes
Topic 07, Part 04 - B-Tree Indexes
Topic 07, Part 03 - Index Concepts
Topic 07, Part 03 - Index Concepts
Topic 07, Part 02 - An Intuitive Overview of Database Indexes
Topic 07, Part 02 - An Intuitive Overview of Database Indexes
Topic 07, Part 01 - Introduction to Database Indexes
Topic 07, Part 01 - Introduction to Database Indexes
Topic 06, Part 14 - Distributed Database Processing
Topic 06, Part 14 - Distributed Database Processing
Topic 06, Part 13 - Additional DBA Responsibilities
Topic 06, Part 13 - Additional DBA Responsibilities
Topic 06, Part 12 - Overview of Database Backup and Recovery
Topic 06, Part 12 - Overview of Database Backup and Recovery
Topic 06, Part 11 - Database Security - Permissions and Roles
Topic 06, Part 11 - Database Security - Permissions and Roles
Topic 06, Part 10 - Introduction to Database Security
Topic 06, Part 10 - Introduction to Database Security
Topic 06, Part 09 - Non-Scrollable vs. Scrollable Cursors
Topic 06, Part 09 - Non-Scrollable vs. Scrollable Cursors
Topic 06, Part 08 - ACID Transactions and Transaction Isolation Levels
Topic 06, Part 08 - ACID Transactions and Transaction Isolation Levels
Topic 06, Part 07 - Optimistic vs. Pessimistic Locking
Topic 06, Part 07 - Optimistic vs. Pessimistic Locking
Topic 06, Part 06 - Introduction to Resource Locking
Topic 06, Part 06 - Introduction to Resource Locking
Topic 06, Part 05 - Dirty Reads, Inconsistent Reads, and Phantom Reads
Topic 06, Part 05 - Dirty Reads, Inconsistent Reads, and Phantom Reads
Topic 06, Part 04 - The Lost Update Problem
Topic 06, Part 04 - The Lost Update Problem
Topic 06, Part 03 - Introduction to Database Transactions
Topic 06, Part 03 - Introduction to Database Transactions
Topic 06, Part 02 - Introduction to Concurrency Control
Topic 06, Part 02 - Introduction to Concurrency Control
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
Topic 05, Part 08 - Implementing and using Recursive Relationships
Topic 05, Part 08 - Implementing and using Recursive Relationships
Topic 05, Part 07 - Considerations for Modeling Many-to-Many Relationships
Topic 05, Part 07 - Considerations for Modeling Many-to-Many Relationships
Topic 05, Part 06 - Considerations for Modeling One-to-Many Binary Relationships
Topic 05, Part 06 - Considerations for Modeling One-to-Many Binary Relationships
Topic 05, Part 05 - Considerations for Modeling One-to-One Binary Relationships
Topic 05, Part 05 - Considerations for Modeling One-to-One Binary Relationships
Topic 05, Part 04 - Examples of Denormalization
Topic 05, Part 04 - Examples of Denormalization
Topic 05, Part 03 - Denormalization
Topic 05, Part 03 - Denormalization
Topic 05, Part 02 - A Review of Normalization
Topic 05, Part 02 - A Review of Normalization
Topic 05, Part 01 - Transitioning from a Data Model to a Database
Topic 05, Part 01 - Transitioning from a Data Model to a Database