Capturing Logic with Stored Procedures in T-SQL

Focused View

Jared Westover

3:06:38

26 View

01 - Course Overview

01 - Course Overview.mp4

01:49

02 - Exploring the Benefits of Stored Procedures

02 - Introduction.mp4

02:59

03 - What Is a Stored Procedure.mp4

02:43

04 - Comparing Data Fetching Options.mp4

05:38

05 - Primary Stored Procedure Benefits.mp4

02:39

06 - Demo - Creating Test Environment.mp4

05:50

07 - Demo - Minimizing Modifications.mp4

03:03

08 - Exploring Security Benefits.mp4

02:32

09 - Demo - Limiting User Access.mp4

02:59

10 - Exploring Performance Gains.mp4

02:30

11 - Demo - Execution Plan Reuse.mp4

04:58

12 - Disadvantages of Stored Procedures.mp4

02:54

13 - Summary.mp4

01:43

03 - Creating Our First Stored Procedure

14 - Introduction.mp4

02:46

15 - Creating Our Stored Procedure.mp4

02:05

16 - Exploring New Syntax and Executing.mp4

03:17

17 - Naming Stored Procedures.mp4

02:45

18 - Demo - Creating and Executing.mp4

06:04

19 - Demo - Scripting Stored Procedures.mp4

05:01

20 - Exploring Parameters.mp4

02:36

21 - Demo - Adding Parameters.mp4

06:07

22 - Exploring Debugger.mp4

02:06

23 - Demo - Debugging Code.mp4

05:09

24 - Reviewing Best Practices.mp4

03:05

25 - Summary.mp4

02:01

04 - Setting up Queries in Stored Procedures

26 - Introduction.mp4

03:21

27 - Building Queries in Stored Procedures.mp4

01:56

28 - Reviewing Temporary Objects.mp4

03:15

29 - Creating Temporary Objects.mp4

02:33

30 - Demo - Adding Queries to Stored Procedures.mp4

07:06

31 - Demo - Using Temporary Objects.mp4

07:57

32 - Exploring Table Valued Parameters.mp4

03:40

33 - Demo - Table Valued Parameters.mp4

03:25

34 - Examining Sp executesql.mp4

03:13

35 - Demo - Using Sp executesql.mp4

05:23

36 - Implementing a Debug Flag.mp4

02:13

37 - Demo - Adding a Debug Flag.mp4

03:15

38 - Summary.mp4

01:54

05 - Optimizing Stored Procedure Performance

39 - Introduction.mp4

03:36

40 - Creating a Baseline.mp4

02:51

41 - Demo - Gathering Baseline Stats.mp4

07:17

42 - Busting Performance Myths.mp4

02:49

43 - Demo - Temp Table Myth.mp4

04:18

44 - Demo - Select 1 Versus Select .mp4

04:09

45 - Exploring Parameter Sniffing.mp4

02:34

46 - Demo - Parameter Sniffing.mp4

07:36

47 - Summary.mp4

01:51

06 - Building Stored Procedures in the Real World

48 - Introduction.mp4

02:09

49 - Defining Stored Procedure Templates.mp4

02:19

50 - Demo - Creating Templates.mp4

05:36

51 - Exploring Key Takeaways.mp4

03:04

52 - Continuing the Journey.mp4

01:59

Description

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 all the in and outs of designing and optimizing stored procedures.

What You'll Learn?

Perhaps you’re starting out or have been working with stored procedures for years. Maybe you want to take your understanding of store 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. Along the way, learning why using temporary objects might reduce complexity. Next, you will discover methods for adding queries to your stored procedures. Finally, you will explore several methods 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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Jared Westover

Instructor's Courses

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 with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data gives Jared a chance to combine his passions for technology and creativity. Tracking data, whether steps taken or money spent, has become an obsession. He loves spending time with his wonderful wife Amanda and three children in his spare time. Jared enjoys lifting weights, along with a good Netflix binge.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.