▲
0
0

report

Udemy - Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs

seeders: 0
leechers: 0
Download torrent
Added 5 years ago by tutsnode in Other
Download Fast Safe Anonymous
movies, software, shows...

Files

Udemy - Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs (Size: 1.45 GB)
  .pad
  0 22 B
  1 3 B
  2 30 B
  3 473 B
  4 1.95 KB
  5 362 B
  6 95 B
  7 833 B
  8 2.74 KB
  9 716 B
  10 2.88 KB
  11 5.61 KB
  12 33.8 KB
  13 9.77 KB
  14 32.57 KB
  15 708 B
  16 23.66 KB
  17 10.25 KB
  18 5.21 KB
  19 4.01 KB
  20 4.64 KB
  21 37.98 KB
  22 16.62 KB
  23 41.98 KB
  24 3.21 KB
  25 13.77 KB
  26 309.6 KB
  27 407.83 KB
  28 298.78 KB
  29 58.14 KB
  30 448.88 KB
  31 459.88 KB
  32 202.36 KB
  33 239.77 KB
  34 111.34 KB
  35 381.99 KB
  36 53.59 KB
  37 325.01 KB
  38 331.79 KB
  39 381.04 KB
  TutsNode.com.txt 63 B
  [TGx]Downloaded from torrentgalaxy.to .txt 585 B
  [TutsNode.com] - Stored Procedures Unpacked - Learn to Code T-SQL Stored Procs
  01 Introduction
  001 Welcome to the Course.mp4 12.21 MB
  001 Welcome to the Courseen_US.srt 2.91 KB
  002 What is a Stored Procedure and why do we need them-VRT-original.pdf 284.95 KB
  002 What is a Stored Procedure and why do we need them.mp4 49.72 MB
  002 What is a Stored Procedure and why do we need themen_US.srt 6.68 KB
  003 Creating Your First Stored Procedure-CQV-original.pdf 70.54 KB
  003 Creating Your First Stored Procedure-FJ4-original.pdf 205.29 KB
  003 Creating Your First Stored Procedure.mp4 36.2 MB
  003 Creating Your First Stored Procedureen_US.srt 7.78 KB
  004 How to take this course.mp4 74.45 MB
  004 How to take this courseen_US.srt 4.28 KB
  02 Setup Your Learning Lab (Optional)
  007 Download SQL Server-8NN-original.pdf 1.13 MB
  007 Download SQL Server-S9X-original.pdf 970.41 KB
  007 Download SQL Server.mp4 10.06 MB
  007 Download SQL Serveren_US.srt 2.71 KB
  008 Install SQL Server.mp4 16.1 MB
  008 Install SQL Serveren_US.srt 4.64 KB
  009 Download and Install SSMS.mp4 22 MB
  009 Download and Install SSMSen_US.srt 3.74 KB
  010 Download Sample Databases.mp4 32.54 MB
  010 Download Sample Databasesen_US.srt 3.95 KB
  011 Restore Sample Databases.mp4 19.64 MB
  011 Restore Sample Databasesen_US.srt 3.01 KB
  03 Stored Procedure Walk Through
  012 Introduction-21Y-origina.pdf 233.43 KB
  012 Introduction.mp4 7.3 MB
  012 Introductionen_US.srt 1001 B
  013 Parts of a Stored Procedure-AA0-original.pdf 213.8 KB
  013 Parts of a Stored Procedure.mp4 17.07 MB
  013 Parts of a Stored Procedureen_US.srt 3.71 KB
  014 Defining a Stored Procedure-297-original.pdf 125.64 KB
  014 Defining a Stored Procedure-MZP-original.pdf 309.48 KB
  014 Defining a Stored Procedure-resource.txt 81 B
  014 Defining a Stored Procedure.mp4 142.24 MB
  014 Defining a Stored Procedureen_US.srt 19.62 KB
  04 Debugging Stored Procedures
  016 What is Debugging.mp4 37.79 MB
  016 What is Debugging.pdf 698.99 KB
  016 What is Debuggingen_US.srt 3.58 KB
  017 Interactive Debugging.mp4 64.58 MB
  017 Interactive Debugging.pdf 103.71 KB
  017 Interactive Debugging.srt 7.4 KB
  018 Interactive Debugging (SSMS 17 or Visual Studio)-DXS-original.pdf 99.98 KB
  018 Interactive Debugging (SSMS 17 or Visual Studio)-resource.txt 81 B
  018 Interactive Debugging (SSMS 17 or Visual Studio)en_US.srt 7.38 KB
  018 Interactive Debugging.mp4 46.28 MB
  018 Interactive Debugging.pdf 125.38 KB
  05 Programming Concepts
  019 Working with Variable.mp4 44.49 MB
  019 Working with Variables-2FU-original.pdf 74.45 KB
  019 Working with Variables-RVQ-original.pdf 259.33 KB
  019 Working with Variables-resource.txt 164 B
  019 Working with Variablesen_US.srt 8.93 KB
  020 PRINT-43W-original.pdf 174.7 KB
  020 PRINT-IM5-original.pdf 66.5 KB
  020 PRINT.mp4 9.05 MB
  020 PRINTen_US.srt 3.27 KB
  021 BEGIN END Code Blocks-83G-original.pdf 134.43 KB
  021 BEGIN END Code Blocks.mp4 4.89 MB
  021 BEGIN END Code Blocksen_US.srt 1.82 KB
  022 IF THEN Logic-DAB-original.pdf 88.43 KB
  022 IF THEN Logic-PRC-original.pdf 165.18 KB
  022 IF THEN Logic-resource.txt 145 B
  022 IF THEN Logic.mp4 85.03 MB
  022 IF THEN Logicen_US.srt 12.88 KB
  023 WHILE Loops-HLF-original.pdf 199.12 KB
  023 WHILE Loops-IFE-original.pdf 642.96 KB
  023 WHILE Loops-resource.txt 135 B
  023 WHILE Loops.mp4 118.8 MB
  023 WHILE Loopsen_US.srt 15.77 KB
  024 WAITFOR Statement-40W-original.pdf 158.68 KB
  024 WAITFOR Statement-F0M-original.pdf 79.41 KB
  024 WAITFOR Statement.mp4 25.46 MB
  024 WAITFOR Statementen_US.srt 3.82 KB
  025 GOTO and Labels-BQG-original.pdf 171.59 KB
  025 GOTO and Labels-X3I-original.pdf 70.98 KB
  025 GOTO and Labels.mp4 30.91 MB
  025 GOTO and Labelsen_US.srt 4.59 KB
  026 RETURN-NP9-original.pdf 116.9 KB
  026 RETURN-UG1-original.pdf 63.62 KB
  026 RETURN.mp4 10.44 MB
  026 RETURNen_US.srt 2.96 KB
  06 Error Catching
  027 Unstructured Error Handling using ERROR-HQ9-original.pdf 88.85 KB
  027 Unstructured Error Handling using ERROR-SQE-original.pdf 190.74 KB
  027 Unstructured Error Handling using ERROR-resource.txt 68 B
  027 Unstructured Error Handling using ERROR.mp4 32.6 MB
  027 Unstructured Error Handling using ERRORen_US.srt 3.94 KB
  028 Structured Error Trapping with CATCH and TRY-478-original.pdf 190.74 KB
  028 Structured Error Trapping with CATCH and TRY-9FS-original.pdf 88.85 KB
  028 Structured Error Trapping with CATCH and TRY-resource.txt 96 B
  028 Structured Error Trapping with CATCH and TRY.mp4 54.68 MB
  028 Structured Error Trapping with CATCH and TRYen_US.srt 7.36 KB
  07 Creating and Executing Stored Procedures
  029 Overview-DKN-original.pdf 195.78 KB
  029 Overview.mp4 6.27 MB
  029 Overviewen_US.srt 715 B
  030 Define a Stored Procedure with Parameters-2BH-original.pdf 64.25 KB
  030 Define a Stored Procedure with Parameters-KBP-original.pdf 575.88 KB
  030 Define a Stored Procedure with Parameters.mp4 57.94 MB
  030 Define a Stored Procedure with Parametersen_US.srt 6.44 KB
  031 Returning Results with SELECT-DED-original.pdf 94.13 KB
  031 Returning Results with SELECT-N7D-original.pdf 73.9 KB
  031 Returning Results with SELECT.mp4 31.21 MB
  031 Returning Results with SELECTen_US.srt 5.05 KB
  032 Using OUTPUT Parameters-D38-original.pdf 53.49 KB
  032 Using OUTPUT Parameters-X2A-original.pdf 101.98 KB
  032 Using OUTPUT Parameters.mp4 62.02 MB
  032 Using OUTPUT Parametersen_US.srt 7.6 KB
  033 Return Codes-1TX-original.pdf 138.45 KB
  033 Return Codes-C84-original.pdf 70.11 KB
  033 Return Codes.mp4 43.47 MB
  033 Return Codesen_US.srt 5.93 KB
  08 Cursors and Transactions
  034 Transactions-TXT-original.pdf 68.96 KB
  034 Transactions-ZQ2-original.pdf 692.21 KB
  034 Transactions.mp4 81.37 MB
  034 Transactionsen_US.srt 9.21 KB
  035 Introduction to Cursors-IEN-original.pdf 91.21 KB
  035 Introduction to Cursors-RJX-original.pdf 466.32 KB
  035 Introduction to Cursors.mp4 60.48 MB
  035 Introduction to Cursorsen_US.srt 7.56 KB
  036 ISO versus Non-ISO Cursor Syntax-TZX-original.pdf 330.12 KB
  036 ISO versus Non-ISO Cursor Syntax.mp4 41.43 MB
  036 ISO versus Non-ISO Cursor Syntaxen_US.srt 6.02 KB
  037 FETCH Command-HE2-original.pdf 192.92 KB
  037 FETCH Command.mp4 34.72 MB
  037 FETCH Commanden_US.srt 5.86 KB
  038 Case Study-KOY-original.pdf 149.07 KB
  038 Case Study-Y61-original.pdf 72.04 KB
  038 Case Study-resource.txt 82 B
  038 Case Study.mp4 48.46 MB
  038 Case Studyen_US.srt 6.02 KB
  09 Wrap-up
  039 Thank You and Whats Next-resource.txt 30 B

Description



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

Related Torrents

torrent name size uploader age seed leech
Udemy - SQL - ETL Developer - T-SQL - Stored Procedures - ETL - SSIS Posted by freecoursewb in Other
2.4 GB freecoursewb 3 years 0 0
[ FreeCourseWeb ] Udemy - Stored Procedures Unpacked - Learn to Code T-SQL Stored Procs Posted by freecoursewb in Other
1.4 GB freecoursewb 6 years 0 2