Create and deliver your own elearning using eduslide.net

Browse thousands of lessons. Create your own and share the knowledge.

Sign up for a free eduslide account !
Create your own courses.
Access thousands of lessons.

Microsoft Transact SQL

Virtual Training CompanyÕs Transact SQL tutorial is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification, particularly Exam #70-229. It will also help you become a better Database Administrator. Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures. He even touches on XML. To get started, simply click on one of the movie links below.

Author: Vtc

Course Intro

Welcome/Intro

What Is Transact SQL?

A Few Words About TSQL

History of Databases

History of SQL

What Flavor Would You Like?

SQL Terminology/Acronyms

Course Overview

Course Overview & Description

General Database Information

What Is A Database?

Two Main Types of Databases

Normalization

Denormalization

Database Relationships

Database Design Concerns

Language Basics

SQL Statement Types

Transact SQL Elements

Data Types Overview

SQL 2000 Data Types

Wildcards & Escape Characters

Logic Flow

Scripts

Batches

Transactions

Functions

Stored Procedures

Views

Triggers

Debugging

Transact SQL Tools

Query Analyzer Pt. 1

Query Analyzer Pt. 2

Enterprise Manager

QA vs. EM

ISQL / OSQL

ISQL / OSQL Examples

Notepad

Third Party Apps

More Than A Query Language

Creating Databases

A Word About NULLS

Creating Tables

Creating Constraints

Creating Defaults

Creating Relationships

SELECT

Basic SELECT

Column Aliasing

SELECT INTO Clause

SELECT FROM Clause

Using JOINS

JOIN Examples

Table Aliasing

SELECT WHERE Clause

Looking For NULLS

SELECT GROUP BY Clause

SELECT HAVING Clause

SELECT ORDER BY Clause

SELECT COMPUTE Clause

UNION

INSERT

Basic INSERT Syntax

Using INSERT

Advanced INSERT

UPDATE

Basic UPDATE Syntax

Using UPDATE

Advanced UPDATE

DELETE

Basic DELETE Syntax

Using DELETE

DELETE or TRUNCATE TABLE?

Indexes

What Is An Index?

Types Of Indexes

Determining Indexes(Guidelines)

Creating Indexes

Views

What Is A View?

Creating Views

Advantages of Views

System Tables

Overview of System Tables

Querying System Tables

Variables

Overview Of Variables

Declaring Variables

Using Variables

Variables As Object Names

System Variables

Stored Procedures

What Is A Stored Procedure?

Creating A Stored Procedure

Using Input Variables

Using Output Variables

Extended Stored Procedures

Cursors

What Are Cursors?

Functions

What Are Functions?

Partial List Of Functions

User Defined Functions

Scalar UDF

Multi-Statement UDF

InLine UDF

Triggers

What Are Triggers?

Creating A Trigger

How Triggers Work

Nesting & Recursive Triggers

XML

What Is XML?

FOR XML

Misc XML Info

Optimizing Your TSQL

Limiting Results

Utilizing Indexes

Graphical Exec Plan/Profiler

Course options

Search

Channels

 

Tags

Activity

 No Entry Found