What is a Data?
What is a Database?

DBMS

The Table family
ACID Properties
CODD Rules
SQL – A database language
SQL Syntax
SQL Query – Order of execution
Microsoft SQL Server
System databases and Meta data
SQL Server Management Studio(SSMS) – The SQL Server UI
Installing Adventureworks database
Required Databases to be created before starting SQL journey with me
SELECT Distinct
The TOP Clause
The Alias
Where Clause
Order by

Keys

Data types

Operators

Constraints

Wildcards

NULL

4 partnaming

Derived Table

Computed Column

Order of execution

INSERT

UPDATE

DELETE

SELECT

CREATE

ALTER

DROP

GRANT

REVOKE

COMMIT

ROLLBACK

SAVEPOINT

Inner join or Equi join

Outer Join

Cross join

correlated sub query

noncorrelated sub query

UNION [DISTINCT]

UNION ALL

EXCEPT [DISTINCT]

EXCEPT ALL

INTERSECT [DISTINCT]

INTERSECT ALL

AVG

CHECKSUM_AGG

COUNT

COUNT_BIG

GROUPING

GROUPING_ID

MAX

MIN

STDEV

STDEVP

SUM

VAR

VARP

ASCII (Transact-SQL)

CHAR (Transact-SQL)

CHARINDEX (Transact-SQL)

CONCAT (Transact-SQL)

DIFFERENCE (Transact-SQL)

FORMAT (Transact-SQL)

LEFT (Transact-SQL)

LEN (Transact-SQL)

LOWER (Transact-SQL)

LTRIM (Transact-SQL)

NCHAR (Transact-SQL)

PATINDEX (Transact-SQL)

QUOTENAME (Transact-SQL)

REPLACE (Transact-SQL)

REPLICATE (Transact-SQL)

REVERSE (Transact-SQL)

RIGHT (Transact-SQL)

RTRIM (Transact-SQL)

SOUNDEX (Transact-SQL)

SPACE (Transact-SQL)

STR (Transact-SQL)

STUFF (Transact-SQL)

SUBSTRING (Transact-SQL)

UNICODE (Transact-SQL)

UPPER (Transact-SQL)

@@DATEFIRST (Transact-SQL)

CURRENT_TIMESTAMP (Transact-SQL)

DATEADD (Transact-SQL)

DATEDIFF (Transact-SQL)

DATEFROMPARTS (Transact-SQL)

DATENAME (Transact-SQL)

DATEPART (Transact-SQL)

DATETIME2FROMPARTS (Transact-SQL)

DATETIMEFROMPARTS (Transact-SQL)

DATETIMEOFFSETFROMPARTS (Transact-SQL)

DAY (Transact-SQL)

EOMONTH (Transact-SQL)

GETDATE (Transact-SQL)

GETUTCDATE (Transact-SQL)

ISDATE (Transact-SQL)

MONTH (Transact-SQL)

SMALLDATETIMEFROMPARTS (Transact-SQL)

SWITCHOFFSET (Transact-SQL)

SYSDATETIME (Transact-SQL)

SYSDATETIMEOFFSET (Transact-SQL)

SYSUTCDATETIME (Transact-SQL)

TIMEFROMPARTS (Transact-SQL)

TODATETIMEOFFSET (Transact-SQL)

YEAR (Transact-SQL)

CAST()

CONVERT()

$PARTITION (Transact-SQL)

@@ERROR (Transact-SQL)

@@IDENTITY (Transact-SQL)

@@PACK_RECEIVED (Transact-SQL)

@@ROWCOUNT (Transact-SQL)

@@TRANCOUNT (Transact-SQL)

BINARY_CHECKSUM (Transact-SQL)

CHECKSUM (Transact-SQL)

CONNECTIONPROPERTY (Transact-SQL)

CONTEXT_INFO (Transact-SQL)

CURRENT_REQUEST_ID (Transact-SQL)

ERROR_LINE (Transact-SQL)

ERROR_MESSAGE (Transact-SQL)

ERROR_NUMBER (Transact-SQL)

ERROR_PROCEDURE (Transact-SQL)

ERROR_SEVERITY (Transact-SQL)

ERROR_STATE (Transact-SQL)

FORMATMESSAGE (Transact-SQL)

GETANSINULL (Transact-SQL)

GET_FILESTREAM_TRANSACTION_CONTEXT (Transact-SQL)

HOST_ID (Transact-SQL)

HOST_NAME (Transact-SQL)

ISNULL (Transact-SQL)

ISNUMERIC (Transact-SQL)

MIN_ACTIVE_ROWVERSION (Transact-SQL)

NEWID (Transact-SQL)

NEWSEQUENTIALID() (Transact-SQL)

ROWCOUNT_BIG (Transact-SQL)

XACT_STATE (Transact-SQL)

ABS (Transact-SQL)

ACOS (Transact-SQL)

ASIN (Transact-SQL)

ATAN (Transact-SQL)

ATN2 (Transact-SQL)

CEILING (Transact-SQL)

COS (Transact-SQL)

COT (Transact-SQL)

DEGREES (Transact-SQL)

EXP (Transact-SQL)

FLOOR (Transact-SQL)

LOG (Transact-SQL)

LOG10 (Transact-SQL)

PI (Transact-SQL)

POWER (Transact-SQL)

RADIANS (Transact-SQL)

RAND (Transact-SQL)

ROUND (Transact-SQL)

SIGN (Transact-SQL)

SIN (Transact-SQL)

SQRT (Transact-SQL)

SQUARE (Transact-SQL)

TAN (Transact-SQL)

Rank()

Dense Rank()

Row Number()

NTILE()

OPENDATASOURCE

OPENQUERY

OPENROWSET

OPENXML

Group by

Rename

case

Schema

Normalization

Temp tables

Table parameters

Cte

Views

Sps

Triggers

Indexes

UDTs

Udfs

Transactions

Try catch

Cursor

Tuning