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