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

Advanced Transact-SQL (T-SQL) : Stored Procedures |Functions, available at $39.99, has an average rating of 3.15, with 48 lectures, based on 133 reviews, and has 10701 subscribers.

You will learn about Understand and write Aggregate Functions Understand and write Analytic Functions Understand and write SET Operators Understand and use Stored Procedures Understand and write RANK Functions Understand and use Convert Function Understand and use Substring Function Understand and use Case expressions Use Transact-SQL Comments This course is ideal for individuals who are Anyone with basic knowledge of SQL or Anyone with basic knowledge of Transact- SQL (T-SQL) It is particularly useful for Anyone with basic knowledge of SQL or Anyone with basic knowledge of Transact- SQL (T-SQL).

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

Summary

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

Price: $39.99

Average Rating: 3.15

Number of Lectures: 48

Number of Published Lectures: 48

Number of Curriculum Items: 48

Number of Published Curriculum Objects: 48

Original Price: $94.99

Quality Status: approved

Status: Live

What You Will Learn

Understand and write Aggregate Functions

Understand and write Analytic Functions

Understand and write SET Operators

Understand and use Stored Procedures

Understand and write RANK Functions

Understand and use Convert Function

Understand and use Substring Function

Understand and use Case expressions

Use Transact-SQL Comments

Who Should Attend

Anyone with basic knowledge of SQL

Anyone with basic knowledge of Transact- SQL (T-SQL)

Target Audiences

Anyone with basic knowledge of SQL

Anyone with basic knowledge of Transact- SQL (T-SQL)

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

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Introduction

Lecture 2: SQL Server Express Installation

Lecture 3: Download Sample Database

Lecture 4: Attaching Sample Database to SQL Server

Lecture 5: SQL Server Utilities Statements

Lecture 6: Using Transact-SQL Comments

Chapter 2: Miscellaneous Functions ( Transact-SQL )

Lecture 1: CAST Function

Lecture 2: CONVERT Function

Lecture 3: ROUND Function

Lecture 4: SUBSTRING Function

Lecture 5: CASE Expression

Chapter 3: Transact-SQL (T-SQL) Aggregate Functions

Lecture 1: Introduction to Aggregate Functions

Lecture 2: AVG Aggregate Functions

Lecture 3: MIN Aggregate Functions

Lecture 4: MAX Aggregate Functions

Lecture 5: SUM Aggregate Functions

Lecture 6: COUNT Aggregate Function

Lecture 7: GROUPING Aggregate Function

Lecture 8: VAR Aggregate Functions

Lecture 9: VARP Aggregate Functions

Chapter 4: Ranking Functions (Transact-SQL)

Lecture 1: Introduction to Ranking Functions

Lecture 2: Rank Functions

Lecture 3: NTILE Functions

Lecture 4: DENSE_RANK Functions

Lecture 5: ROW_NUMBER Functions

Lecture 6: Using Multiple Ranking Functions

Chapter 5: Analytic Functions (Transact-SQL)

Lecture 1: Introduction to Analytic Functions

Lecture 2: Basic Analytic Function Syntax

Lecture 3: LEAD Function

Lecture 4: LAG Function

Lecture 5: LAST_VALUE Function

Lecture 6: FIRST_VALUE Function

Lecture 7: PERCENT_RANK Function

Lecture 8: CUME_DIST Function

Lecture 9: PERCENTILE_DISC Function

Lecture 10: PERCENTILE_CONT Function

Chapter 6: SET OPERATORS ( Transact-SQL)

Lecture 1: Introduction To SET Operators

Lecture 2: EXCEPT SET Operators

Lecture 3: INTERSECT SET Operators

Lecture 4: UNION SET Operators

Chapter 7: Stored Procedures (Transact-SQL)

Lecture 1: Introduction To Stored Procedures

Lecture 2: Creating Stored Procedures

Lecture 3: Modifying Stored Procedures

Lecture 4: Properties page of a stored procedure

Lecture 5: Viewing dependencies of a stored procedure

Lecture 6: Deleting a stored procedure

Lecture 7: Viewing the definition of a stored procedure

Lecture 8: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 15 votes

2 stars: 12 votes

3 stars: 28 votes

4 stars: 36 votes

5 stars: 42 votes

Frequently Asked Questions

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!