All in One Offer! | Access Unlimited Courses in any category starting at just $29. Signup today. Offer Ends in: 5 Days!

Browse Library

Get Unlimited Learning Access
$29
5 days left at this price!
30-Day Money-Back Guarantee

It Includes

  • Get Full Access to the platform
  • Access to 16000+ online courses
  • Play & Pause Course Viewing
  • Attend weekly live webinar
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Assignments & Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Cancel Anytime
$29
  • 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 5 Lectures 00:40:25

    • 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 9 Lectures 01:27:47

    • 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 7 Lectures 01:01:52

    • 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 2 Lectures 00:13:50

    • 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 9 Lectures 01:03:01

    • 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 3 Lectures 00:50:42

    • 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 3 Lectures 00:43:36

    • 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 4 Lectures 00:23:57

    • 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 4 Lectures 00:38:19

    • 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
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

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...
  • managing-sql-business-intelligence-operations

    Managing SQL Business Intelligence ...

    By : Microsoft

    Lecture 7 Intermediate Level 0:0:0
  • infinite-scroll-project-ajax-mysql-api-php-jquery

    Infinite Scroll Project AJAX MySQL ...

    By : Laurence Svekis

    Lecture 19 Beginner Level 1:26:34
  • learn-to-build-sql-query-ultimate-sql-and-database-concepts

    Learn to Build SQL Query Ultimate S...

    By : Jazeb Akram

    Lecture 24 Beginner Level 2:11:45
  • sql-server-101-microsoft-sql-server-for-absolute-beginners

    SQL Server 101 : Microsoft SQL Serv...

    By : Rashid Khan

    Lecture 44 Beginner Level 3:47:42
Signup & Continue Checkout
By signing up, you agree to our Terms of Use and Privacy Policy
Create New Password
Enter your email address and we'll send you a link to reset your password.