Have a question?
Message sent Close
3.6
67 reviews

Advanced Transact-SQL (T-SQL) : Stored Procedures |Functions

Practical Hands-on Advanced Transact-SQL (T-SQL)Queries .
  • Description
  • Curriculum
  • FAQ
  • Reviews

Transact-SQL is also popularly refereed to as T-Sequel .This is Microsoft’s own implementation of the international Structural Query Language (SQL).
This course assumes you have some basic knowledge of SQL or T-SQL and will provide you with more advanced knowledge of Transact-SQL (T-SQL). I will be using the latest free version of Microsoft SQL Server 2017 Express edition and a sample adventureworks 2014 database. We will be installing and using SQL Server Management Studio as part of the SQL Server Express edition 2017

The course focuses on writing and advanced queries  that can be used with T-SQL
in SQL Server 2012, 2014 and 2016 and 2017. 
In this course you will learn the details and capabilities of using various types of functions
 like aggregate,analytic and ranking . You will also learn 
about stored procdures and how to create ,modify and delete them. I will also be showing you how to use SET operators.

What You Will Learn in this course includes:

Installing  Microsoft SQL Server Express 2017
Downloading and attaching sample database
Using Convert function
Using Substring function
Using Cast function
Using Round Function
Using Case expression
Aggregate Functions
Analytic functions
SET operators
Stored Procedure
Ranking functions

How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.6
67 reviews
Stars 5
20
Stars 4
16
Stars 3
15
Stars 2
8
Stars 1
8
8467
Course available for 2 days
Course details
Video 3 hours
Certificate of Completion
Full lifetime access
Access on mobile and TV

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW