SQL Server Development

$29.99

Learn 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!

Length: 8 hours 18 min

This title is available in the
Total Training All-Access library.

Subscribe Now

SKU: N/A Categories: , , , Tags: , ,

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!

About the Lessons
This comprehensive set of video tutorials will help you increase productivity and write stored procedures using the language with which you’re most familiar. You’ll learn to develop SQL Server database and data connections, administer SQL Server, and keep databases performing at their peak. In addition, you’ll find dozens of specific examples in both a graphical format and as SQL code as well as numerous best practices describing the most effective way to accomplish a given task.

Highlights

• Master the fundamentals of SQL Server technology.
• Learn how to write better logic queries for greater success.
• Manage and secure a production database 24/7/365.
• Discover how to integrate with .NET CLR and XML.
• Understand how to measure performance, lock transactions, and scale very large databases.

Total Training™ for Microsoft® SQL Server™ Development

P01 Introduction to SQL Server 2005 1:30:32

L01 SQL SERVER OVERVIEW 32:15

L01_T01 Understanding Client Server Architecture

L01_T02 Introducing the Tools

L01_T03 Selecting an Addition

L01_T04 Creating Sample Databases

L02 USING MANAGEMENT STUDIO 22:44

L02_T01 Arranging the Workspace

L02_T02 Registering Servers

L02_T03 Explaining Items in the Object Explorer

L02_T04 Explaining the Database Properties Dialog

L02_T05 Explaining the Columns Properties Dialog

L02_T06 Continuing with Object Explorer Items

L02_T07 Using the Query Editor

L03 DESIGNING RELATIONAL DATABASES 35:33

L03_T01 Understanding Normalization

L03_T02 Discovering Patterns

L03_T03 Avoiding Over Complexity

L03_T04 Managing Optional Data

L03_T05 Creating Physical Keys

L03_T06 Using the Database Diagrammer Tool

L03_T07 Final Comments

P02 Selecting Data 3:14:29

L01 WORKING WITH SINGLE TABLE QUERIES 42:28

L01_T01 Understanding Query Flow

L01_T02 Filtering Data with the Where Clause

L01_T03 Columns, Expressions & Scalar Functions

L01_T04 Using Case Expressions

L01_T05 Working with Nulls & Coalesce

L01_T06 Selecting Environment Functions

L01_T07 Working with Dates & Times

L01_T08 Parsing Strings

L01_T09 Converting Data

L01_T10 Sorting Data

L01_T11 Topping Off the Query with Predicates

L02 MERGING DATA WITH JOINS & UNIONS 24:42

L02_T01 Working with Inner Joins

L02_T02 Using Left Outer Joins

L02_T03 Multiplying Data with Cross Joins

L02_T04 Referencing Self-Joins

L02_T05 Working with Complex Joins

L02_T06 Finding the Set Difference

L02_T07 Stacking Data with Unions

L03 WORKING WITH SUBQUERIES 19:05

L03_T01 Using Subqueries as Expressions

L03_T02 Including Subqueries as Lists

L03_T03 Adding Subqueries as Derived Tables

L03_T04 Working with Correlated Subqueries

L03_T05 Solving for X with Relations Division

L04 AGGREGATING DATA 34:41

L04_T01 Using the New Windowing Functions

L04_T02 Using Aggregate Functions

L04_T03 Grouping a Data Set

L04_T04 Nesting Aggregations

L04_T05 Filtering Groups & Adding Grand Totals

L04_T06 Generating Cross Tab Tables (Pivot)

L04_T07 Calculating Cumulative Sums

L05 USING FULL-TEXT SEARCH 14:19

L05_T01 Creating a Full-Text Index

L05_T02 Searching for Words

L05_T03 Using a Fuzzy Search to Search for Phrases

L06 SELECTING DATA THROUGH VIEWS 11:26

L06_T01 Creating Views

L06_T02 Preventing Disappearing Rows

L06_T03 Protecting from Schema Changes

L06_T04 Nesting Views

L07 DISTRIBUTED QUERIES 18:28

L07_T01 Linking to External Data Sources

L07_T02 Executing Distributed Queries

L07_T03 Looking at Where the Work Takes Place

L07_T04 Using Pass Through Queries

L07_T05 Controlling Distributed Transactions

L08 MODIFYING DATA 29:20

L08_T01 Inserting Data

L08_T02 Updating Data

L08_T03 Deleting Data

L08_T04 Using the Output Clause

L08_T05Final Comments & Credits

__________________________________________________________________

P03 Developing Solutions 3:33:01

L01 T-SQL & STORED PROCEDURES 1:08:36

L01_T01 Introducing T-SQL

L01_T02 Working with Variables

L01_T03 Controlling Procedural Flow

L01_T04 Examining SQL Server with Code

L01_T05 Using Temp Tables

L01_T06 Developing Dynamic SQL

L01_T07 Introducing Stored Procedures

L01_T08 Passing Parameters

L01_T09 Returning Parameters

L01_T10 Working with a Cursor

L01_T11 Handling Errors

L01_T12Explaining the Raise Error

L01_T13 Controlling Transactions

L02 TRIGGERS & AUDIT TRAILS 31:20

L02_T01 Introducing After Triggers

L02_T02 Using “Instead of” Trigger

L02_T03 Disabling Triggers

L02_T04 Using the Update ( ) Function

L02_T05 Selecting Transaction Data

L02_T06 Nesting & Recursion

L02_T07 Enforcing Complex RI

L02_T08 Auditing Data Changes

L03 USER-DEFINED FUNCTIONS 26:52

L03_T01 Creating Scalar Functions

L03_T02 Working with Inline Table-Valued Functions

L03_T03 Using Multi-Statement Table-Valued UDFs

L03_T04 Navigating a Hierarchy

L03_T05 Having Fun with Apply

L03_T06 Exploring Functions in Nordic

L04 INDEXING FOR PERFORMANCE 31:38

L04_T01Introducing Indexes

L04_T02 Creating Indexes

L04_T03 Examinging Query Execution Plans, Pt. 1

L04_T04 Examinging Query Execution Plans, Pt. 2

L05 TRANSACTIONS, LOCKING & BLOCKING 33:00

L05_T01 Introducing ACID

L05_T02 Understanding Transactional Faults

L05_T03 Stepping through a Transaction

L05_T04 Exploring Locks

L05_T05 Working with Locks

L05_T06 Viewing Deadlocks

L05_T07 Using Snapshot Isolation

L06 INTRODUCTION TO OPTIMIZATION THEORY 21:35

L06_T01 Deconstructing the Database System

L06_T02 Walking through Optimization Theory

L06_T03 Optimization Theory Continued

L06_T04 Final Comments & Credits

Paul NielsenPaul Nielsen is a hands-on database developer, Microsoft SQL Server MVP, a trainer specializing in data architecture and Microsoft SQL Server technologies, and author of many books including SQL Server 2005 Bible. Paul also serves on the PASS (Professional Association for SQL Server) Board of Directors, and is active in the Colorado area SQL Server user groups.