YoVDO

Mastering Stored Procedures in SQL Server

Offered By: Pluralsight

Tags

SQL Courses Data Manipulation Courses Stored Procedures Courses T-SQL Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Working with SQL Server data is something that every data
professional should know. However, crafting efficient and modular
code is one of the key requirements for optimal implementation of data solutions.

At the core of every successful real-life database application is modular and robust code. In this course, Mastering Stored Procedures in SQL Server, you’ll gain the ability to create and implement efficient and scalable stored procedures using T-SQL. First, you’ll explore the basics of stored procedures and their syntax. Next, you’ll discover why it is of key importance to understand execution context and data encapsulation. Finally, you’ll learn how to implement stored procedures to support complex business logic. When you’re finished with this course, you’ll have the skills and knowledge to create stored procedures in SQL Server needed to manipulate the data from SQL Server in the most efficient and modular way.

Syllabus

  • Course Overview 1min
  • Understanding the Basics of Stored Procedures 15mins
  • Implementing Stored Procedures in Real-life Scenarios 13mins

Taught by

Nikola Ilic

Related Courses

Creating Programmatic SQL Database Objects
Microsoft via edX
Developing SQL Databases
Microsoft via edX
Advanced Relational Database and SQL
Coursera Project Network via Coursera
SQL Functions
Coursera Project Network via Coursera
Master C# And SQL By Building Applications
Udemy