Mastering SQL Query With SQL Server

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Topics

Lecture 2: How to use udemy

Chapter 2: Basics Of DBMS

Lecture 1: Introduction To This Module

Lecture 2: What is Data ?

Lecture 3: What is Database? & How To Design A Simple Database ?

Lecture 4: Why We Need A DBMS Software ?

Lecture 5: What Is The Use SQL Scripting Language ?

Lecture 6: Summary Of This Module

Chapter 3: How To Install SQL Server (Laptop)

Lecture 1: Different SQL Server Installation Options (Cloud and On Premise)

Lecture 2: Install SQL Server

Lecture 3: Install SQL Server Management Studio

Lecture 4: Connect To SQL Server by Using SQL Server management Studio

Chapter 4: How To Use Azure SQL For SQL Server

Lecture 1: Create Free Azure Account

Lecture 2: SQL Server In Cloud (Azure)

Lecture 3: Create Azure SQL Server DB

Lecture 4: Connect To Azure SQL Server DB From SSMS

Lecture 5: Delete Azure SQL Data Base

Chapter 5: Design Your First Database

Lecture 1: Introduction To Designing A Database

Lecture 2: Create A Databse

Lecture 3: Create Tables Inside A Database

Lecture 4: Insert Data Into A Tables

Lecture 5: Insert Data Into A Tables Part 2

Lecture 6: Retrieve Saved Data From A Database

Lecture 7: Retrieve Saved Data From A Database Part 2

Lecture 8: Update Records Saved in A Table

Lecture 9: Remove Data From A Table

Lecture 10: Remove Tables From A Database

Lecture 11: Summary Of This Module

Chapter 6: Task 1: Check Your Understanding

Lecture 1: Task 1

Lecture 2: Solution For Task 1: Part 1

Lecture 3: Solution For Task 1: Part 2

Lecture 4: Solution For Task 1: Part 3

Lecture 5: Solution For Task 1: Part 4

Lecture 6: Solution For Task 1: Part 5

Lecture 7: Solution For Task 1: Part 6

Lecture 8: Solution For Task 1: Part 7

Lecture 9: Solution For Task 1: Part 8

Chapter 7: Types OF SQL Statements

Lecture 1: Interview Question: Different Types Of SQL Statements

Chapter 8: Fundamentals Of DQL Statements

Lecture 1: Basics Of SQL Select Statement & Derive New Data

Lecture 2: Literal Select Statement

Lecture 3: Select Distinct Data From A Table

Lecture 4: Select Specific Data With Where Conditions

Lecture 5: How To Use In Operate In SQL Where Condition

Lecture 6: How To Use Between Operator In SQL Where Condition

Lecture 7: How To Retrieve Null Values Using SQL Where Conditions

Lecture 8: How To Select Values From A Table That Are Not Equal To Some Values

Lecture 9: How To Use Like Operator In Where Clause

Lecture 10: Sort Data By Using Order By

Lecture 11: How To Use The SQL Server OFFSET FETCH Clauses To Limit The Number Of Rows ?

Chapter 9: Introduction To SQL Constrains

Lecture 1: What Is Constrain? How To Use It ? When We Need SQL Constrains ?

Lecture 2: Use Of Not Null Constrains

Lecture 3: How To Use Unique Constrains Part 1

Lecture 4: How To Use Unique Constrains Part 2

Lecture 5: How To Use Check Constraint In SQL Server?

Lecture 6: How To Use Default Constrains In SQL Server

Lecture 7: Use Of Primary Key In SQL Server

Lecture 8: Use IDENTITY Keyword To Perform An Auto-Increment Feature With Primary Key

Lecture 9: SQL FOREIGN KEY Constraint (Used To Link Two Tables Together)

Chapter 10: Aggregate Function In SQL Server

Lecture 1: Aggregate Functions Like Min, Max, Sum, Avg and Count in Select With Group By

Chapter 11: Join In SQL

Lecture 1: What Is SQL Join and Different Types Of Join

Lecture 2: Inner Join

Lecture 3: Outer Joins (Full / Left & Right Joins in SQL)

Chapter 12: Union and Union All

Lecture 1: How To Use Union to Combine Data from Multiple Tables

Chapter 13: Introduction To Stored Procedure In SQL Server

Lecture 1: Use Stored Procedure To Save Your Code And Reuse Old code

Lecture 2: Use Single and Multiple Parameters With Stored Procedure

Chapter 14: String Functions In SQL Server

Lecture 1: SQL Server String Functions

Lecture 2: Ascii Vs Char String Functions

Lecture 3: Lower & Upper String Functions

Lecture 4: Left & Right String Functions In SQL

Lecture 5: Ltrim & Rtrim String Functions

Lecture 6: Replace and Reverse String Functions

Lecture 7: Substring & Charindex Functions

Chapter 15: Building Globally Distributed Databases with Cosmos DB

Lecture 1: Introduction

Lecture 2: Create an Azure Cosmos DB database & Save Data Using Json

Lecture 3: Query Data in Your Azure Cosmos DB Database Using SQL

Chapter 16: Interview Questions :: Short Answer

Lecture 1: Question 1 and Answer

Lecture 2: Question 2 and Answer

Lecture 3: Question 3 and Answer

Chapter 17: Common SQL Interview Questions And Answers

Lecture 1: First Set of Questions And Answers

Lecture 2: Question 1 and Answer

Lecture 3: Question 2 and Answer

Lecture 4: Question 3 and Answer

Lecture 5: Question 4 and Answer