https://i124.fastpic.org/big/2024/1113/20/96f30f1d850f3adca92a33a0ef511920.jpg
T-Sql Programming And Scripting For Sql Dba And Developer
Published 10/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 13.84 GB | Duration: 16h 55m
Built Your SQL Server T-SQL Programming and Scripting Skills: Master Essential Database Programming Techniques
What you'll learn
T-SQL Programming
TSQL and Scripting
Learn to work with unstructured data in SQL Server using various techniques
Gain insider tips for quickly resolving SQL Server development issues
Requirements
Basic knowledge of the SQL Server fundamentals
Description
Welcome to the course for "T-SQL Programming and Scripting For SQL DBA and Developer". In this course you will get in depth knowledge from Basic to Advance of T-SQL Programming and Scripting. You are going to learn how to developed and start writing the T-SQL Programing which will going to use in SQL Server. Basically this course has been divided in to multiple of session which include the Basic and advance coding. Even you will find the other additional session, Which will be the subcategory of the main course. For Sub-category you have to go through each module of the video. After completing the Each video session you will able to download the Script do the practice by your self. I am going to discuss each and every Scripts which has beet attached. I will be frequently uploading the video and you will get life time access to this curse. For doubt clarification I will provide all details at the end of this course so you can connect with me.This course has been designed in such a way that any one having the basic knowledge of SQL Server can easy learn and develop the T-SQL Programming and scripting for SQL Server. This Course is going to help for SQL DBA and SQL Server Developer.
Overview
Section 1: Introduction
Lecture 1 Introduction
Section 2: SQL Server Variable
Lecture 2 SQL Server Variable
Section 3: Begin and END Block with Exists Condition
Lecture 3 Begin and END Block with Exists Condition
Section 4: WAITFOR
Lecture 4 What is WAITFOR command in SQL server
Section 5: While Loop in SQL Server
Lecture 5 While Loop in SQL Server
Section 6: T-SQL Script to Create two Dependent jobs for SQL server
Lecture 6 T-SQL Script to Create two Dependent job that one job will complete than only ot
Section 7: How to Generate Script to perform sql Operation
Lecture 7 How to Generate T-SQL Script to kill all Active Process
Lecture 8 How to Generate Script t Cange all database Owner to sa
Lecture 9 How to Generate Script to Change multiple of Database Recovery Model
Lecture 10 How to Generate Script to Change multiple of SQL job Owner to Sa
Section 8: TRY and catch in SQL Server
Lecture 11 TRY Catch
Section 9: Throw and Raiserror
Lecture 12 Throw and Raiserror
Section 10: SET XACT ABORT
Lecture 13 SET XACT ABORT
Section 11: XACT_STATE()
Lecture 14 XACT_STATE()
Section 12: Cursor in SQL Server
Lecture 15 Cursor
Section 13: SQL Server Cursor Type - Static Cursor
Lecture 16 Static Cursor
Lecture 17 SQL Server Cursor Type - Forward Only Static Cursor
Lecture 18 SQL Server Cursor Type - Dynamic Cursor
Lecture 19 SQL Server Cursor Type - KEYSET Cursor
Section 14: When to use the Cursor in SQL Server
Lecture 20 When to use the Cursor in SQL Server
Section 15: Cursor With Store Procedure
Lecture 21 Cursor With Store Procedure
Section 16: Store Procedure in SQL Server
Lecture 22 Store Procedure Creation with and with out Parameter
Lecture 23 Stored Procedure with Output Parameter
Lecture 24 Create Single Stored Procedure for - Select , Insert , Update and Delete
Section 17: Function - User Defined Function in SQL Server - Type -1 - Scalar Function
Lecture 25 Function - User Defined Function in SQL Server
Lecture 26 Scalar Function - Example
Lecture 27 Calculate Age using Date of Birth
Lecture 28 Create Scalar Function for Age
Section 18: Creting Scalar Function with If Clause
Lecture 29 Creting Scalar Function with If Clause
Section 19: Function Type - 2 - Inline Table valued Functions
Lecture 30 Function Type - 2 - Inline Table valued Functions
Section 20: Function Type 3 - Multi_Statement_Table_Valued
Lecture 31 Function Type 3 - Multi_Statement_Table_Valued
Section 21: BULK INSERT and BCP
Lecture 32 BULK INSERT and BCP
Section 22: Difference between - SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY
Lecture 33 Difference between - SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY
Section 23: Trigger in SQL Server - DDL Trigger
Lecture 34 Introduction of Trigger - 1. DDL triggers
Lecture 35 How Trigger will use Auditing Purpose in SQL Server with function EVENTDATA()
Lecture 36 Use Trigger for Rename Table/Column
Section 24: Magic Tables in SQL server
Lecture 37 What are magic tables in SQL Server with Example of Insert/Delete and Update
Section 25: Trigger in SQL Server - DML Trigger
Lecture 38 DML Trigger in SQL Server
Lecture 39 DML - Instead of Trigger
Section 26: Trigger in SQL Server - Logon Trigger
Lecture 40 Logon Trigger - Ex: Limit the no of connection in SQL Server
Lecture 41 Logon Trigger - EX: Limit number of SQL Server connections to all user
Lecture 42 Login Trigger -EX: SQL Server connections with the specific client application
Lecture 43 Login Trigger -EX: Disallow user connection at a specific time frame
Lecture 44 Login Trigger -EX: Tracking Login Activities.
Section 27: Difference Between "sp_executesql" and "Execute" in SQL Server
Lecture 45 Difference between exec and sp_executesql
Section 28: What is OPENQUERY in SQL Server
Lecture 46 OPENQUERY
Section 29: System Function In SQL Server
Lecture 47 DATEADD
Lecture 48 DateDiff()
Lecture 49 DATEPART () and DATENAME () Functions
Section 30: String manipulation functions
Lecture 50 ASCII(), SELECT CHAR(), CHARINDEX(), SUBSTRING() , Len()
Section 31: Number functions in SQL Server
Lecture 51 LEFT() & RIGHT(), LOWER () and UPPER (), REPLACE (), REVERSE (), ROUND(), CEILIN
Lecture 52 ROW_NUMBER(), RANK () , DENSE_RANK (), NTILE() Functions
Section 32: Conversion functions in SQL Server
Lecture 53 CAST (), str(), CONVERT()
Section 33: TRANSACTIONS , COMMIT, SAVEPOINTS and ROLEBACK
Lecture 54 TRANSACTIONS , COMMIT, SAVEPOINTS and ROLEBACK in SQL SERVER
Section 34: SQL Server - ISOLATION LEVEL
Lecture 55 READ UNCOMMITTED
Lecture 56 READ COMMITTED
Lecture 57 REPEATABLE READ
Lecture 58 SERIALIZABLE_SNAPSHOT
Section 35: PIVOT and UNPIVOT Operator in SQL Server
Lecture 59 PIVOT Operator in SQL Server
Lecture 60 UNPIVOT Operator in SQL Server
Learn T-SQL Scripting and Programming and fulfill their own dream as SQL Developer,Create views, procedures , triggers and etc
https://images2.imgbox.com/45/a6/8Qjtyq1l_o.jpg
FileAxa
https://filecrypt.cc/Container/D0F5CA1002.html
https://fileaxa.com/21b3mjkb85ys/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part1.rar
https://fileaxa.com/qvqmcu6xkxmc/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part2.rar
https://fileaxa.com/8gsd7g1a66c0/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part3.rar
https://fileaxa.com/fv9uip7iqrh8/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part4.rar
https://fileaxa.com/jqff70ox07de/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part5.rar
https://fileaxa.com/td1t6njnby9i/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part6.rar
DDownload
https://ddownload.com/ub23muz7uyc1/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part1.rar
https://ddownload.com/ck6zvsd1ebdf/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part2.rar
https://ddownload.com/kvegsi94hwpu/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part3.rar
https://ddownload.com/33yta7mtkw1x/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part4.rar
https://ddownload.com/zgzi9a2fw232/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part5.rar
https://ddownload.com/ut9h6omwo3bq/Udemy_T-SQL_Programming_and_Scripting_For_SQL_DBA_and_Developer_2024-10.part6.rar
RapidGator
FileStore
https://filecrypt.cc/Container/84CC72B7BE.html
TurboBit
Видео
