Beginning T-SQL for SQL Server Developer, Data Analyst & DBA

Step By Step Practical Training on Programming Transact SQL Query from basics on Microsoft SQL Server Database Engine

Instructed by Vikas Munjal

  • Includes all Standard Features
  • Get Unlimited access to all the courses
  • No Contract. Cancel Anytime
Starting in just $19 / mo see all plans
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
  • Basic T-SQL - SELECT , WHERE , GROUP BY ,HAVING, BETWEEN , LIKE etc
  • Joins - Inner Left Right Full & Cross
  • Schema
  • SubQueries
  • DataTypes
  • Implicit and Explicit Conversion
  • CASE Statements
  • Joining more than two tables
  • InBuilt Functions

This course starts from the beginning , no prior knowledge is needed and it is step By step Practical Training on Programming Transact SQL Query from basics on Microsoft SQL Server Database Engine

This course is must for all the Aspirants who want to become Microsoft SQL Server Database Developers , Microsoft Database Administrator, Web Developers such as .NET Developers,Database ANALYSTS , Report Developers such as SSRS or ETL Developers such as SSIS etc

 

Following are the course contents which are covered in this course T-SQL Online SQL Server Video Step By Step Training

 

Introduction

What is a Relational Database

What is Relational Database Management System

SSMS and SQL Server Database Engine

SQL Server and SSMS Installation

 

Basic T-SQL

Creating DB Tables & Inserting Data into the tables

Primary Key and Foreign Key

Basic Select Commands

Aggregate Functions with SELECT Command

Group By Clause using Single and Multiple Columns

Difference Between WHERE and HAVING Clause

Syntax of SELECT Command

 

T-SQL Joins to query SQL Server

Inner Join

T-SQL with Inner Join and Group By Together

Left Join

Right Join

Full Join

Cross Join

Self-Join

Union Operation

Union All Operation

Intersect Operation

Except Operation

 

Working with Schema

What is Schema and its Importance

Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL

 

Subqueries

Getting Started with first Subquery Example

Common Interview Question on Subquery

Joins Group by Derived table Subquery combined TSQL

Subquery as a Column

Subquery using NOT Exists

ALL ANY SOME Keywords in Subquery

Correlated Subquery

Not Exists Keyword Scenario of Correlated Subquery to speed up query performance

 

Datatypes

Datatype Conversion

Implicit & Explicit Conversion (Type Casting)

 

DML Operations and Constraints

Many Different Options while performing insert update and delete operations

Primary Key, Foreign Key, Unique, Not NULL, Default, Check Constraints

 

Joining more than two tables

Joining three tables

Joining four Tables

One more example in joining four tables

 

Working with CASE Statements and Inbuilt Functions

Performing Select and Update operation using case statement

WHILE Loop

Inbuilt Functions - EOMONTH, IIF, CHOOSE, DatePart, String Functions etc.

  • The course starts right from the scratch which also tells about software installation. One can go through free preview videos for better understanding
  • Beginner Developers, DBAs or Data Analysts curious about querying on Microsoft SQL Server Database Engine
View More...

Section 1 : Introduction

  • Lecture 1 :
  • Course Contents Covered in this Course Preview
  • Lecture 2 :
  • What is a Relational Database
  • Lecture 3 :
  • What is Relational Database Mananagement System
  • Lecture 4 :
  • SSMS and SQL Server Database Engine
  • Lecture 5 :
  • SQL Server and SSMS Installation

Section 2 : Basic T-SQL

  • Lecture 1 :
  • Creating DB Tables & Inserting Data into the tables
  • Lecture 2 :
  • Primary Key and Foreign Key
  • Lecture 3 :
  • Demonstration Scripts
  • Please download the demo scripts which will be used in the next coming videos
  • Lecture 4 :
  • Basic Select Commands
  • Lecture 5 :
  • Aggregate Functions with SELECT Command
  • Lecture 6 :
  • Group By Clause using Single and Multiple Columns
  • Lecture 7 :
  • Difference Between WHERE and HAVING Clause
  • Lecture 8 :
  • Practice Activity
  • Please download the zip file and extract it and solve the assignment
  • Lecture 9 :
  • Syntax of SELECT Command

Section 3 : T-SQL Joins to query SQL Server

  • Lecture 1 :
  • Inner Join
  • Lecture 2 :
  • T-SQL with Inner Join and Group By Together
  • Lecture 3 :
  • Practice Activity
  • Please download the zip file and extract it and solve the assignment
  • Lecture 4 :
  • Demonstration Scripts
  • Please download and extract the demo scripts which will be used in the next coming videos
  • Lecture 5 :
  • Left Right Full Cross Joins
  • Lecture 6 :
  • Self Join
  • Lecture 7 :
  • Union UnionAll Intersect Except Operations

Section 4 : Working with Schema

  • Lecture 1 :
  • Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL
  • Lecture 2 :
  • What is Schema and its Importance

Section 5 : SubQueries

  • Lecture 1 :
  • Demonstration Scripts
  • Please download and extract the demo scripts which will be used in the next coming videos
  • Lecture 2 :
  • Getting Started with first SubQuery Example
  • Lecture 3 :
  • Common Interview Question on SubQuery
  • Lecture 4 :
  • Joins Group by Derived table Subquery combined TSQL
  • Lecture 5 :
  • SubQuery as a Column
  • Lecture 6 :
  • SubQuery using NOT IN
  • Lecture 7 :
  • ALL ANY SOME Keywords in SubQuery
  • Lecture 8 :
  • Correlated SubQuery
  • Lecture 9 :
  • Not Exists Keyword Scenario of Correlated SubQuery to speed up query performance

Section 6 : DataTypes

  • Lecture 1 :
  • Demonstration Scripts
  • Please download and extract the demo scripts which will be used in the next coming videos
  • Lecture 2 :
  • Datatypes
  • Lecture 3 :
  • Datatype Conversion Implicit & Explicit -Type Casting

Section 7 : DML Operations and Contraints

  • Lecture 1 :
  • Demonstration Scripts
  • Please download and extract the demo scripts which will be used in the next coming videos
  • Lecture 2 :
  • Many Different Options while performing insert update and delete operations
  • Lecture 3 :
  • Primary Key, Foreign Key, Unique, Not NULL, Default, Check Constraints

Section 8 : Joining more than two tables

  • Lecture 1 :
  • Demonstration Scripts
  • Please download and extract the demo scripts which will be used in the next coming videos
  • Lecture 2 :
  • Joining three tables
  • Lecture 3 :
  • Joining four Tables
  • Lecture 4 :
  • One more examples in joining four tables

Section 9 : Working with CASE Statements and Inbuilt Functions

  • Lecture 1 :
  • Demonstration Scripts
  • Please download and extract the demo scripts which will be used in the next coming videos
  • Lecture 2 :
  • Performing Select and Update operation using case statement
  • Lecture 3 :
  • Explaining WHILE Loop in T-SQL
  • Lecture 4 :
  • InBuilt Functions - EOMONTH,IIF, CHOOSE,DatePart,String Functions etc

Vikas Munjal,

I am Microsoft Certified Trainer. Having more than 11 Years of rich experience.Successfully self-employed, i am a trusted consultant for businesses large and small. Currently working as a Corporate Trainer & Consultant for SQL Server and Microsoft Business Intelligence . Also worked as a SQL Server Developer. Lives in Delhi,India. My style is to teach in such a way so that student should be able to create images or diagrams of the concept in his/her mind . Because i believe we understand , remember and learn all the things in pictures , diagrams or images . This is the science of learning. My Microsoft Certifications are: Microsoft Certified Solution Expert Data Platform Microsoft Certified Solution Expert Business Intelligence Microsoft Certified Solution Expert Data Management and Analytics Microsoft Certified Solution Associate SQL Server 2012/2014 Microsoft Certified Trainer Microsoft Certified Professional
View More...
learn-to-build-sql-query-ultimate-sql-and-database-concepts

Learn to Build SQL Query Ultimate S...

By : Jazeb Akram

Lecture 24

sql-server-tutorial

SQL Server tutorial

By : Shivprasad Koirala

Lecture 22

sql-server-101-microsoft-sql-server-for-absolute-beginners

SQL Server 101 : Microsoft SQL Serv...

By : Rashid Khan

Lecture 44

sql-for-newcomers-the-full-mastery-course

SQL for Newcomers - The Full Master...

By : Sameh Sharaf

Lecture 122

data-warehouse-etl-testing-data-quality-management-a-z

Data Warehouse ETL Testing & Data Q...

By : Lorenz De Smedt

Lecture 20

sql-server-programming

SQL Server Programming

By : Arunprakash P V

Lecture 12

Buy

$15

Enjoy Limitless Learning. Get Access to Unlimited Courses with Premium Subscrption Subscribe Now

Sign up and start learning
By signing up. you agree to our Terms of Use and Privacy Policy
Forget Password