| Title | Skill | Minutes |
Database Diagrams - An Introduction
| 100 |
9:00 |
|
Pages, Extents, and Blocksizes - What They Are and How They Work
| 300 |
10:00 |
|
An Overview of the AdventureWorksDW Database
| 200 |
24:00 |
|
An Overview of the Northwind Database
| 100 |
14:00 |
|
COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data
| 300 |
17:00 |
|
Creating Database Diagrams in SQL Server Management Studio
| 200 |
18:00 |
|
Part 1 - An Overview of the AdventureWorks Database
| 100 |
17:00 |
|
Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them
| 300 |
12:00 |
|
Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs
| 300 |
14:00 |
|
TempDb Database - An Overview of How it Works and When to Use It
| 300 |
12:00 |
|
Templates in SQL Server Management Studio - What They Are and How to Use Them
| 200 |
9:00 |
|
Using the PIVOT Operator - An introduction to PIVOT Tables and Crosstab Queries with PIVOT
| 300 |
23:00 |
|
Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)
| 100 |
5:00 |
|
Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work
| 200 |
8:00 |
|
Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server 2000
| 300 |
10:00 |
|
Creating Your Own System Functions (SQL Server 2000)
| 500 |
9:00 |
|
Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Multi Column Test)
| 300 |
13:00 |
|
Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life
| 200 |
7:00 |
|
Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Generate Your Data Dictionary
| 300 |
10:00 |
|
How to Return Identity Value for a Just-Inserted Row
| 200 |
16:00 |
|
JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?
| 300 |
7:00 |
|
Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000)
| 400 |
11:00 |
|
Part 1 - Identity Columns - When Should I Use an Identity Column?
| 100 |
19:00 |
|
Part 2 - Identity Columns - When Should I Use an Identity Column?
| 100 |
11:00 |
|
Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands
| 300 |
21:00 |
|
Rapid Database Development Using Database Diagrams (SQL Server 2000)
| 100 |
9:00 |
|
Should I use a Check Constraint or a Foreign Key - Best Practices and Design (SQL Server 2000)
| 300 |
12:00 |
|
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs
| 300 |
17:00 |
|
The Differences Between Local Temporary Tables and Global Temp Tables and When to Use Each
| 300 |
13:00 |
|
Two Ways to Generate Random Numbers and Random Rows From a SQL Server Table (SQL Server 2000)
| 300 |
17:00 |
|
User-Defined Functions (UDFs) - What They Are and How to Use Them (SQL Server 2000)
| 200 |
16:00 |
|
Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)
| 300 |
17:00 |
|
Using the Create Index Wizard in the Enterprise Manager (SQL Server 2000)
| 200 |
16:00 |
|
Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard
| 100 |
16:00 |
|
Views: Introduction, When and Where to Use, and Using the Create View Wizard
| 100 |
17:00 |
|
Variables and Scoping - Local Variables and Batch Terminators
| 200 |
8:00 |
|
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause
| 300 |
11:00 |
|
Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY
| 300 |
12:00 |
|
Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage
| 200 |
19:00 |
|
Pt. 2 - CREATE PROCEDURE Syntax and Execution
| 200 |
13:00 |
|
Pt. 3 - Input Parameters and Variables
| 200 |
10:00 |
|
Pt. 4 - OUTPUT Parameters and How to Use Them
| 200 |
22:00 |
|
Pt. 5 - RETURN Codes and How to Use Them
| 200 |
14:00 |
|
DATETIME and SMALLDATETIME - Working with Dates and Times SQL Server
| 200 |
15:00 |
|
Pt. 1 - Introduction to Using XML with SQL Server
| 300 |
14:00 |
|
XML Schema Collections and Using Typed and Untyped XML Data
| 400 |
12:00 |
|
Pt. 1 - Using FOR XML Clauses in SQL Server
| 400 |
13:00 |
|
Pt. 2 - Using FOR XML Clauses in SQL Server
| 400 |
16:00 |
|
Pt. 1 - An Overview of the Three Types of User Defined Functions (UDFs)
| 300 |
11:00 |
|
Pt. 2 - Working with Scalar-Valued UDFs
| 300 |
12:00 |
|
Pt. 4 - Writing Inline UDFs and Multi-Statement UDFs
| 300 |
11:00 |
|
How to Choose Whether to Use a Function, a View or a Stored Procedure
| 300 |
16:00 |
|
01 - An Introduction to Datatype Conversion
| 200 |
11:00 |
|
02 - Implicit Datatype Conversion and How SQL Server Converts Data in Expressions
| 200 |
11:00 |
|
06 - Explicit Datatype Conversion Using CAST and CONVERT
| 300 |
17:00 |
|
07 - More on Using CAST and CONVERT to Do Datatype Conversion
| 300 |
12:00 |
|
08 - Understanding Datatype Precedence in Implict Conversions
| 300 |
11:00 |
|
Pt. 1 - An Overview of the INSERT Statement in Transact SQL
| 100 |
11:00 |
|
Pt. 1 - An Overview of the SELECT Statement: Clauses and Sequence
| 100 |
11:00 |
|
Pt. 3 - Writing WHERE Clauses and Filtering Your Data
| 100 |
14:00 |
|
Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL
| 200 |
14:00 |
|
Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)
| 200 |
10:00 |
|
How to Get the Most Out of SSMS: Understanding the Tabbed Environment
| 100 |
9:00 |
|
Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS
| 300 |
10:00 |
|
Pt. 2 - More Samples and How to Get the Sample Applications to Compile Using an .snk File
| 300 |
9:00 |
|
Pt. 1 - An Intro to the DELETE Statement
| 200 |
16:00 |
|
Pt. 2 - How Transactions and Locks Work With the DELETE Statement
| 300 |
12:00 |
|
Pt. 4 - How to Use the FROM Clause in the DELETE Statement
| 400 |
10:00 |
|
Pt. 1 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements
| 300 |
9:00 |
Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008
| 300 |
14:00 |
Member of the
LearnItFirst.com Video Training Network
