3.9  8 reviews on Udemy

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

Learn Microsoft's own version of the standard SQL language
Course from Udemy
 179 students enrolled
 en
create queries using Transact-SQL
Select, filter and sort data from multiple tables
Use T-SQL Commands
Modify data
Use aggregate functions
Use Aliases with T-SQL
Use case expressions

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 :-)



A beginners guide to T-SQL ( Transact-SQL)
$ 94.99
per course
Also check at

FAQs About "A beginners guide to T-SQL ( Transact-SQL)"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK