1.SQL
a) SQL Intro
- What is RDBMS
- What is SQL
- What is a Database
- what is a Schema
- What is Table
- What are Datatype
- Types – DDL,DML,DCL-
- What are tables
- constraints on table : Primary Key, foreign key, unique key,not null
- Auto Increment
- What is a relation
- Sql Syntaxes : Select, insert, update and delete
- Data types and Type casting
- Sorting Data – Order by
- Filtering data – Where condition
- Distinct Data
- Limiting Data
- Top n rows
- Aliases (column and Table aliases)
2. SQL Operations
- Operators
- Aliases
- Case statement
- Datetime conversions
- String functions
- Aggregations : AVG,COUNT,MIN,MAX,SUM
- Group by
- Having
- Where vs Having
- Subqueries
- Corelated sub queries
3. SQL Scripting
- Indexes : Clustered and non-clustred
- What is View
- Variables declaration
- If, and While loop
- Print statement
- Stored Procedures : calling and creating stored procedures
- Functions:
- Scalar, Tabular functions
- Using functions in queries
- Using Functions in Stored Procedures
- Using Stored Procedures in Functions
- Triggers
- Transactions
- Merge Statements
- Unwrapping Large queries
4. Advanced SQL
- Operations between two tables
- EXISTS and NOT EXISTS
- Window Functions
- Group by Vs Partition by
- CTE example
- Pivot and Unpivot example
- Merge
- Temp Tables
