Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

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

    Microsoft SQL Server Development

    Subscriber Reviews • Browse Similar Topics

    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