Home » SQL Basics Concepts

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

Create Database

Attach SQL Database

Detach SQL Database

SQL SERVER Data Types

VARCHAR

NVARCHAR

CHAR

NCHAR

SQL DDL (Data Definition Language) 

SQL Create table

SQL Alter 

SQL Drop

SQL Truncate

SQL DML (Data Manipulation Language)

SQL Insert

SQL Update

SQL Delete

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 Case Statement

SQL Temporary/Temp table

SQL Server Computed Columns

SQL Operators

SQL 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  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()

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()

SQL Aggregate Functions

SUM()

MAX()

MIN()

AVG()

COUNT()




SQL Analytics Functions

LEAD()

LAG()

FIRST_VALUE()

LAST_VALUE()

SQL Mathematical Functions 

CEILING()

FLOOR()

ROUND()




SQL Server Advance