O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft SQL Server Development

Video Description

Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed!

Table of Contents

  1. CHAPTER 1: SQL SERVER OVERVIEW
    1. INTRODUCTION 00:02:11
    2. Understanding Client Server Architecture 00:08:57
    3. Introducing the Tools 00:07:19
    4. Selecting an Edition 00:06:00
    5. Creating Sample Databases 00:07:49
  2. CHAPTER 2: USING MANAGEMENT STUDIO
    1. INTRODUCTION 00:00:28
    2. Arranging the Workspace 00:01:52
    3. Registering Servers 00:02:12
    4. Explaining Items in the Object Explorer 00:05:09
    5. Explaining the Database Properties Dialog 00:05:26
    6. Explaining the Columns Properties Dialog 00:02:54
    7. Continuing with Object Explorer Items 00:01:42
    8. Using the Query Editor 00:05:00
  3. CHAPTER 3: DESIGNING RELATIONAL DATABASES
    1. INTRODUCTION 00:00:33
    2. Understanding Normalization 00:02:53
    3. Discovering Patterns 00:08:40
    4. Avoiding Over Complexity 00:06:34
    5. Managing Optional Data 00:05:29
    6. Creating Physical Keys 00:06:10
    7. Using the Database Diagrammer Tool 00:04:52
    8. Final Comments 00:00:24
  4. CHAPTER 4: WORKING WITH SINGLE TABLE QUERIES
    1. INTRODUCTION 00:00:52
    2. Understanding Query Flow 00:06:21
    3. Filtering Data with the Where Clause 00:06:42
    4. Columns, Expressions & Scalar Functions 00:02:33
    5. Using Case Expressions 00:05:13
    6. Working with Nulls & Coalesce 00:03:42
    7. Selecting Environment Functions 00:01:24
    8. Working with Dates & Times 00:04:37
    9. Parsing Strings 00:02:17
    10. Converting Data 00:02:29
    11. Sorting Data 00:02:48
    12. Topping Off the Query with Predicates 00:03:32
  5. CHAPTER 5: MERGING DATA WITH JOINS & UNIONS
    1. INTRODUCTION 00:00:27
    2. Working with Inner Joins 00:06:40
    3. Using Left Outer Joins 00:02:53
    4. Multiplying Data with Cross Joins 00:02:48
    5. Referencing Self-Joins 00:03:52
    6. Working with Complex Joins 00:01:36
    7. Finding the Set Difference 00:01:51
    8. Stacking Data with Unions 00:04:37
  6. CHAPTER 6: WORKING WITH SUBQUERIES
    1. INTRODUCTION 00:00:40
    2. Using Subqueries as Expressions 00:05:14
    3. Including Subqueries as Lists 00:02:09
    4. Adding Subqueries as Derived Tables 00:01:47
    5. Working with Correlated Subqueries 00:03:50
    6. Solving for X with Relations Division 00:05:26
  7. CHAPTER 7: AGGREGATING DATA
    1. INTRODUCTION 00:00:20
    2. Using the New Windowing Functions 00:05:27
    3. Using Aggregate Functions 00:03:28
    4. Grouping a Data Set 00:05:43
    5. Nesting Aggregations 00:02:44
    6. Filtering Groups & Adding Grand Totals 00:04:34
    7. Generating Cross Tab Tables (Pivot) 00:07:39
    8. Calculating Cumulative Sums 00:04:47
  8. CHAPTER 8: USING FULL-TEXT SEARCH
    1. INTRODUCTION 00:00:20
    2. Creating a Full-Text Index 00:05:42
    3. Searching for Words 00:06:41
    4. Using a Fuzzy Search to Search for Phrases 00:01:37
  9. CHAPTER 9: SELECTING DATA THROUGH VIEWS
    1. INTRODUCTION 00:00:21
    2. Creating Views 00:05:43
    3. Preventing Disappearing Rows 00:01:57
    4. Protecting from Schema Changes 00:01:32
    5. Nesting Views 00:01:54
  10. CHAPTER 10: DISTRIBUTED QUERIES
    1. INTRODUCTION 00:00:44
    2. Linking to External Data Sources 00:04:57
    3. Executing Distributed Queries 00:04:40
    4. Looking at Where the Work Takes Place 00:02:22
    5. Using Pass Through Queries 00:02:35
    6. Controlling Distributed Transactions 00:03:11
  11. CHAPTER 11: MODIFYING DATA
    1. INTRODUCTION 00:00:44
    2. Inserting Data 00:10:43
    3. Updating Data 00:05:57
    4. Deleting Data 00:05:02
    5. Using the Output Clause 00:03:35
    6. Final Comments & Credits 00:03:19
  12. CHAPTER 12: T-SQL & STORED PROCEDURES
    1. INTRODUCTION 00:00:57
    2. Introducing T-SQL 00:02:39
    3. Working with Variables 00:06:52
    4. Controlling Procedural Flow 00:05:02
    5. Examining SQL Server with Code 00:03:18
    6. Using Temp Tables 00:07:44
    7. Developing Dynamic SQL 00:06:32
    8. Introducing Stored Procedures 00:05:00
    9. Passing Parameters 00:03:22
    10. Returning Parameters 00:04:49
    11. Working with a Cursor 00:06:40
    12. Handling Errors 00:06:50
    13. Explaining the Raise Error 00:05:06
    14. Controlling Transactions 00:03:48
  13. CHAPTER 13: TRIGGERS & AUDIT TRAILS
    1. INTRODUCTION 00:00:40
    2. Introducing After Triggers 00:03:08
    3. Using 00:04:32
    4. Disabling Triggers 00:01:12
    5. Using the Update ( ) Function 00:01:29
    6. Selecting Transaction Data 00:02:52
    7. Nesting & Recursion 00:04:56
    8. Enforcing Complex RI 00:03:34
    9. Auditing Data Changes 00:08:58
  14. CHAPTER 14: USER-DEFINED FUNCTIONS
    1. INTRODUCTION 00:00:39
    2. Creating Scalar Functions 00:04:43
    3. Working with Inline Table-Valued Functions 00:03:50
    4. Using Multi-Statement Table-Valued UDFs 00:02:17
    5. Navigating a Hierarchy 00:08:01
    6. Having Fun with Apply 00:02:43
    7. Exploring Functions in Nordic 00:04:39
  15. CHAPTER 15: INDEXING FOR PERFORMANCE
    1. INTRODUCTION 00:00:47
    2. Introducing Indexes 00:05:53
    3. Creating Indexes 00:08:14
    4. Examinging Query Execution Plans, Pt. 0 00:10:04
    5. Examinging Query Execution Plans, Pt. 1 00:06:41
  16. CHAPTER 16: TRANSACTIONS, LOCKING & BLOCKING
    1. INTRODUCTION 00:00:29
    2. Introducing ACID 00:02:02
    3. Understanding Transactional Faults 00:07:45
    4. Stepping through a Transaction 00:03:33
    5. Exploring Locks 00:05:42
    6. Working with Locks 00:04:13
    7. Viewing Deadlocks 00:05:31
    8. Using Snapshot Isolation 00:03:47
  17. CHAPTER 17: INTRODUCTION TO OPTIMIZATION THEORY
    1. INTRODUCTION 00:00:21
    2. Deconstructing the Database System 00:03:55
    3. Walking through Optimization Theory 00:07:22
    4. Optimization Theory Continued 00:06:42
    5. Final Comments & Credits 00:03:15