A beginners guide to creating and using CRUD stored proced
4.4 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,027 students enrolled
Wishlisted Wishlist

Please confirm that you want to add A beginners guide to creating and using CRUD stored proced to your Wishlist.

Add to Wishlist

A beginners guide to creating and using CRUD stored proced

Learn to create stored procedures to help you do repetative tasks.
4.4 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,027 students enrolled
Last updated 4/2017
English
Curiosity Sale
Current price: $10 Original price: $125 Discount: 92% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Have a working knowledge of Stored procedures
  • Create Stored procedure for CREATE CRUD operation
  • Create Stored procedure for READ CRUD operation
  • Create Stored procedure for UPDATE CRUD operation
  • Create Stored procedure for DELETE CRUD operation
  • Understand the benefits of stored procedures
View Curriculum
Requirements
  • You should have basic understanding of database concepts
  • You should have basic SQL knowledge
  • You should have a working knowledge of SQL Server Management Studio
Description

One of the useful and handy skills a novice SQL programmer and  SQL Server administrator should have is the ability to write and execute sored procedures.
SQL stored procedures helps a programmer maintain consistent implementation of procedures across applications. Stored procedures contain code that represents commonly performed tasks that are designed and then coded and stored in a procedure that can be used to perform the task over and over again. This course teaches the beginner SQL programmer or administrator how to create basic SQL queries and write and compile other code statements that allow for the development and administration of SQL Servers.

CRUD (Create,Read,Update,Delete)forms the cornerstone of all relational database operations.  In this course we will create stored procedures for each of these four database operations.

Topics we will cover include :
Naming convention for creating stored procedure
Creating stored procedures using T-SQL
Creating a CREATE stored procedure
Creating a READ stored procedure
Creating a UPDATE stored procedure 
Creating a DELETE stored procedure
Updating schema after stored procedure
Creating stored procedure using Visual studio

Before you can create a stored procedure on a SQL Server database you will need to belong to the administrator groups that has the sys admin role or you can grant specific user account or groups the CREATE PROCEDURE  permission in the database and ALTER permission on the schema in which the procedure is being created.

Stored procedures can be created using either SQL Server Management Studio or Transact-SQL (T-SQL)


Who is the target audience?
  • Beginner SQL Programmers
  • Beginner SQL Developer
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
01:53:17
+
Test Environment Setup
8 Lectures 33:21




Download adventureworks 2014 database
05:06

Install adventureworks 2014 database
04:14

Database Concepts
03:50

What is SQL
04:26
+
The Basics
4 Lectures 07:49
What is CRUD
01:20

What are stored procedures
02:42

Naming convention
00:56

Basic Application Design Structure
02:51
+
Creating Stored Procedures
5 Lectures 18:54
Ways to create stored procedures
00:42

CREATE stored procedure
06:20

READ stored procedure
03:32

UPDATE stored procedure
04:44

DELETE stored procedure
03:36
+
Basic Transact-SQL
6 Lectures 53:13
What is T-SQL
10:27

Reading Data with SELECT
09:28

T-SQL UPDATE
05:31

T-SQL DELETE
05:13

T-SQL INSERT
11:24

T-SQL CREATE
11:10
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,578 Reviews
35,292 Students
86 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.