Introduction To Course

Database and Relational Database

Understanding Interface

Types of SQL Commands – DDL,DML,DQL,DCL,TCL

Creating, Altering, Deleting Database

Create Table by Importing Data

Creating, Altering, Deleting Table

Procedural, Declarative Integrity Constraints

Using Not Null, Unique, Default and Check, Index Constraints

Primary Key And Referential Integrity or Foreign Key Constraints

Data Types In SQL

Using Data Types In SQL

Insert Command

Computed Columns

Select Query, Select With Where Claus

OPERATORS, BETWEEN, AND, IN, LIKE, IS NULL

Order By Clause, Distinct Keyword

Aliases

Group By

Aggregate & Scalar Functions

Super Aggregate Functions

Having Clauses

Over (Partition By …) Clause

Ranking Functions

Union, Intersect, Except

Inner Join – Equi, Natural, Theta

Self Join & Cross Join

Outer Join – Left, Right, Full

What Are Sub Queries

Single Row & Multi-Row Sub-Query

Any or Some, ALL

Co-Related Sub-Queries

Exists and Non-Exists

Clustered Index, Non-Clustered Index

Create, Alter and Drop Indexes

What Are Views And Its Purpose

Creating, Altering and Dropping Views

Simple and Complex Views

Encryption and Schema Binding Options in creating views

Login Creation- SQL Server Login, Windows Authentication Login

User Creation-Granting and Revoking permissions & Roles

Find Duplicates

20 Queries