Capturing Logic with Stored Procedures in T-SQL

Course Cover
compare button icon

Course Features

icon

Duration

4.47 hours

icon

Delivery Method

Online

icon

Available on

Downloadable Courses

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Effort

4 hours per week

icon

Teaching Type

Self Paced

icon

Video Content

4.47 hours

Course Description

You might be just starting out with stored procedure work or you have worked with them for many years. Perhaps you are looking to improve your knowledge of SQL Server store procedures. This course, Capturing Logic in SQL Server with Stored Procedures, will provide you with the foundational knowledge necessary to create powerful stored procedures. You will first learn why stored procedures in SQL Server are so important for executing maintainable codes. You will also learn why temporary objects can reduce complexity. You will then learn how to add queries to your stored processes. You will also learn how to optimize your stored procedure's performance. This course will equip you with the knowledge and skills to deliver consistent, high-quality stored procedures in SQL Server.

Course Overview

projects-img

International Faculty

projects-img

Case Based Learning

projects-img

Post Course Interactions

projects-img

Case Studies,Instructor-Moderated Discussions

projects-img

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

Exploring the Benefits of Stored Procedures

Creating Our First Stored Procedure

Setting up Queries in Stored Procedures

Optimizing Stored Procedure Performance

Building Stored Procedures in the Real World

Course Instructors

Author Image

Jared Westover

Instructor

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working wit...
Course Cover