We may earn an affiliate commission when you visit our partners.
Course image
Raphael Asghar

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.

Enroll now

What's inside

Learning objective

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.

Syllabus

At the end of the course, the student will have a greater understanding of what the ‘blocks’ of stored procedures consist of and how they benefit the developer
Read more
Table of contents
1 Download all software needed
2 Installing Windows Server OS
3 Shared folders
3a Installing SQL 2014
4 Installing Adventureworks database
5 What is a Stored Procedures
6 Modifying and deleting a sproc
7 Using a single input parameter
8 Multiple parameters
9 Blocks multiple sql statements
10 what is a variable
11 Demo of Sproc using update.
12 Demo of Sproc Insert, Print, IF Else and Set Nocount on
13 Demo of IF Else
14 Reading a nested if else statement
15 While loop
16 Cursors
17 Transactions
18 Error handling
19 Table variables
20 Derived tables
21 Views
22 Excel formula
23 Intro to CTE
24 Multiple CTEs
25 Aggregate cte
26 Insert delete Update CTE
27 CTE and sproc
28 Recursive CTE
29 vlookup
30 reviewing sprocs
31 Stored Procedure permissions
32 What is Power BI

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Offers a comprehensive investigation of stored procedures
Taught by Raphael Asghar, a recognized expert in stored procedures
Relevant for SQL developers seeking to understand and utilize stored procedures
Covers a variety of advanced stored procedures concepts, including cursors, derived tables, and CTEs
Provides hands-on practice with stored procedures through examples and exercises
Students will need prior knowledge of SQL and database concepts to fully benefit from this course

Save this course

Save Learn Advanced T-SQL For SQL Server Administrator to your list so you can find it easily later:
Save

Reviews summary

Adequate advanced t-sql course

According to students, this advanced T-SQL course is passable in spite of it having superficial depth.
Course is not very deep.
"not too deep"

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Learn Advanced T-SQL For SQL Server Administrator with these activities:
Compile and review course materials
Organize all course materials, including notes, assignments, quizzes, and exams, in one place for easy access and review.
Show steps
  • Gather all course materials from various sources
  • Create a system to organize and store the materials logically
  • Review the materials regularly to reinforce your understanding
Join a study group or online forum
Connect with other learners to discuss stored procedures, share knowledge, and collaborate on projects.
Show steps
  • Search for study groups or online forums dedicated to stored procedures
  • Join the group and actively participate in discussions
  • Ask questions, share your knowledge, and collaborate with others
Show all two activities

Career center

Learners who complete Learn Advanced T-SQL For SQL Server Administrator will develop knowledge and skills that may be useful to these careers:
Database Administrator
Database Administrators (DBAs) are responsible for the day-to-day operation and maintenance of database systems. They ensure that databases are running smoothly and efficiently, and they troubleshoot and resolve any problems that arise. This course can help you develop the skills you need to become a DBA, including how to create and manage stored procedures, cursors, and other database objects.
Data Architect
Data Architects design and build the architecture for data management systems. They work with business stakeholders to understand their data needs and then design and implement solutions to meet those needs. This course can help you build a foundation in T-SQL, which is a powerful language for working with data in SQL Server. By understanding T-SQL, you can develop more efficient and effective data management solutions.
Data Analyst
Data Analysts collect, analyze, and interpret data to help businesses make informed decisions. They use a variety of tools and techniques to extract insights from data, and they often work with DBAs to access and manage data. This course can help you develop the skills you need to become a Data Analyst, including how to use T-SQL to query and analyze data.
Business Intelligence Analyst
Business Intelligence Analysts (BIAs) help businesses understand their data and use it to make better decisions. They work with Data Analysts to collect and analyze data, and they then develop reports and visualizations to communicate their findings to business stakeholders. This course can help you develop the skills you need to become a BIA, including how to use T-SQL to query and analyze data.
Software Engineer
Software Engineers design, develop, and maintain software applications. They work with a variety of programming languages and tools to create software that meets the needs of businesses and users. This course can help you develop the skills you need to become a Software Engineer, including how to use T-SQL to access and manage data.
Web Developer
Web Developers design and develop websites and web applications. They work with a variety of programming languages and tools to create websites that are both functional and visually appealing. This course can help you develop the skills you need to become a Web Developer, including how to use T-SQL to access and manage data.
Data Scientist
Data Scientists use data to solve business problems. They work with a variety of tools and techniques to extract insights from data, and they often develop machine learning models to automate decision-making. This course can help you develop the skills you need to become a Data Scientist, including how to use T-SQL to query and analyze data.
Machine Learning Engineer
Machine Learning Engineers develop and deploy machine learning models. They work with a variety of programming languages and tools to create models that can learn from data and make predictions. This course can help you develop the skills you need to become a Machine Learning Engineer, including how to use T-SQL to access and manage data.
Data Engineer
Data Engineers design and build data pipelines. They work with a variety of tools and technologies to move data between different systems and to prepare data for analysis. This course can help you develop the skills you need to become a Data Engineer, including how to use T-SQL to access and manage data.
Database Designer
Database Designers design and develop the structure of databases. They work with business stakeholders to understand their data needs and then design and implement databases that meet those needs. This course can help you develop the skills you need to become a Database Designer, including how to use T-SQL to create and manage database objects.
Information Security Analyst
Information Security Analysts protect computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. They work with a variety of tools and techniques to identify and mitigate security risks. This course can help you develop the skills you need to become an Information Security Analyst, including how to use T-SQL to query and analyze data.
IT Auditor
IT Auditors evaluate the security and efficiency of computer systems and networks. They work with a variety of tools and techniques to identify and mitigate risks. This course can help you develop the skills you need to become an IT Auditor, including how to use T-SQL to query and analyze data.
Project Manager
Project Managers plan and execute projects. They work with a variety of stakeholders to ensure that projects are completed on time, within budget, and to the required quality standards. This course may be useful for Project Managers who need to understand how to use T-SQL to access and manage data.
Business Analyst
Business Analysts work with businesses to identify and solve business problems. They use a variety of tools and techniques to gather and analyze data, and they then develop recommendations for how to improve business processes. This course may be useful for Business Analysts who need to understand how to use T-SQL to access and manage data.
Technical Writer
Technical Writers create documentation for software and hardware products. They work with engineers and other technical experts to gather information about products and then write clear and concise documentation for users. This course may be useful for Technical Writers who need to understand how to use T-SQL to access and manage data.

Reading list

We've selected eight books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Learn Advanced T-SQL For SQL Server Administrator.
This practical guide provides quick solutions to common T-SQL coding problems and also provides an extensive background and detailed explanations of the code to give you a deeper understanding of T-SQL programming and how it can be applied to your projects.
Comprehensive guide to data warehousing with SQL Server. It covers all aspects of data warehousing, from design and implementation to maintenance and optimization.
Provides a comprehensive overview of Power BI and SQL Server. It covers all aspects of using Power BI with SQL Server, from data integration and modeling to reporting and visualization.
Practical guide to performance tuning in SQL Server. It covers a wide range of topics, from basic indexing strategies to advanced query optimization techniques.
Comprehensive guide to troubleshooting SQL Server problems. It covers a wide range of topics, from basic error messages to complex performance issues.
Provides a comprehensive overview of the internal workings of SQL Server and offers practical guidance for troubleshooting and optimizing database performance.
Provides a comprehensive overview of SQL Server Database Administration using Microsoft SQL Server Management Studio (SSMS). It covers all aspects of database administration, including installation, configuration, maintenance, and security.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Learn Advanced T-SQL For SQL Server Administrator.
Intermediate PostgreSQL
Most relevant
Learn SQL Queries
Most relevant
Optimizing SQL Server Procedures: Best Practices and...
Most relevant
SQL Server Performance Tuning Part 2
Most relevant
SQL Concepts for Data Engineers
Most relevant
Using SQL for Data Analysis
Most relevant
Capturing Logic with Stored Procedures in T-SQL
Most relevant
Introduction to SQL and relational databases
Most relevant
Programming SQL Server Database Stored Procedures
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser