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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024