T-SQL - Transact-SQL Training Course

forgot my password

Search:

Menu

Home

How it works?

Buy this course

	Discuss! Add a comment
	Add this course to my favorites
	Add a personal note
	RSS Feeds

Course's author:

Ruy Bentes Pimentel Neto

Ruy Bentes Pimentel Neto (ruy.pimentel@gmail.com) is a Senior Database Administrator, Dell Computers Employee, Hold MCDBA, MCSE+I Certifications. Experience of 10 years in Networking, Operational Systems and Database Administration.

Go to author's Space

Course stats:

Favorited:

1 times

Tech Content:

Learning:

Helpful?

Feedbacks:

Features

	Textual content
	Video tutorial
	Exercise
	Source code
	Downloads
	Recommended post

Content

Notes

Discuss

Online course
E-learning-Transact-Sql

In this T-SQL training course you will learn about the Transact-SQL that expands on the SQL standard. The query language that uses Microsoft SQL Server is a variant of the ANSI-standard Structured Query Language, SQL. The SQL Server variant is called Transact-SQL. Database developers and database administrators must have a thorough knowledge of Transact-SQL to read data from and write date to SQL Server databases. Using Transact SQL is the only way to work with the data.

Types of joins

V�deo
1) Types of joins
Description: In this first lesson you will learn about how to, when use and the types of joins used by TSQL in Sql Server. |
[Mark this item as viewed]

CASE expression

V�deo
2) CASE expression
Description: In this second lesson you will learn the importance of determine the amount of columns to return and how to create subqueries. |
[Mark this item as viewed]

PIVOT operators, Full Text Search function and the TABLESAMPLE clause

V�deo
3) PIVOT operators, Full Text Search function and the TABLESAMPLE clause
Description: In this third lesson you will learn about PIVOT operators, Full Text Search function and the TABLESAMPLE clause. |
[Mark this item as viewed]

System Functions

V�deo
4) System Functions
Description: In this fourth lesson we will learn about using system functions. |
[Mark this item as viewed]

User Defined Functions, Column Alias, Temporary Tables and the Select Into Clause

V�deo
5) User Defined Functions, Column Alias, Temporary Tables and the Select Into Clause
Description: In this fifth lesson we will learn about Column Alias, Temporary Tables and the Select Into Clause. |
[Mark this item as viewed]

Use of transactions

V�deo
6) Use of transactions
Description: In this lesson you will learn about the use of transactions. |
[Mark this item as viewed]

TRY and Catch Blocks

V�deo
7) TRY and Catch Blocks
Description: In this lesson you will learn about how to handle errors using TRY and Catch Blocks. |
[Mark this item as viewed]

10 tips about SQL Server that every developer should know

Recommended post
8) 10 tips about SQL Server that every developer should know
Description: 10 tips about SQL Server that every developer should know |
[Mark this item as viewed]

SQL Server 2008

V�deo
9) T-SQL Debugger
Description: In this video we will see how to debug a programable object in SQL Server, such as a stored procedure or a user defined funcion. |
[Mark this item as viewed]