Capturing Logic with Stored Procedures in T-SQL from Pluralsight

Do you have experience writing T-SQL but want to start creating stored procedures? Well, this course is for you! Take your skills to the next level by learning the ins and outs of designing and optimizing stored procedures.

Perhaps you’re starting or have been working with stored procedures for years. Maybe you want to take your understanding of stored procedures in SQL Server to the next level. In this course, Capturing Logic with Stored Procedures in T-SQL, you will learn foundational knowledge for developing powerful stored procedures. First, you will learn why utilizing stored procedures in SQL Server is paramount to executing maintainable code, and why using temporary objects might reduce complexity. Next, you will discover methods for adding queries to your stored procedures. Finally, you will explore several techniques to optimize the performance of your stored procedures. When you’re finished with this course, you will have the skills and knowledge necessary to consistently deliver optimal stored procedures in SQL Server.

What's inside

Syllabus

Course Overview

Exploring the Benefits of Stored Procedures

Creating Your First Stored Procedure

Setting up Queries in Stored Procedures

Optimizing Stored Procedure Performance

Building Stored Procedures in the Real World

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops a foundational understanding of stored procedures, which is indispensable for a robust SQL developer's portfolio

Taught by Jared Westover, who is widely recognized for their contributions to the field of database management

Provides a step-by-step approach to stored procedures, making it accessible to learners with varying levels of experience

Offers guidance on optimizing stored procedure performance, thereby promoting efficiency in database operations

Requires learners to have some prior experience with T-SQL, as it builds upon these foundational skills

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 Capturing Logic with Stored Procedures in T-SQL with these activities:

Read 'SQL Server Stored Procedures' by Kalen Delaney

Show steps

Strengthen your understanding of stored procedures through a comprehensive book that covers design patterns, troubleshooting, and more.

View Microsoft SQL Server 2008 Internals (Pro -... on Amazon

Show steps

Attend a study group or discussion forum on stored procedures

Show steps

Engage with peers to share knowledge, ask questions, and discuss stored procedures, fostering deeper understanding.

Show steps

Join a study group or discussion forum focused on stored procedures.
Participate in discussions, asking questions and sharing insights.
Contribute to the group by sharing your own experiences and learnings.

Watch a YouTube playlist on stored procedure troubleshooting

Show steps

Equip yourself with practical troubleshooting techniques to resolve common stored procedure issues effectively.

Show steps

Find a YouTube playlist that covers stored procedure troubleshooting.
Watch the videos and take notes on the troubleshooting approaches.
Apply the learned techniques to troubleshoot any stored procedure issues you may encounter.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Write 10 T-SQL stored procedures

Show steps

Practice writing stored procedures to improve your understanding of their structure and functionality.

Show steps

Identify a business scenario that requires a stored procedure.
Design the stored procedure's parameters and logic.
Implement the stored procedure in T-SQL.
Test the stored procedure to ensure it behaves as expected.

Complete an online course on stored procedure performance tuning

Show steps

Enhance your understanding of stored procedure optimization techniques to improve the performance of your code.

Show steps

Enroll in an online course on stored procedure performance tuning.
Complete the course modules and assignments.
Apply the learned techniques to your own stored procedures.

Create 10 test cases for your stored procedures

Show steps

Ensure the reliability of your stored procedures by writing comprehensive test cases that cover various scenarios.

Show steps

Identify different scenarios that your stored procedures should handle.
Write test scripts that simulate those scenarios.
Execute the test scripts and verify the expected results.

Create a blog post on stored procedure best practices

Show steps

Research and share best practices for designing, coding, and testing stored procedures to reinforce your knowledge and help others.

Show steps

Research different stored procedure best practices.
Write a blog post outlining the best practices, including examples.
Publish the blog post and share it with the community.

Use stored procedures instead of ad-hoc queries in 5 real-world projects

Show steps

Gain practical experience by implementing stored procedures in real-world projects, enhancing code maintainability and performance.

Show steps

Identify projects where ad-hoc queries are currently being used.
Design and implement stored procedures to replace the ad-hoc queries.
Refactor the code to use the stored procedures.

Career center

Learners who complete Capturing Logic with Stored Procedures in T-SQL will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator combines their knowledge of database management systems and proficiency in T-SQL to design, create, manage, and optimize complex SQL Server databases. This course can help build a foundation for a new DBA, especially in the topics of performance optimization, query techniques, and stored procedures.

See salaries and explore the career path for Database Administrator

Software Engineer

Software Engineers design, develop, deploy, and maintain databases. They will often work on large-scale projects and with complex design structures. A Software Engineer that works with Microsoft SQL Server would benefit from the foundational knowledge this course teaches about developing and optimizing stored procedures.

See salaries and explore the career path for Software Engineer

Database Architect

Database Architects oversee the design, implementation, and maintenance of database management systems. They design database schemas, ensure data integrity, and optimize database performance. This course can help a career-changing DBA make a transition to becoming a Database Architect.

See salaries and explore the career path for Database Architect

Data Analyst

Data Analysts utilize a variety of database management systems, including SQL Server, to collect, transform, and analyze raw data sets to make data-driven decisions. This course may teach techniques that could give a Data Analyst an edge in performance optimization and query handling.

See salaries and explore the career path for Data Analyst

Data Scientist

Data Scientists use machine learning, statistics, and complex data analysis algorithms to model and analyze data. A solid foundation in T-SQL and stored procedure design can provide a career-changing Data Scientist the ability to work with SQL Server at a higher capacity.

See salaries and explore the career path for Data Scientist

Systems Analyst

Systems Analysts study the needs of organizations to determine how computer systems can help a business meet its goals. They design, implement, and manage cost-effective computer systems that meet an organization’s needs. This course can help an experienced Systems Analyst who is new to SQL Server learn the fundamentals of stored procedures.

See salaries and explore the career path for Systems Analyst

Business Intelligence Analyst

Business Intelligence Analysts use data analysis to help businesses make better decisions. They may use SQL to query databases and create reports. This course can provide foundational knowledge of T-SQL and stored procedure design that is used in business intelligence.

See salaries and explore the career path for Business Intelligence Analyst

Software Developer

Software Developers design and develop software applications. They work on both the front end and back end of software systems. This course may introduce a Software Developer who is new to SQL Server and stored procedures the essential knowledge they need for immediate application.

See salaries and explore the career path for Software Developer

Web Developer

Web Developers design and develop websites and web applications. They build the structure and functionality of websites. This course may give a Web Developer who is new to database management a quick way to learn the basics of stored procedure design.

See salaries and explore the career path for Web Developer

Computer Programmer

Computer Programmers write and test code for a variety of software applications. They may work with databases as part of their duties. This course can teach foundational knowledge of T-SQL and stored procedures for a Computer Programmer who is new to the field.

See salaries and explore the career path for Computer Programmer

Information Technology Specialist

Information Technology Specialists maintain and support computer systems and networks. They may also provide technical support to users. This course can give a new IT Specialist a foundation in T-SQL and stored procedure design.

See salaries and explore the career path for Information Technology Specialist

Systems Administrator

Systems Administrators manage and maintain computer systems and networks. They may also provide technical support to users. This course may provide a Systems Administrator who is new to database management foundational knowledge of T-SQL and stored procedures.

See salaries and explore the career path for Systems Administrator

Database Manager

Database Managers are responsible for the planning, implementation, and maintenance of database systems. This course can help a career-changing DBA or Systems Administrator grow their foundational knowledge of T-SQL and stored procedures.

See salaries and explore the career path for Database Manager

Data Engineer

Data Engineers design, implement, and maintain data systems. This course may give a Data Engineer foundational knowledge of T-SQL and stored procedures that they can apply to their work.

See salaries and explore the career path for Data Engineer

Computer Support Specialist

Computer Support Specialists provide technical support to computer users. This may include helping users with software and hardware problems. This course may provide a Computer Support Specialist foundational knowledge of T-SQL and stored procedures that could be applied to their work.

See salaries and explore the career path for Computer Support Specialist