SQL Server 2016, 2012, 2014, 2017, 2019, SQL Server Performance Tuning, Database, Data Analytics, Mastering SQL Server
Either you’re 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
You’ll 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
You should have basic understanding to operate the computer OR laptop
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
