watching now
3 Students

46 Lessons

Beginner

What You Will Learn?

  • Creating Database, Tables and Performing DML Operations
  • 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

Curriculum

7h 18m
Section 2: T-SQL Joins to query SQL Server
1:02:04
Inner Join
08:37
T-SQL with Inner Join and Group By Together
04:10
Practice Activity
Demonstration Scripts
Left Right Full Cross Joins
26:44
Self Join
17:17
Union UnionAll Intersect Except Operations
05:07
Section 3: Basic T-SQL
1:27:57
Demonstration Scripts
Aggregate Functions with SELECT Command
11:26
Group By Clause using Single and Multiple Columns
14:02
Difference Between WHERE and HAVING Clause
05:03
Practice Activity
Syntax of SELECT Command
02:08
Section 4: Working with Schema
27:22
What is Schema and its Importance
13:50
Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL
13:32
Section 5: SubQueries
1:03:11
Demonstration Scripts
Getting Started with first SubQuery Example
04:33
Common Interview Question on SubQuery
09:41
Joins Group by Derived table Subquery combined TSQL
09:19
SubQuery as a Column
07:11
SubQuery using NOT IN
03:17
ALL ANY SOME Keywords in SubQuery
07:46
Correlated SubQuery
13:27
Not Exists Keyword Scenario of Correlated SubQuery to speed up query performance
07:52
Section 6: DataTypes
50:49
Demonstration Scripts
Datatypes
27:32
Datatype Conversion Implicit & Explicit -Type Casting
23:12
Section 7: DML Operations and Contraints
43:41
Demonstration Scripts
Many Different Options while performing insert update and delete operations
19:58
Primary Key, Foreign Key, Unique, Not NULL, Default, Check Constraints
23:38
Section 8: Joining more than two tables
24:03
Demonstration Scripts
Joining three tables
11:14
Joining four Tables
06:07
One more example in joining four tables
06:37
Section 9: Working with CASE Statements and Inbuilt Functions
38:27
Demonstration Scripts
Performing Select and Update operation using case statement
09:48
Explaining WHILE Loop in T-SQL
02:33
InBuilt Functions - EOMONTH,IIF, CHOOSE,DatePart,String Functions etc
26:01

Description

Requirements

  • No prior knowledge required

About the Instructor

Reviews 0
Students 0
Courses 2

I am a 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

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo