Learn Advanced T-SQL For SQL Server Administrator

Learn Advanced T-SQL For SQL Server Administrator, available at $59.99, has an average rating of 4.43, with 34 lectures, based on 943 reviews, and has 6037 subscribers.

You will learn about The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more. The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment. This course is ideal for individuals who are Any student who want to learn about advanced SQL commands and want to understand development in a little more detail It is particularly useful for Any student who want to learn about advanced SQL commands and want to understand development in a little more detail.

Enroll now: Learn Advanced T-SQL For SQL Server Administrator

Summary

Title: Learn Advanced T-SQL For SQL Server Administrator

Price: $59.99

Average Rating: 4.43

Number of Lectures: 34

Number of Published Lectures: 34

Number of Curriculum Items: 34

Number of Published Curriculum Objects: 34

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more. The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment.

Who Should Attend

Any student who want to learn about advanced SQL commands and want to understand development in a little more detail

Target Audiences

Any student who want to learn about advanced SQL commands and want to understand development in a little more detail

The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more. The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment. In addition, the student will be given examples of block statements, transactions commands, recursive CTEs, error handling, variables, and much more. This course will greatly help those students that want to understand how to read, modify, and execute from simple to complex stored procedures. By creating stored procedures, the developer has greater control in the execution of SQL commands, permissions, and greater flexibility in updating the sproc.

Course Curriculum

Chapter 1: This course in designed for students who want to learn about stored procedures

Lecture 1: Table of contents

Lecture 2: 1 Download all software needed

Lecture 3: 2 Installing Windows Server OS

Lecture 4: 3 Shared folders

Lecture 5: 3a Installing SQL 2014

Lecture 6: 4 Installing Adventureworks database

Lecture 7: 5 What is a Stored Procedures

Lecture 8: 6 Modifying and deleting a sproc

Lecture 9: 7 Using a single input parameter

Lecture 10: 8 Multiple parameters

Lecture 11: 9 Blocks multiple sql statements

Lecture 12: 10 what is a variable

Lecture 13: 11 Demo of Sproc using update.

Lecture 14: 12 Demo of Sproc Insert, Print, IF Else and Set Nocount on

Lecture 15: 13 Demo of IF Else

Lecture 16: 14 Reading a nested if else statement

Lecture 17: 15 While loop

Lecture 18: 16 Cursors

Lecture 19: 17 Transactions

Lecture 20: 18 Error handling

Lecture 21: 19 Table variables

Lecture 22: 20 Derived tables

Lecture 23: 21 Views

Lecture 24: 22 Excel formula

Lecture 25: 23 Intro to CTE

Lecture 26: 24 Multiple CTEs

Lecture 27: 25 Aggregate cte

Lecture 28: 26 Insert delete Update CTE

Lecture 29: 27 CTE and sproc

Lecture 30: 28 Recursive CTE

Lecture 31: 29 vlookup

Lecture 32: 30 reviewing sprocs

Lecture 33: 31 Stored Procedure permissions

Lecture 34: 32 What is Power BI

Instructors

Raphael Asghar
Production SQL Database Administrator

Rating Distribution

1 stars: 15 votes
2 stars: 18 votes
3 stars: 108 votes
4 stars: 388 votes
5 stars: 414 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!

Menu