Dr. Daniel Soper
68,100 Subscribers
Topic 07, Part 08 - Index Considerations and Guidelines
Dr. Daniel Soper
Topic 07, Part 07 - Other Types of Indexes
Dr. Daniel Soper
Topic 07, Part 06 - Implementing Indexes in SQL Server
Dr. Daniel Soper
Topic 07, Part 05 - Clustered vs. Non-Clustered Indexes
Dr. Daniel Soper
Topic 07, Part 04 - B-Tree Indexes
Dr. Daniel Soper
Topic 07, Part 03 - Index Concepts
Dr. Daniel Soper
Topic 07, Part 02 - An Intuitive Overview of Database Indexe
Dr. Daniel Soper
Topic 07, Part 01 - Introduction to Database Indexes
Dr. Daniel Soper
Topic 06, Part 14 - Distributed Database Processing
Dr. Daniel Soper
Topic 06, Part 13 - Additional DBA Responsibilities
Dr. Daniel Soper
Topic 06, Part 12 - Overview of Database Backup and Recovery
Dr. Daniel Soper
Topic 06, Part 11 - Database Security - Permissions and Role
Dr. Daniel Soper
Topic 06, Part 10 - Introduction to Database Security
Dr. Daniel Soper
Topic 06, Part 09 - Non-Scrollable vs. Scrollable Cursors
Dr. Daniel Soper
Topic 06, Part 08 - ACID Transactions and Transaction Isolat
Dr. Daniel Soper
Topic 06, Part 07 - Optimistic vs. Pessimistic Locking
Dr. Daniel Soper
Topic 06, Part 06 - Introduction to Resource Locking
Dr. Daniel Soper
Topic 06, Part 05 - Dirty Reads, Inconsistent Reads, and Pha
Dr. Daniel Soper
Topic 06, Part 04 - The Lost Update Problem
Dr. Daniel Soper
Topic 06, Part 03 - Introduction to Database Transactions
Dr. Daniel Soper
Topic 06, Part 02 - Introduction to Concurrency Control
Dr. Daniel Soper
Topic 06, Part 01 - The Database Processing Environment and
Dr. Daniel Soper
Topic 05, Part 08 - Implementing and using Recursive Relatio
Dr. Daniel Soper
Topic 05, Part 07 - Considerations for Modeling Many-to-Many
Dr. Daniel Soper
Topic 05, Part 06 - Considerations for Modeling One-to-Many
Dr. Daniel Soper
Topic 05, Part 05 - Considerations for Modeling One-to-One B
Dr. Daniel Soper
Topic 05, Part 04 - Examples of Denormalization
Dr. Daniel Soper
Topic 05, Part 03 - Denormalization
Dr. Daniel Soper
Topic 05, Part 02 - A Review of Normalization
Dr. Daniel Soper
Topic 05, Part 01 - Transitioning from a Data Model to a Dat
Dr. Daniel Soper
Topic 04, Part 12 - Recursive Relationships
Dr. Daniel Soper
Topic 04, Part 11 - Supertype and Subtype Entities
Dr. Daniel Soper
Topic 04, Part 10 - Types of Weak Entities
Dr. Daniel Soper
Topic 04, Part 09 - Strong vs. Weak Entities
Dr. Daniel Soper
Topic 04, Part 08 - Crow's Foot Symbols with Cardinaliti
Dr. Daniel Soper
Topic 04, Part 07 - Binary Relationships and Cardinalities
Dr. Daniel Soper
Topic 04, Part 06 - Conceptual Crow's Foot Relationship
Dr. Daniel Soper
Topic 04, Part 05 - Types of Conceptual Relationships in Ent
Dr. Daniel Soper
Topic 04, Part 04 - Depicting Entities in Entity Relationshi
Dr. Daniel Soper
Topic 04, Part 03 - Attributes (Columns) and Identifiers (Ke
Dr. Daniel Soper
Topic 04, Part 02 - Entity Classes vs. Entity Instances
Dr. Daniel Soper
Topic 04, Part 01 - The Stages of Database Development
Dr. Daniel Soper
Topic 03, Part 21 - Creating and using SQL Views
Dr. Daniel Soper
Topic 03, Part 20 - Using OUTER JOINS in SQL
Dr. Daniel Soper
Topic 03, Part 19 - An Overview of Joins and How to use INNE
Dr. Daniel Soper
Topic 03, Part 18 - Using Subqueries in SQL
Dr. Daniel Soper
Topic 03, Part 17 - Using the SQL GROUP BY and HAVING Statem
Dr. Daniel Soper
Topic 03, Part 16 - Using Numeric Functions in SQL - COUNT,
Dr. Daniel Soper
Topic 03, Part 15 - Sorting Data in SQL using ORDER BY
Dr. Daniel Soper
Topic 03, Part 14 - Searching Based on Partial Values using
Dr. Daniel Soper
