T-Sql Programming And Scripting For Sql Dba And Developer

T-Sql Programming And Scripting For Sql Dba And Developer
Published 10/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

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

Gain insider tips for quickly resolving SQL Server development issues

Requirements

Basic knowledge of the SQL Server fundamentals

Description

Overview

Section 1: Introduction

Lecture 1 Introduction

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()

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