Advanced Transact-SQL (T-SQL) : Stored Procedures |Functions
- 4.3
-
![]()
![]()
![]()
![]()
Brief Introduction
Practical Hands-on Advanced Transact-SQL (T-SQL)Queries .Description
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
Requirements
- Requirements
- You should have a basic knowledge of SQL
- You should have a basic knowledge of Transact-SQL (T-SQL)
- Basic working knowledge of SQL Server Management Studio
Bluelime Learning Solutions
4.3 Raiting
Learn MS SQL Server 2017 With Db Design Techniques
- 4.8
-
![]()
![]()
![]()
![]()
![]()
With real time data base designing techniques, SQL, Joins, SPs, Functions, Views, Transactions, Triggers and lot more. . . e. Topics Covered are :...
T-SQL Training with Real World Scenarios:Tricks of the Trade
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Transact SQL Query Programming & Developer Advanced Microsoft SQL Server Online Video Training Course by Vikas Munjal Real Life situations are as follow...
T-SQL For Beginners: Learn to Query SQL Server Databases
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn how to use Microsoft's version of SQL to Query Microsoft SQL Server Databases Welcome everyone to the T-SQL course. T-SQL is also popularly referefered to as T-Sequel ....
Advanced Transact-SQL (T-SQL) : Stored Procedures |Functions
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Practical Hands-on Advanced Transact-SQL (T-SQL)Queries . Transact-SQL is also popularly refereed to as T-Sequel . This is Microsoft's own implementation of the international Structural Query Language (SQL)....
