| 0 | 102.4 B | ||
| 1 | 67.5 KB | ||
| 01. Introduction.mp4 | 1.7 MB | ||
| 01. Introduction.vtt | 1.8 KB | ||
| 02. The Business Requirement.vtt | 5.2 KB | ||
| 2 | 233.8 KB | ||
| 02. The Business Requirement.mp4 | 7.4 MB | ||
| 03. The Insert Contact Stored Procedure.mp4 | 8.3 MB | ||
| 03. The Insert Contact Stored Procedure.vtt | 3.6 KB | ||
| 04. Executing and Testing a Stored Procedure.mp4 | 8.3 MB | ||
| 04. Executing and Testing a Stored Procedure.vtt | 3.2 KB | ||
| 05. Adding Parameters to a Stored Procedure.mp4 | 16.8 MB | ||
| 05. Adding Parameters to a Stored Procedure.vtt | 7.5 KB | ||
| 06. Optional Parameters.mp4 | 6.8 MB | ||
| 06. Optional Parameters.vtt | 3.6 KB | ||
| 07. Retrieving Record Identifiers.mp4 | 26.4 MB | ||
| 07. Retrieving Record Identifiers.vtt | 9.8 KB | ||
| 08. Output Parameters.mp4 | 12.9 MB | ||
| 08. Output Parameters.vtt | 5.5 KB | ||
| 09. Using SET Options.mp4 | 9.7 MB | ||
| 09. Using SET Options.vtt | 4.7 KB | ||
| 1. Course Overview.mp4 | 4.1 MB | ||
| 1. Course Overview.vtt | 3.1 KB | ||
| 1. Introduction.mp4 | 4.1 MB | ||
| 1. Introduction.vtt | 3.9 KB | ||
| 10. Calling a Procedure from Another Procedure.mp4 | 9.4 MB | ||
| 10. Calling a Procedure from Another Procedure.vtt | 3.7 KB | ||
| 11. Adding Business Logic.mp4 | 10.7 MB | ||
| 11. Adding Business Logic.vtt | 5.5 KB | ||
| 12. Summary.mp4 | 2.1 MB | ||
| 12. Summary.vtt | 2.2 KB | ||
| 2. A Quick SQL Server Recap.mp4 | 6.4 MB | ||
| 2. A Quick SQL Server Recap.vtt | 5.3 KB | ||
| 2. Inheriting a Stored Procedure.mp4 | 12.7 MB | ||
| 2. Inheriting a Stored Procedure.vtt | 6.9 KB | ||
| 2. The Print Statement.mp4 | 17.3 MB | ||
| 2. The Print Statement.vtt | 9.5 KB | ||
| 3. Alternatives to Cursors.mp4 | 10.7 MB | ||
| 3. Debugging with SQL Server Management Studio.mp4 | 24.4 MB | ||
| 3. What Is a Stored Procedure.mp4 | 6.9 MB | ||
| 3 | 174.1 KB | ||
| 3. Alternatives to Cursors.vtt | 4.4 KB | ||
| 3. Debugging with SQL Server Management Studio.vtt | 13.4 KB | ||
| 3. What Is a Stored Procedure.vtt | 7.7 KB | ||
| 4. Handling Errors with TryCatch.mp4 | 10.8 MB | ||
| 4. Installing SQL Server and Setting up a Database.mp4 | 13.7 MB | ||
| 4 | 41.9 KB | ||
| 4. Handling Errors with TryCatch.vtt | 6.3 KB | ||
| 4. Installing SQL Server and Setting up a Database.vtt | 7.3 KB | ||
| 4. User-defined Data Types.mp4 | 15 MB | ||
| 4. User-defined Data Types.vtt | 8.5 KB | ||
| 5. Calling a Stored Procedure with a Table-valued Parameter.mp4 | 4.4 MB | ||
| 5. Calling a Stored Procedure with a Table-valued Parameter.vtt | 2.8 KB | ||
| 5. Return Codes.mp4 | 7.2 MB | ||
| 5. Return Codes.vtt | 3.3 KB | ||
| 5. Stored Procedure T-SQL Statements.mp4 | 6.4 MB | ||
| 5. Stored Procedure T-SQL Statements.vtt | 4.4 KB | ||
| 6. Creating a Stored Procedure.mp4 | 8.1 MB | ||
| 6. Creating a Stored Procedure.vtt | 5 KB | ||
| 6. Handling Failed Transactions.mp4 | 11.1 MB | ||
| 6. Handling Failed Transactions.vtt | 4.5 KB | ||
| 6. Summary.mp4 | 1.1 MB | ||
| 6. Summary.vtt | 1.4 KB | ||
| 7. Defensive Coding.mp4 | 9.9 MB | ||
| 7. Defensive Coding.vtt | 4.1 KB | ||
| 7. Managing Procedures Using SQL Server Management Studio.mp4 | 13.3 MB | ||
| 7. Managing Procedures Using SQL Server Management Studio.vtt | 6.8 KB | ||
| 8. Summary.mp4 | 1.2 MB | ||
| 8. Summary.vtt | 1.3 KB | ||
| TutsNode.net.txt | 102.4 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 614.4 B | ||
| sql-server-database-programming-stored-procedures.zip | 2.3 MB | ||
| 5 | 32.1 KB | ||
| 6 | 202 KB | ||
| 7 | 96 KB | ||
| 8 | 73.6 KB | ||
| 9 | 190.1 KB | ||
| 10 | 171.3 KB | ||
| 11 | 34.7 KB | ||
| 12 | 87.8 KB | ||
| 13 | 61.1 KB | ||
| 14 | 69.2 KB | ||
| 15 | 52.1 KB | ||
| 16 | 171.2 KB | ||
| 17 | 194.4 KB | ||
| 18 | 201.1 KB | ||
| 19 | 150.3 KB | ||
| 20 | 62 KB | ||
| 21 | 128.1 KB | ||
| 22 | 243.9 KB | ||
| 23 | 123.5 KB | ||
| 24 | 148.5 KB | ||
| 25 | 136.2 KB | ||
| 26 | 184.4 KB | ||
| 27 | 187 KB | ||
| 28 | 61.7 KB | ||
| 29 | 245 KB | ||
| 30 | 160.2 KB | ||
| 31 | 129.8 KB | ||
| 32 | 54.7 KB | ||
| 33 | 107.8 KB | ||
| 34 | 36.5 KB | ||
| ▲ 108 total files | |||
Description
So, you use SQL Server. But are you using stored procedures? No? Then you’re not using SQL Server’s full potential! Watch this course to learn how to reduce code, maximize performance, and simplify security in your databases with stored procedures.
Ever wondered how to create repeatable, consistent, secure code in SQL Server? If you have, it sounds like you need to learn about stored procedures. In this course, Programming SQL Server Database Stored Procedures, you will gain the ability to create and manage stored procedures in Microsoft SQL Server. First, you will learn what a stored procedure is and how to create and manage simple procedures using SQL Server Management Studio. Next, you will discover how powerful stored procedures can be when you use parameters. Stored procedures support simple parameters like strings and integers, but you’ll also see how you can use your own custom data types as parameters with a stored procedure. Then, you will return data from stored procedures, using record sets and output parameters. Finally, you will explore how to debug your stored procedures as you write them, starting off with the basic PRINT statement before moving on to stepping through code using SQL Server Management Studio. When you’re finished with this course, you will have the skills and knowledge of SQL Server needed to create and manage your own stored procedures. Software required: SQL Server Development Edition, SQL Server Management Studio
Last Updated 12/2022
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 4.1 GB | freecoursewb | 6 months | 3 | 2 | |
| 839 MB | freecoursewb | 2 years | 0 | 0 | |
| 28 GB | tutsnode | 3 years | 5 | 4 | |
| 965.6 MB | freecoursewb | 3 years | 3 | 3 | |
|
SkillShare | SQL Programming: The SQL Database Programming Essentials Training 2022 [FCO] Posted by
SunRiseZone in Other
|
536.8 MB | SunRiseZone | 4 years | 0 | 0 |
All Comments