Published 08/2022
Genre: eLearning | MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.30 GB | Duration: 129 lectures • 4h 8m
Learn SQL Server programming from scratch and create useful and powerful stored procedures
What you’ll learn
Stored procedure fundamentals
Using parameters in stored procedure
variables
Output parameters and return values
IF statements
WHILE loops
User defined functions
Temporary tables
Table variables
Table valued functions
Common table expressions
Dynamic SQL
Transactions
DML triggers
DDL triggers
Requirements
You will need to have SQL Server installed (2012 or above).
You will need to restore AdventureWorks sample database (any OLTP versions)
A familiarity with Microsoft SQL Server
Basic SQL Querying
No programming experience needed
Description
Learn SQL Server Programming by doing!
This course will assist you in achieving the objective of creating useful and powerful stored procedures. This is a step-by-step course. We will build on what we had learned in every new session. This course teaches you SQL Programming and Stored Procedure from scratch. No prior programming experience is required.
Why should you learn SQL even if you are not a Developer?
These days, almost everyone has to work with data in some form or another. Usually, it’s through spreadsheets or databases, but if you can learn a little SQL you can become so much more powerful in your job.
Who is teaching you?
My name is Enrique Valencia. I’m a database professional based in Singapore. I’ve been a SQL Server DBA for 7 years. Now, I’m working on various open-source databases such as MySQL, MariaDB, PostgreSQL, Redis, Elasticsearch, and MongoDB. My focus is on SQL performance optimization, high availability, and automation.
I hope that you’ll enjoy this course as much as I did create it!
Below is the list of topics that will be covered in this course.
Stored Procedure Fundamentals – A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.
Using Parameters in Stored Procedures – used to exchange data between stored procedures and functions and the application or tool that is called the stored procedure or function.
Variables – an object that can hold a single data value of a specific type.
Output Parameters & Return Values – two ways of returning result sets or data from a Stored Procedure to a calling program.
IF Statements – Imposes conditions on the execution of a Transact-SQL statement.
WHILE Loops – used to repeatedly execute a certain piece of SQL script.
User Defined Functions – routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value.
Temporary Tables – database table that exists temporarily on the database server.
Table Variables – a special type of the local variable that helps to store data temporarily, similar to the temp table in SQL Server.
Table Valued Functions – user-defined function that returns a table data type and also it can accept parameters.
Common Table Expressions (CTEs) – a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement.
Dynamic SQL Scripts – a programming technique that enables you to build SQL statements dynamically at runtime.
Transactions – a sequential group of statements or queries to perform single or multiple tasks in a database.
DML Triggers – a special type of stored procedure that automatically takes effect when a data manipulation language (DML) event takes place that affects the table or view defined in the trigger.
DDL Triggers – fire in response to a variety of Data Definition Language (DDL) events.
Who this course is for
Database Developers
Database Administrators
Anyone who wants to learn SQL Programming
Homepage
https://www.udemy.com/course/sql-server-programming-and-stored-procedures-fundamentals/
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM