Introduction
  • Course Topics
  • How to use udemy
Basics Of DBMS
  • Introduction To This Module
  • What is Data ?
  • What is Database? & How To Design A Simple Database ?
  • Why We Need A DBMS Software ?
  • What Is The Use SQL Scripting Language ?
  • Summary Of This Module
How To Install SQL Server
  • Different SQL Server Installation Options (Cloud and On Premise)
  • Install SQL Server
  • Install SQL Server Management Studio
  • Connect To SQL Server by Using SQL Server management Studio
  • Create Free Azure Account
  • Create Azure SQL Server DB
  • Connect To Azure SQL Server DB From SSMS
  • Delete Azure SQL Data Base
Design Your First Database
  • Introduction To Designing A Database
  • Create A Databse
  • Create Tables Inside A Database
  • Insert Data Into A Tables
  • Insert Data Into A Tables Part 2
  • Retrieve Saved Data From A Database
  • Retrieve Saved Data From A Database Part 2
  • Update Records Saved in A Table
  • Remove Data From A Table
  • Remove Tables From A Database
  • Summary Of This Module
Task 1: Check Your Understanding
  • Task 1
  • Solution For Task 1: Part 1
  • Solution For Task 1: Part 2
  • Solution For Task 1: Part 3
  • Solution For Task 1: Part 4
  • Solution For Task 1: Part 5
  • Solution For Task 1: Part 6
  • Solution For Task 1: Part 7
  • Solution For Task 1: Part 8
Types OF SQL Statements
  • Interview Question: Different Types Of SQL Statements
Fundamentals Of DQL Statements
  • Basics Of SQL Select Statement & Derive New Data
  • Literal Select Statement
  • Select Distinct Data From A Table
  • Select Specific Data With Where Conditions
  • How To Use In Operate In SQL Where Condition
  • How To Use Between Operator In SQL Where Condition
  • How To Retrieve Null Values Using SQL Where Conditions
  • How To Select Values From A Table That Are Not Equal To Some Values
  • How To Use Like Operator In Where Clause
  • Sort Data By Using Order By
  • How To Use The SQL Server OFFSET FETCH Clauses To Limit The Number Of Rows ?
Introduction To SQL Constrains
  • What Is Constrain? How To Use It ? When We Need SQL Constrains ?
  • Use Of Not Null Constrains
  • How To Use Unique Constrains Part 1
  • How To Use Unique Constrains Part 2
  • How To Use Check Constraint In SQL Server?
  • How To Use Default Constrains In SQL Server
  • Use Of Primary Key In SQL Server
  • Use IDENTITY Keyword To Perform An Auto-Increment Feature With Primary Key
  • SQL FOREIGN KEY Constraint (Used To Link Two Tables Together)
Aggregate Function In SQL Server
  • Aggregate Functions Like Min, Max, Sum, Avg and Count in Select With Group By
Join In SQL
  • What Is SQL Join and Different Types Of Join
  • Inner Join
  • Outer Joins (Full / Left & Right Joins in SQL)
Union and Union All
  • How To Use Union to Combine Data from Multiple Tables
Introduction To Stored Procedure In SQL Server
  • Use Stored Procedure To Save Your Code And Reuse Old code
  • Use Single and Multiple Parameters With Stored Procedure
String Functions In SQL Server
  • SQL Server String Functions
  • Ascii Vs Char String Functions
  • Lower & Upper String Functions
  • Left & Right String Functions In SQL
  • Ltrim & Rtrim String Functions
  • Replace and Reverse String Functions
  • Substring & Charindex Functions
Interview Questions :: Short Answer
  • Question 1 and Answer
  • Question 2 and Answer
  • Question 3 and Answer
Common SQL Interview Questions And Answers
  • First Set of Questions And Answers
  • Question 1 and Answer
  • Question 2 and Answer
  • Question 3 and Answer
  • Question 4 and Answer
  • Question 5 and Answer
  • Question 6 and Answer
  • Question 7 and Answer
  • Question 8 and Answer
  • Question 9 and Answer
  • Question 10 and Answer