Learn SQL Server Advanced TSQL Course From MCSE Certified

Learn SQL Server & Advanced TSQL Course From MCSE Certified, available at $44.99, has an average rating of 3.8, with 60 lectures, based on 10 reviews, and has 53 subscribers.

You will learn about Either youre a newbie OR a developer with 2 to 5 years of experience, this course will be beneficial for you to enhance your skills and make it next level By the end of this course you will be a professional SQL Database Developer with each & every skills related to T-SQL and Databases Youll be Handling Complex & Native Stored Procedures, Indexed Views, UDFs, Tables, Temp & Temporal & In-Memory Tables & Custom Data Types You can handle tasks for Database Administration, Database Creation, Data Manipulation, Data Separation, Data Dumping, Data Conversion and Data Migration You can easily Optimize the queries in SQL Server through Actual & Estimated Execution Plan after Minimizing the Page Reads This course is ideal for individuals who are Anyone who have either beginner level skills OR even a complete newbie in SQL Server with T-SQL & Databases or Anyone who wants to start the career in SQL Server It is particularly useful for Anyone who have either beginner level skills OR even a complete newbie in SQL Server with T-SQL & Databases or Anyone who wants to start the career in SQL Server.

Enroll now: Learn SQL Server & Advanced TSQL Course From MCSE Certified

Summary

Title: Learn SQL Server & Advanced TSQL Course From MCSE Certified

Price: $44.99

Average Rating: 3.8

Number of Lectures: 60

Number of Published Lectures: 60

Number of Curriculum Items: 60

Number of Published Curriculum Objects: 60

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Either youre a newbie OR a developer with 2 to 5 years of experience, this course will be beneficial for you to enhance your skills and make it next level

By the end of this course you will be a professional SQL Database Developer with each & every skills related to T-SQL and Databases

Youll be Handling Complex & Native Stored Procedures, Indexed Views, UDFs, Tables, Temp & Temporal & In-Memory Tables & Custom Data Types

You can handle tasks for Database Administration, Database Creation, Data Manipulation, Data Separation, Data Dumping, Data Conversion and Data Migration

You can easily Optimize the queries in SQL Server through Actual & Estimated Execution Plan after Minimizing the Page Reads

Who Should Attend

Anyone who have either beginner level skills OR even a complete newbie in SQL Server with T-SQL & Databases

Anyone who wants to start the career in SQL Server

Target Audiences

Anyone who have either beginner level skills OR even a complete newbie in SQL Server with T-SQL & Databases

Anyone who wants to start the career in SQL Server

This course has been divided into 14 sections in order to get awesome skills in T-SQL (Transact Structured Query Language), Microsoft SQL Server, Database, Database Design, Database Administration, Database Management System, TSQL Programming, TSQL Database, SQL Server TSQL, SQL Server Performance, SQL Server Performance Tuner, SQL Server Database Performance, Advanced SQL Server Performance & Query Optimize

Section 1: Databases & SQL Server Settings

In this section, you’ll learn Installing SQL Server Developer Edition & Management Studio, Restoring Database Backup, and Creating Database & Managing SQL Server Settings and lastly you’ll learn how to take Database Backup

Section 2: Query Processing & Set Operators

In this section, you’ll learn about Logical Query Processing, Filter with Where Clause & Order By Clause, Managing Group by Clause, How & Where to use Cube & Rollup instead of Group By, Difference between Union & Union All Set operators and lastly you’ll learn about Intersect & Except operators

Section 3: Joins & Sub Queries

In this section, you’ll learn about Inner Join, Left Outer Join & Right Outer Join, and Cross Join & Self Join

Section 4: Data Modifications & Structural Changes

In this section, you’ll learn How to Create Tables through Different Methods, How to Insert Data in the form of Rows into Tables through Different Methods, How to Update / Modify the existing Data in the form rows inside Tables through Different Methods, How to Delete Data / Wipe Out Entire Table Data in the form rows through Different Methods, How to manage Primary Key / Unique Key either with Identity or with Sequence or with Unique Identifier, How to use Output Clause For getting Inserted, Updated, Deleted data for debugging purposes and lastly you’ll learn How to perform Structural Changes & Schema Modifications in order to add / remove columns in existing tables

Section 5: Sub Query & Table Expressions & Table Operators

In this section, you’ll learn about Sub Query & Correlated Sub Query & Exists and Not Exists, Table Expressions & Derived Table & Common Type Expressions, Cross Apply & Outer Apply Operators and lastly you’ll learn about Pivot and Unpivot operators to transform the rows into columns and columns into rows

Section 6: Temp Tables & Temporal Tables

In this section, you’ll learn about Local Temp Tables & Global Temp Tables & Variable Type Temp Tables and Temporal Table with History Management of modified / deleted data

Section 7: Window Functions

In this section, you’ll learn about Ranking & Offset Window Functions and Aggregate Window Functions as an alternative of Group By clause

Section 8: Views & Synonyms

In this section, you’ll learn about Views & Encrypted Views & How to perform Insert / Update / Delete through Views for underlying tables, Synonym & Synonym against Undefined Objects e.g. Tables, Views

Section 9: Functions & Stored Procedures

In this section, you’ll learn about Scalar / Single Valued UDF (User Defined Functions), Inline Table Valued UDF (User Defined Functions) & Multi-Statement Table Valued UDF (User Defined Functions), Basics of Stored Procedure along with Input type & Output type Parameters, Stored Procedure with Branch Logic (If / Else), and lastly you’ll learn about Stored Procedure with Dynamic SQL (T-SQL which compiled / executed at runtime)

Section 10: Triggers & Cursor

In this section, you’ll learn about DML (Data Modification Language) Trigger which generated After (Insert/Update/Delete) Or Before (Insert/Update/Delete), DDL (Data Definition Language) Trigger on entire SQL Server Level or Specific Database Level, and lastly you’ll learn about Cursor & why we should always use Fast Forward Cursor if possible & While Loop for iteration

Section 11: Transactions

In this section, you’ll learn about System Transactions Type & User Transactions Type and Auto Commit Transactions, Implicit Transactions with Xact Abort for Auto Rollback, Explicit Transactions & Nested Level of Transactions (Transactions within another transactions), Transactions after creating Custom Data Types which would be passed to Stored Procedure as parameter for handling custom cases, Transactions with Multiple Save Points in order to rollback specific parts

Section 12: Transactions Isolation Levels

In this section, you’ll learn about Transactions with Read Uncommitted Isolation Level & you would know about Dirty Read problem & difference between Shared Locks and Exclusive Locks, you’ll learn about Transactions with Read Committed & Repeatable Read Isolation levels & you would know about Non-Repeatable Read problem, you’ll learn about Transactions with Serializable Isolation Level & you would know about Phantom Read problem, you’ll learn about Transactions with Snapshot Isolation level & Difference between Pessimistic and Optimistic Isolation Levels, and lastly you’ll learn about Transactions with Read Committed Snapshot Isolation Level & I’ll give you my Final Thought on Good & Bad Isolation Level

Section 13: Transactions Error Handling & Deadlocks

In this section, you’ll learn about Transactions Error Handling and Handling Dead Locks occur during Concurrent Transactions & lastly you also get some idea about extracting Dead Lock information from Extended Events

Section 14: Query Optimization

In this section, you’ll learn about Heap & Clustered Indexes & Pages with Physical Stats, Clustered Indexes & Non Clustered Indexes & Differences between Clustered & Non-Clustered Indexes, you’ll learn how to read & understand SQL Server Query Execution Plan, you’ll learn how to optimize Views as Indexed Vies and how to optimize query having Multiple Joins, Optimizing CPU Time with less Logical and Physical Reads & Index Defragmentation and Statistics Recompilation, you’ll learn about Searchable Arguments in Predicates (where clause, join clause, having clause) & Handling Overlapping Indexes with same columns (Multiple Indexes with same key columns), and lastly you’ll learn about In-Memory Optimized Tables & Native Compiled Stored Procedure & you’ll see Live Performance Comparison between Tables, In Memory Tables, Interpreted Stored Procedure & Native Compiled Stored Procedure

More Learnings

In this section, you’ll learn about how to perform Insert / Update / Delete through single Merge query faster execution

Course Curriculum

Lecture 1: Introduction

Chapter 1: Databases & SQL Server Settings

Lecture 1: Installing SQL Server Developer Edition & Management Studio

Lecture 2: Restore Database Backup

Lecture 3: Creating Database & SQL Server Settings

Lecture 4: Take Database Backup

Chapter 2: Query Processing & Set Operators

Lecture 1: Logical Query Processing

Lecture 2: Filter & Order By

Lecture 3: Group By

Lecture 4: Cube & Rollup

Lecture 5: Union & UnionAll

Lecture 6: Intersect & Except

Chapter 3: Joins & Sub Queries

Lecture 1: Inner Join

Lecture 2: Left Join & Right Join

Lecture 3: Cross Join & Self Join

Chapter 4: Data Modifications & Structural Changes

Lecture 1: Creating Table Different Methods

Lecture 2: Inserting Data Different Methods

Lecture 3: Update Data Different Methods

Lecture 4: Delete Data Different Methods

Lecture 5: Keys with Identity & Keys with Sequence & Keys with Unique Identifier

Lecture 6: Output Clause For Insert Update Delete

Lecture 7: Structural Changes & Schema Modifications

Chapter 5: Sub Query & Table Expressions & Table Operators

Lecture 1: Sub Query & Correlated Sub Query & Exists

Lecture 2: Table Expressions & Derived Table & Common Type Expressions

Lecture 3: Cross Apply & Outer Apply Operators

Lecture 4: Pivot Operator

Lecture 5: Unpivot Operator

Chapter 6: Temp Tables & Temporal Tables

Lecture 1: Local & Global & Variable Temp Tables

Lecture 2: Temporal Table with History Management

Chapter 7: Window Functions

Lecture 1: Ranking & Offset Window Functions

Lecture 2: Aggregate Window Functions

Chapter 8: Views & Synonyms

Lecture 1: Views & Encrypted Views & DML with Views

Lecture 2: Synonym & Synonym against Undefined Objects

Chapter 9: Functions & Stored Procedures

Lecture 1: Scalar UDF

Lecture 2: Inline Table UDF & Multi-Statement Table UDF

Lecture 3: Stored Procedure with Input-Output Parameters

Lecture 4: Stored Procedure with Branch Logic

Lecture 5: Stored Procedure with Dynamic SQL

Chapter 10: Triggers & Cursor

Lecture 1: DML Trigger with Instead Of & After Condition

Lecture 2: DDL Trigger on Server & Database Level

Lecture 3: Cursor & Fast Forward Cursor & While Loop

Chapter 11: Transactions

Lecture 1: System & User Transactions and Auto Commit Transactions

Lecture 2: Implicit Transactions with Xact Abort

Lecture 3: Explicit Transactions & Nested Level of Transactions

Lecture 4: Transactions with Custom Data Type & Stored Procedure

Lecture 5: Transactions with Multiple Save Points

Chapter 12: Transactions Isolation Levels

Lecture 1: Transactions Read Uncommitted Isolation & Dirty Read & Shared Exclusive Lock

Lecture 2: Transactions Read Committed & Repeatable Read Isolation & Non-Repeatable Read

Lecture 3: Transactions Serializable Isolation & Phantom Read

Lecture 4: Transactions Snapshot Isolation & Pessimistic Optimistic Isolation Level

Lecture 5: Transactions Read Committed Snapshot Isolation &Final Thought on Isolation Level

Chapter 13: Transactions Error Handling & Deadlocks

Lecture 1: Transactions Error Handling & Severity & Xact State & RaiseError & Try and Catch

Lecture 2: Transactions with Dead Lock & Extended Events

Chapter 14: Query Optimization

Lecture 1: Heap & Clustered Indexes & Pages with Physical Stats

Lecture 2: Clustered Indexes & Non Clustered Indexes & Differences

Lecture 3: Execution Plan Understanding & Indexed View

Lecture 4: Continue Execution Plan Understanding & Optimizing Multiple Joins

Lecture 5: Optimizing CPU Time & Logical and Physical Reads & Index & Statistics Defragment

Lecture 6: Searchable Argument in Predicates & Handling Overlapping Indexes on same columns

Lecture 7: In-Memory Tables & Native Stored Procedure & Live Performance Comparison

Chapter 15: More Learnings

Lecture 1: Merge Query Processing

Instructors

Raheel Ahmed
MCSE Certified Senior SQL / Data Ware House / SSIS Developer

Rating Distribution

1 stars: 0 votes

2 stars: 3 votes

3 stars: 1 votes

4 stars: 3 votes

5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!