Explore

A beginners guide to T-SQL ( Transact-SQL)

5 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Learn Microsoft's own version of the standard SQL language

Description

T-SQL (Transact-SQL) also referred to as T-sequel is Microsoft's implementation of the SQL standard language.
This course is intended for users who are new to writing SQL statements for SQL Server database and
will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures.
Transact-SQL is an essential skill for data professionals and developers working with SQL databases

T -SQL requires an SQL Server database i will walk you through downloading and installing SQL Server Express 2014 and also downloading and installing a sample database.

You will be introduced to SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.

Target Audience:

• Novice SQL developers
• Novice Database administrators
• Aspiring data analyst
• Aspiring data warehouse professionals
• IT Professionals who want to learn T-SQL

What you'll learn how to:

   • Create Transact-SQL SELECT queries
   • Work with data types and NULL
   • Query multiple tables with JOIN
   • Use Aggregate data
   • Use table expressions
   • Group sets and pivot data
   • Modify data
   • Filter rows of data
   • Use basic equality filters
   • Use logical and comparison filters
   • Use stored procedures
   • Aliases
   • Case expressions

After completing this course you should be confident to write your T-SQL statements and run them against SQL Server Database.

Looking forward to you joining the course :-)

Requirements

Basic computer knowledge
Desire to learn

Outline

Database Download and Install
Introduction
What is T-SQL
Hardware and Software Requirements for SQL Server Express 2014
Download SQL Server Express2014
Install SQL Server Express 2014
Download sample database
Install Sample Database

Useful T-SQL Commands
TOP
USE
GO
DISTINCT and TOP
Using T-SQL Comments

Retrieving and Sorting Data with T-SQL
Using SELECT Statements
Aliases
Using ORDER BY clause
Sort by ascending order
Sort by multiple columns
Case Expressions
Using Stored Procedures

How to query multiple tables with T-SQL
Introduction to Table Joins
Why are table joins relevant
INNER Table Join
Left Outer Table Join
Right Outer Table Join
Conclusion

Filtering Rows of data with T-SQL
Introduction
Using basic equality filters
Using basic comparison
Using logical comparisons
Using String Comparison
Using Null Comparison
Summary

Using T-SQL to modify data
Introduction
Add new records to a database
Update existing data in the database
Delete data from a database
Summary

How to use T-SQL with Aggregate functions
Introduction
COUNT Function
AVG Function
MAX Function
MIN Function
SUM function
Grouping Data
Summary

Recommended for you