We may earn an affiliate commission when you visit our partners.
Learn Advanced T-SQL For SQL Server Administrator
Raphael Asghar
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/0zzwpw/learn
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.
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
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
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
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
Show steps
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
Show steps
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
Compile and review course materials
Show steps
Organize all course materials, including notes, assignments, quizzes, and exams, in one place for easy access and review.
Show steps
Show steps
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
Show steps
Connect with other learners to discuss stored procedures, share knowledge, and collaborate on projects.
Show steps
Show steps
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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.
For more career information including salaries, visit:
OpenCourser.com/course/0zzwpw/learn
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.
Save
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.
Save
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.
Save
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.
Is an excellent introduction to SQL Server administration. It covers the basics of installation, configuration, and management and is suitable for beginners with little to no prior experience.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/0zzwpw/learn
Share
Similar courses
Here are nine courses similar to
Learn Advanced T-SQL For SQL Server Administrator.
Intermediate PostgreSQL
OpenCourser.com/course/8m45yz/intermediate
Intermediate PostgreSQL
Most relevant
Learn SQL Queries
OpenCourser.com/course/ae5ru7/learn
Learn SQL Queries
Most relevant
Optimizing SQL Server Procedures: Best Practices and Performance
OpenCourser.com/course/mwwoml/optimizing
Optimizing SQL Server Procedures: Best Practices and...
Most relevant
SQL Server Performance Tuning Part 2
OpenCourser.com/course/t69968/sql
SQL Server Performance Tuning Part 2
Most relevant
SQL Concepts for Data Engineers
OpenCourser.com/course/hevrye/sql
SQL Concepts for Data Engineers
Most relevant
Using SQL for Data Analysis
OpenCourser.com/course/yoya18/using
Using SQL for Data Analysis
Most relevant
Capturing Logic with Stored Procedures in T-SQL
OpenCourser.com/course/po7fli/capturing
Capturing Logic with Stored Procedures in T-SQL
Most relevant
Introduction to SQL and relational databases
OpenCourser.com/course/2olnrz/introduction
Introduction to SQL and relational databases
Most relevant
Introduction to SQL
OpenCourser.com/course/i0o5ad/introduction
Introduction to SQL
Most relevant
Effort
5.5 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Good to know
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
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