Browse Library

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

12 days left at this price!
$25 $55 55% off
30 days money back guarantee
$25
It Includes
  • Get access to this course only
  • Lifetime Course Access
  • Play & Pause Videos
  • Get Certificate of Completion
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Download Course for Offline Viewing
  • Inlcudes Real Projects
  • Free Instructor Support
  • 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
  • How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • 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 certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

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

infinite-scroll-project-ajax-mysql-api-php-jquery

Infinite Scroll Project AJAX MySQL ...

By : Laurence Svekis

Lecture 19

learn-to-build-sql-query-ultimate-sql-and-database-concepts

Learn to Build SQL Query Ultimate S...

By : Jazeb Akram

Lecture 24

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

SQL Server 101 : Microsoft SQL Serv...

By : Rashid Khan

Lecture 44

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