T-Sql Programming And Scripting For Sql Dba And Developer

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