Udemy - Stored Procedures Unpacked: Learn to Code T-SQL Stored Pr...

Category Other
Type Tutorials
Language English
Total size 1.5 GB
Uploaded By tutsnode

Downloads 333
Last checked 3 days ago
Date uploaded 5 years ago
Seeders 4
Leechers 2

Infohash : 77EF6F9B9AC2733AC4FE423DED320CF0A866820B

Description

In this Course you will Learn to:

Use stored procedures to implement business logic.
Develop stored procedures from scratch!
Learn some basic troubleshooting skills.
Know the right way to use cursors.
Apply database transaction techniques to commit or rollback your database changes.
Trap and handle errors.

Nothing is worse than

Being excited to learn something new but not knowing where to start.
Wasting time learning the wrong features.
Being overwhelmed with options and not know which to use.

Imagine Having…

Knowledge – Knowing how to quickly write stored procedures to take your SQL to the next level.
Confidence – Feeling good that you’re on the right track.
Accomplishment – Having a sense of accomplishment that you’ve learned something most cannot.
Fun – Having fun learning about cursors, stored procedures, and triggers!

By the time you’ve complete this course you’ll have an appreciation of developing stored procedures, overcome your fear, and able to write stored procedures that pass parameters, handle errors, and rollback unintended database changes.

Now that’s cool!
Who this course is for:

Beginner SQL query authors curious about combining SQL statements into transactions.
Developers looking to for a better way to develop and manage database code.
Analysts looking to create advanced data sources from SQL Server from Power BI.
Developers wanting to learn about database cursors.
Anyone who thinks that stored procedures are really scary (they aren’t!)

Requirements

You should already be familiar with basic queries, such as SELECT, GROUP BY, and ORDER BY clauses.
Knowledge of basic programming concepts, such as IF/THEN is a plus, but not mandatory.

Last Updated 5/2020

                Files: 

                Stored Procedures Unpacked - Learn to Code T-SQL Stored Procs
[TutsNode.com] - Stored Procedures Unpacked - Learn to Code T-SQL Stored Procs
Stored Procedure Walk Through
Defining a Stored Procedure.mp4 (142.2 MB)
Introductionen_US.srt (1.0 KB)
Defining a Stored Procedure-MZP-original.pdf (309.5 KB)
Defining a Stored Procedure-resource.txt (0.1 KB)
Introduction-21Y-origina.pdf (233.4 KB)
Parts of a Stored Procedure-AA0-original.pdf (213.8 KB)
Defining a Stored Procedureen_US.srt (19.6 KB)
Defining a Stored Procedure-297-original.pdf (125.6 KB)
Parts of a Stored Procedureen_US.srt (3.7 KB)
Parts of a Stored Procedure.mp4 (17.1 MB)
Introduction.mp4 (7.3 MB)

Programming Concepts
Working with Variables-RVQ-original.pdf (259.3 KB)
WHILE Loops.mp4 (118.8 MB)
IF THEN Logic.mp4 (85.0 MB)
IF THEN Logicen_US.srt (12.9 KB)
PRINT-43W-original.pdf (174.7 KB)
Working with Variables-resource.txt (0.2 KB)
IF THEN Logic-resource.txt (0.1 KB)
BEGIN END Code Blocks-83G-original.pdf (134.4 KB)
WHILE Loops-resource.txt (0.1 KB)
WHILE Loops-HLF-original.pdf (199.1 KB)
BEGIN END Code Blocksen_US.srt (1.8 KB)
WHILE Loopsen_US.srt (15.8 KB)
Working with Variablesen_US.srt (8.9 KB)
GOTO and Labelsen_US.srt (4.6 KB)
WAITFOR Statementen_US.srt (3.8 KB)
RETURNen_US.srt (3.0 KB)
PRINTen_US.srt (3.3 KB)
Working with Variable.mp4 (44.5 MB)
PRINT-IM5-original.pdf (66.5 KB)
GOTO and Labels-BQG-original.pdf (171.6 KB)
IF THEN Logic-PRC-original.pdf (165.2 KB)
RETURN-NP9-original.pdf (116.9 KB)
WAITFOR Statement-40W-original.pdf (158.7 KB)
Working with Variables-2FU-original.pdf (74.4 KB)
IF THEN Logic-DAB-original.pdf (88.4 KB)
WAITFOR Statement-F0M-original.pdf (79.4 KB)
GOTO and Labels.mp4 (30.9 MB)
WAITFOR Statement.mp4 (25.5 MB)
GOTO and Labels-X3I-original.pdf (71.0 KB)
RETURN-UG1-original.pdf (63.6 KB)
RETURN.mp4 (10.4 MB)
PRINT.mp4 (9.1 MB)
BEGIN END Code Blocks.mp4 (4.9 MB)
WHILE Loops-IFE-original.pdf (643.0 KB)

Introduction
Welcome to the Courseen_US.srt (2.9 KB)
Creating Your First Stored Procedure-FJ4-original.pdf (205.3 KB)
How to take this course.mp4 (74.4 MB)
What is a Stored Procedure and why do we need them-VRT-original.pdf (285.0 KB)
What is a Stored Procedure and why do we need themen_US.srt (6.7 KB)
Creating Your First Stored Procedureen_US.srt (7.8 KB)
How to take this courseen_US.srt (4.3 KB)
What is a Stored Procedure and why do we need them.mp4 (49.7 MB)
Creating Your First Stored Procedure.mp4 (36.2 MB)
Creating Your First Stored Procedure-CQV-original.pdf (70.5 KB)
Welcome to the Course.mp4 (12.2 MB)

Creating and Executing Stored Procedures
Returning Results with SELECTen_US.srt (5.1 KB)
Overviewen_US.srt (0.7 KB)
Using OUTPUT Parameters-D38-original.pdf (53.5 KB)
Return Codes-1TX-original.pdf (138.5 KB)
Using OUTPUT Parameters.mp4 (62.0 MB)
Using OUTPUT Parametersen_US.srt (7.6 KB)
Define a Stored Procedure with Parameters.mp4 (57.9 MB)
Define a Stored Procedure with Parametersen_US.srt (6.4 KB)
Return Codesen_US.srt (5.9 KB)
Overview-DKN-original.pdf (195.8 KB)
Return Codes.mp4 (43.5 MB)
Returning Results with SELECT-DED-original.pdf (94.1 KB)
Using OUTPUT Parameters-X2A-original.pdf (102.0 KB)
Returning Results with SELECT.mp4 (31.2 MB)
Returning Results with SELECT-N7D-original.pdf (73.9 KB)
Return Codes-C84-original.pdf (70.1 KB)
Define a Stored Procedure with Parameters-2BH-original.pdf (64.3 KB)
Overview.mp4 (6.3 MB)
Define a Stored Procedure with Parameters-KBP-original.pdf (575.9 KB)

Error Catching
Structured Error Trapping with CATCH and TRY-resource.txt (0.1 KB)
Unstructured Error Handling using ERROR-resource.txt (0.1 KB)
Structured Error Trapping with CATCH and TRYen_US.srt (7.4 KB)
Structured Error Trapping with CATCH and TRY.mp4 (54.7 MB)
Unstructured Error Handling using ERRORen_US.srt (3.9 KB)
Unstructured Error Handling using ERROR-SQE-original.pdf (190.7 KB)
Structured Error Trapping with CATCH and TRY-478-original.pdf (190.7 KB)
Unstructured Error Handling using ERROR.mp4 (32.6 MB)
Unstructured Error Handling using ERROR-HQ9-original.pdf (88.8 KB)
Structured Error Trapping with CATCH and TRY-9FS-original.pdf (88.8 KB)

Wrap-up
Thank You and Whats Next-resource.txt (0.0 KB)

Cursors and Transactions
Introduction to Cursors-RJX-original.pdf (466.3 KB)
ISO versus Non-ISO Cursor Syntax-TZX-original.pdf (330.1 KB)
Transactions.mp4 (81.4 MB)
Case Study-resource.txt (0.1 KB)
Transactionsen_US.srt (9.2 KB)
Introduction to Cursors.mp4 (60.5 MB)
Introduction to Cursorsen_US.srt (7.6 KB)
ISO versus Non-ISO Cursor Syntaxen_US.srt (6.0 KB)
Case Studyen_US.srt (6.0 KB)
FETCH Commanden_US.srt (5.9 KB)
FETCH Command-HE2-original.pdf (192.9 KB)
Introduction to Cursors-IEN-original.pdf (91.2 KB)
Case Study.mp4 (48.5 MB)
ISO versus Non-ISO Cursor Syntax.mp4 (41.4 MB)
FETCH Command.mp4 (34.7 MB)
Case Study-KOY-original.pdf (149.1 KB)
Case Study-Y61-original.pdf (72.0 KB)
Transactions-TXT-original.pdf (69.0 KB)
Transactions-ZQ2-original.pdf (692.2 KB)

Setup Your Learning Lab (Optional)
Download SQL Serveren_US.srt (2.7 KB)
Install SQL Serveren_US.srt (4.6 KB)
Download Sample Databasesen_US.srt (4.0 KB)
Download and Install SSMSen_US.srt (3.7 KB)
Restore Sample Databasesen_US.srt (3.0 KB)
Download Sample Databases.mp4 (32.5 MB)
Download and Install SSMS.mp4 (22.0 MB)
Restore Sample Databases.mp4 (19.6 MB)
Install SQL Server.mp4 (16.1 MB)
Download SQL Server.mp4 (10.1 MB)
Download SQL Server-8NN-original.pdf (1.1 MB)
Download SQL Server-S9X-original.pdf (970.4 KB)

Debugging Stored Procedures
Interactive Debugging (SSMS 17 or Visual Studio)-resource.txt (0.1 KB)
Interactive Debugging.mp4 (64.6 MB)
Interactive Debugging.srt (7.4 KB)
Interactive Debugging (SSMS 17 or Visual Studio)en_US.srt (7.4 KB)
What is Debuggingen_US.srt (3.6 KB)
Interactive Debugging.mp4 (46.3 MB)
What is Debugging.mp4 (37.8 MB)
Interactive Debugging.pdf (125.4 KB)
Interactive Debugging.pdf (103.7 KB)
Interactive Debugging (SSMS 17 or Visual Studio)-DXS-original.pdf (100.0 KB)
What is Debugging.pdf (699.0 KB)

TutsNode.com.txt (0.1 KB)
[TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB)
.pad0 (0.0 KB)
(0.0 KB)
(0.0 KB)
(0.5 KB)
(1.9 KB)
(0.4 KB)
(0.1 KB)
(0.8 KB)
(2.7 KB)
(0.7 KB)
(2.9 KB)
(5.6 KB)
(33.8 KB)
(9.8 KB)
(32.6 KB)
(0.7 KB)
(23.7 KB)
(10.3 KB)
(5.2 KB)
(4.0 KB)
(4.6 KB)
(38.0 KB)
(16.6 KB)
(42.0 KB)
(3.2 KB)
(13.8 KB)
(309.6 KB)
(407.8 KB)
(298.8 KB)
(58.1 KB)
(448.9 KB)
(459.9 KB)
(202.4 KB)
(239.8 KB)
(111.3 KB)
(382.0 KB)
(53.6 KB)
(325.0 KB)
(331.8 KB)
(381.0 KB)

There are currently no comments. Feel free to leave one :)

Code:

udp://inferno.demonoid.pw:3391/announce
udp://tracker.openbittorrent.com:80/announce
udp://tracker.opentrackr.org:1337/announce
udp://torrent.gresille.org:80/announce
udp://glotorrents.pw:6969/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://9.rarbg.to:2710/announce
udp://shadowshq.yi.org:6969/announce
udp://tracker.zer0day.to:1337/announce