SQL Basics Concepts

SQL Server Basics Concepts includes SQL Database, Tables, SQL DML, and DDL Commands, Joins, Key Constraints, Functions and so on..

Getting started with SQL basics

SQL

SQL DDL, DML, DCL and TCL commands

Create Database

Attach SQL Database

Detach SQL Database

SQL SERVER Data Types

VARCHAR

NVARCHAR

CHAR

NCHAR

DATE

SQL DDL (Data Definition Language) 

SQL Create table

SQL Alter 

SQL Drop

SQL Truncate

SQL DML (Data Manipulation Language)

SQL Insert

SQL Update

          Update from select statement

SQL Delete

SQL DELETE TOP

SQL  SELECT Queries

SQL Select

SQL Select Into Select

SQL Insert Into Select

SQL Order By

SQL Group By

SQL Having

SQL Over Clause

SQL Distinct

SQL Where

SQL TOP

SQL Case Statement

SQL Temporary/Temp table

SQL Server Computed Columns

SQL Table Value Constructor

SQL IS NULL

SQL IS NOT NULL

SQL NULLIF

SQL Operators

SQL Exists Operator

SQL NOT EXISTS Operator

SQL Between Operator

SQL Like Clause

SQL Intersect

SQL Except

SQL Union

SQL Union ALL 

SQL Constraints

SQL Primary Key

SQL Composite Key

SQL Foreign key

Cascading referential integrity in Foreign Key

SQL Server NOT NULL Constraint

SQL Default Constraint

SQL Unique Key

SQL Server Check Constraint

SQL Joins

SQL Join Overview

SQL Inner Join

SQL Left Join

SQL Right Join

SQL Full Join

SQL Cross Join

SQL Cross Apply VS Outer Apply

SQL Subquery

SQL Correlated Subquery

SQL  Functions

SQL System Functions

ISNUMERIC()

@@IDENTITY

NEWID()

NEWSEQUENTIALID()

@@ERROR

ISNULL()

SQL Ranking/Window Functions

SQL ROW_NUMBER()

SQL RANK()

DENSE_RANK()

SQL Conversion Functions

TRY_CAST()

PARSE Function

SQL Logical Functions 

IIF ()

CHOOSE()

SQL Date Functions

DATEPART()

DATEDIFF()

GETDATE()

CURRENT_TIMESTAMP()

EOMONTH()

DATEADD()

DATEFROMPARTS()

DATENAME()

                  Date and Time Conversions in SQL Server using Convert function

SQL String Functions

CHARINDEX()

LEN()

DATALENGTH()

SUBSTRING()

REPLACE()

REPLICATE()

UPPER()

LOWER()

TRIM()

LRTIM()

RTIM()

SPACE()

TRANSLATE()

STUFF()

SQL COALESCE()

STRING_SPLIT()

CONCAT_WS()

REVERSE()

FORMAT()

STRING_AGG()

PATINDEX()

QUOTENAME()

SQL Aggregate Functions

SUM()

MAX()

MIN()

AVG()

COUNT()

SQL Analytics Functions

LEAD()

LAG()

FIRST_VALUE()

LAST_VALUE()

SQL Mathematical Functions 

CEILING()

FLOOR()

ROUND()

RAND()

SQL Server Advance