🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW
watching now
4 Students

Description

What Will You Learn?

  • What a relational database is
  • How to create databases and tables
  • How to use basic T-SQL commands and joins
  • What the T-SQL’s basic and advanced functionalities are

Requirements

  • Interest in database development
  • Microsoft SQL Server
  • SQL Server Management Studio
  • NFT Certificate
  • 46 Lessons
  • Beginner
  • English
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 7h 18min of content, in total.

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
Creating DB Tables & Inserting Data into tables
20:38
Primary Key and Foreign Key
09:41
Demonstration Scripts
Basic Select Commands
24:51
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

About the Instructor

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

See All Instructor Courses

BitDegree platform reviews