SQL Server 2014, Part 7 of 9: Introduction to T-SQL

This course will start with a quick overview of the history of SQL, then dive right into using T-SQL. You’ll learn about batches and scripts, how to declare and use variables—including the inevitable data type conversions—as well as the rich supply of operators available. Next you’ll learn about some of the many built-in T-SQL functions, for doing things like working with numbers, string manipulation, as well as global functions for getting state information. You’ll also learn about how to rank results using special functions and the OVER clause.

Lesson 1:

• Overview of Transact-SQL
• Batches and Scripts
• Demo: DDL Statements
• Demo: Variables.

Lesson 2:

• Operators Overview
• Demo: Compound Operators
• Demo: Data Conversions
• Type Coercion and Precedence
• Demo: Coercion and Precedence
• Demo: Convert with Style
• Demo: Enhanced Convert Options
• Implicit Conversions
• Demo: Convert and Format.

Lesson 3:

• Using Built-In Functions
• Working With Nulls
• Demo: Working With Nulls
• Demo: IsNull Function
• Demo: Null If function
• Demo: Coalesce Function
• Demo: IsNumeric Function
• Demo: Rand Function
• Demo: Round Function
• Demo: Rand and Round.

Lesson 4:

• Demo: REPLACE
• Demo: STUFF
• Demo: LEN, LEFT and RIGHT
• Demo: SUBSTRING
• Demo: CHARINDEX
• Demo: PATINDEX
• Demo: SPACE
• Demo: CHAR and ASCII
• Demo: LOWER and UPPER
• Demo: LTRIM and RTRIM.

Lesson 5:

• Demo: GETDATE
• Demo: DATEPART
• Demo: DATENAME
• Demo: DATEADD
• Demo: DATEDIFF
• Demo: Global Variables
• Demo: ROWCOUNT
• Demo: IDENTITY and TRANCOUNT
• Demo: ERROR.

Lesson 6:

• Demo: IF Statement
• Demo: BEGIN and END Block
• Demo: GOTO
• Demo: RETURN
• Demo: CASE
• Demo: CASE Second Syntax
• Demo: WHILE
• Demo: WAITFOR.

Lesson 7:

• Ranking Results
• Demo: Ranking Results
• Demo: Ranking Examples.