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

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