Movies - Other
VTC MSFT Transact SQL[
Torrent info
Torrent Files List
Torrent description
Course Intro
Welcome/Intro (03:04
What Is Transact SQL? (06:34
A Few Words About TSQL (05:26
History of Databases (05:38
History of SQL (05:06
What Flavor Would You Like? (02:56
SQL Terminology/Acronyms (04:54
Course Overview
Course Overview & Description (05:42
General Database Information
What Is A Database? (05:08
Two Main Types of Databases (05:00
Normalization (06:34
Denormalization (04:06
Database Relationships (04:45
Database Design Concerns (04:29
Language Basics
SQL Statement Types (03:18
Transact SQL Elements (05:08
Data Types Overview (04:10
SQL 2000 Data Types (07:17
Wildcards & Escape Characters (05:11
Logic Flow (05:43
Scripts (04:43
Batches (05:26
Transactions (05:07
Functions (04:28
Stored Procedures (04:51
Views (03:24
Triggers (03:57
Debugging (03:19
Transact SQL Tools
Query Analyzer Pt. 1 (05:15
Query Analyzer Pt. 2 (04:54
Enterprise Manager (05:20
QA vs. EM (05:45
ISQL / OSQL (03:19
ISQL / OSQL Examples (06:09
Notepad (02:40
Third Party Apps (02:21
More Than A Query Language
Creating Databases (06:15
A Word About NULLS (04:16
Creating Tables (04:01
Creating Constraints (05:40
Creating Defaults (04:25
Creating Relationships (04:12
SELECT
Basic SELECT (04:12
Column Aliasing (04:52
SELECT INTO Clause (04:11
SELECT FROM Clause (01:55
Using JOINS (05:45
JOIN Examples (06:32
Table Aliasing (03:46
SELECT WHERE Clause (04:10
Looking For NULLS (04:42
SELECT GROUP BY Clause (05:10
SELECT HAVING Clause (02:59
SELECT ORDER BY Clause (03:59
SELECT COMPUTE Clause (04:00
UNION (04:03
INSERT
Basic INSERT Syntax (05:24
Using INSERT (04:59
Advanced INSERT (03:26
UPDATE
Basic UPDATE Syntax (02:02
Using UPDATE (03:18
Advanced UPDATE (03:21
DELETE
Basic DELETE Syntax (01:51
Using DELETE (03:29
DELETE or TRUNCATE TABLE? (02:54
Indexes
What Is An Index? (05:57
Types Of Indexes (03:00
Determining Indexes(Guidelines (03:20
Creating Indexes (05:37
Views
What Is A View? (02:31
Creating Views (04:54
Advantages of Views (02:31
System Tables
Overview of System Tables (04:21
Querying System Tables (05:28
Variables
Overview Of Variables (02:57
Declaring Variables (03:54
Using Variables (06:12
Variables As Object Names (04:04
System Variables (03:17
Stored Procedures
What Is A Stored Procedure? (04:03
Creating A Stored Procedure (05:08
Using Input Variables (04:56
Using Output Variables (04:21
Extended Stored Procedures (04:47
Cursors
What Are Cursors? (04:13
Functions
What Are Functions? (02:31
Partial List Of Functions (02:29
User Defined Functions (01:24
Scalar UDF (04:08
Multi-Statement UDF (04:12
InLine UDF (02:31
Triggers
What Are Triggers? (03:46
Creating A Trigger (03:10
How Triggers Work (03:43
Nesting & Recursive Triggers (03:04
XML
What Is XML? (03:00
FOR XML (05:31
Misc XML Info (02:23
Optimizing Your TSQL
Limiting Results (02:30
Utilizing Indexes (02:28
Graphical Exec Plan/Profiler (05:06