Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

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!

Subscriber Reviews

Average Rating: 4.611111111111111 out of 5 rating Based on 18 Ratings

"Microsoft SQL Server Developement" - by narendra_kumar@hotmail.com on 25-MAR-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Regret - can watch only few chapters ?????
Report as Inappropriate

Table of Contents

Chapter/Selection

Time

CHAPTER 1: SQL SERVER OVERVIEW

INTRODUCTION

Play Video

00:02:10

Understanding Client Server Architecture

Play Video

00:08:56

Introducing the Tools

Preview

00:07:18

Selecting an Edition

Preview

00:05:59

Creating Sample Databases

Preview

00:07:48

CHAPTER 2: USING MANAGEMENT STUDIO

INTRODUCTION

Preview

00:00:27

Arranging the Workspace

Preview

00:01:52

Registering Servers

Preview

00:02:12

Explaining Items in the Object Explorer

Preview

00:05:09

Explaining the Database Properties Dialog

Preview

00:05:26

Explaining the Columns Properties Dialog

Preview

00:02:54

Continuing with Object Explorer Items

Preview

00:01:42

Using the Query Editor

Preview

00:04:59

CHAPTER 3: DESIGNING RELATIONAL DATABASES

INTRODUCTION

Preview

00:00:33

Understanding Normalization

Preview

00:02:52

Discovering Patterns

Preview

00:08:39

Avoiding Over Complexity

Preview

00:06:33

Managing Optional Data

Preview

00:05:28

Creating Physical Keys

Preview

00:06:09

Using the Database Diagrammer Tool

Preview

00:04:51

Final Comments

Preview

00:00:23

CHAPTER 4: WORKING WITH SINGLE TABLE QUERIES

INTRODUCTION

Preview

00:00:51

Understanding Query Flow

Preview

00:06:20

Filtering Data with the Where Clause

Preview

00:06:41

Columns, Expressions & Scalar Functions

Preview

00:02:32

Using Case Expressions

Preview

00:05:13

Working with Nulls & Coalesce

Preview

00:03:41

Selecting Environment Functions

Preview

00:01:23

Working with Dates & Times

Preview

00:04:36

Parsing Strings

Preview

00:02:16

Converting Data

Preview

00:02:29

Sorting Data

Preview

00:02:47

Topping Off the Query with Predicates

Preview

00:03:31

CHAPTER 5: MERGING DATA WITH JOINS & UNIONS

INTRODUCTION

Preview

00:00:27

Working with Inner Joins

Preview

00:06:39

Using Left Outer Joins

Preview

00:02:52

Multiplying Data with Cross Joins

Preview

00:02:47

Referencing Self-Joins

Preview

00:03:52

Working with Complex Joins

Preview

00:01:35

Finding the Set Difference

Preview

00:01:50

Stacking Data with Unions

Preview

00:04:36

CHAPTER 6: WORKING WITH SUBQUERIES

INTRODUCTION

Preview

00:00:40

Using Subqueries as Expressions

Preview

00:05:13

Including Subqueries as Lists

Preview

00:02:08

Adding Subqueries as Derived Tables

Preview

00:01:46

Working with Correlated Subqueries

Preview

00:03:49

Solving for X with Relations Division

Preview

00:05:25

CHAPTER 7: AGGREGATING DATA

INTRODUCTION

Preview

00:00:19

Using the New Windowing Functions

Preview

00:05:26

Using Aggregate Functions

Preview

00:03:28

Grouping a Data Set

Preview

00:05:42

Nesting Aggregations

Preview

00:02:43

Filtering Groups & Adding Grand Totals

Preview

00:04:34

Generating Cross Tab Tables (Pivot)

Preview

00:07:38

Calculating Cumulative Sums

Preview

00:04:46

CHAPTER 8: USING FULL-TEXT SEARCH

INTRODUCTION

Preview

00:00:19

Creating a Full-Text Index

Preview

00:05:42

Searching for Words

Preview

00:06:40

Using a Fuzzy Search to Search for Phrases

Preview

00:01:37

CHAPTER 9: SELECTING DATA THROUGH VIEWS

INTRODUCTION

Preview

00:00:21

Creating Views

Preview

00:05:42

Preventing Disappearing Rows

Preview

00:01:56

Protecting from Schema Changes

Preview

00:01:31

Nesting Views

Preview

00:01:53

CHAPTER 10: DISTRIBUTED QUERIES

INTRODUCTION

Preview

00:00:43

Linking to External Data Sources

Preview

00:04:56

Executing Distributed Queries

Preview

00:04:40

Looking at Where the Work Takes Place

Preview

00:02:21

Using Pass Through Queries

Preview

00:02:34

Controlling Distributed Transactions

Preview

00:03:11

CHAPTER 11: MODIFYING DATA

INTRODUCTION

Preview

00:00:43

Inserting Data

Preview

00:10:43

Updating Data

Preview

00:05:57

Deleting Data

Preview

00:05:01

Using the Output Clause

Preview

00:03:34

Final Comments & Credits

Preview

00:03:18

CHAPTER 12: T-SQL & STORED PROCEDURES

INTRODUCTION

Preview

00:00:56

Introducing T-SQL

Preview

00:02:38

Working with Variables

Preview

00:06:51

Controlling Procedural Flow

Preview

00:05:02

Examining SQL Server with Code

Preview

00:03:17

Using Temp Tables

Preview

00:07:43

Developing Dynamic SQL

Preview

00:06:32

Introducing Stored Procedures

Preview

00:04:59

Passing Parameters

Preview

00:03:21

Returning Parameters

Preview

00:04:48

Working with a Cursor

Preview

00:06:40

Handling Errors

Preview

00:06:49

Explaining the Raise Error

Preview

00:05:05

Controlling Transactions

Preview

00:03:47

CHAPTER 13: TRIGGERS & AUDIT TRAILS

INTRODUCTION

Preview

00:00:40

Introducing After Triggers

Preview

00:03:08

Using

Preview

00:04:31

Disabling Triggers

Preview

00:01:11

Using the Update ( ) Function

Preview

00:01:28

Selecting Transaction Data

Preview

00:02:51

Nesting & Recursion

Preview

00:04:56

Enforcing Complex RI

Preview

00:03:33

Auditing Data Changes

Preview

00:08:58

CHAPTER 14: USER-DEFINED FUNCTIONS

INTRODUCTION

Preview

00:00:39

Creating Scalar Functions

Preview

00:04:43

Working with Inline Table-Valued Functions

Preview

00:03:50

Using Multi-Statement Table-Valued UDFs

Preview

00:02:16

Navigating a Hierarchy

Preview

00:08:01

Having Fun with Apply

Preview

00:02:42

Exploring Functions in Nordic

Preview

00:04:39

CHAPTER 15: INDEXING FOR PERFORMANCE

INTRODUCTION

Preview

00:00:46

Introducing Indexes

Preview

00:05:52

Creating Indexes

Preview

00:08:14

Examinging Query Execution Plans, Pt. 0

Preview

00:10:03

Examinging Query Execution Plans, Pt. 1

Preview

00:06:41

CHAPTER 16: TRANSACTIONS, LOCKING & BLOCKING

INTRODUCTION

Preview

00:00:28

Introducing ACID

Preview

00:02:01

Understanding Transactional Faults

Preview

00:07:44

Stepping through a Transaction

Preview

00:03:32

Exploring Locks

Preview

00:05:42

Working with Locks

Preview

00:04:12

Viewing Deadlocks

Preview

00:05:30

Using Snapshot Isolation

Preview

00:03:46

CHAPTER 17: INTRODUCTION TO OPTIMIZATION THEORY

INTRODUCTION

Preview

00:00:20

Deconstructing the Database System

Preview

00:03:55

Walking through Optimization Theory

Preview

00:07:21

Optimization Theory Continued

Preview

00:06:42

Final Comments & Credits

Preview

00:03:15

Extras

The publisher has provided additional content related to this title.


Description
Content

Exercise file

  • TSQL05_P01_PF.zip

Exercise file

  • TSQL05_P01_PF.sit