1.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
• Comparison Operators
• Logical Operators
• Aliases
• case statement
• Datetime conversions
• String functions
• Aggregations
• Subqueries
• Corelated sub queries
3.ADVANCED SQL
• Operations between two tables
• Inner join, outer joins
• Union and unionall
• EXISTS and NOT EXISTS
• Window FunctionsGroup by Vs Partition by
• CTE example
• Pivot and unpivot example
• Merge
• Temp Tables
4.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
5.SSIS
• What is BI
• SSIS and Datawarehousing introduction
• DWH fundamentals (OLTP,OLAP, Datamarts etc)
• Dimenstional Modelling (Facts, Dimensions, SCD, Surrogate Keys, Candidate Keys etc)
• Star and Snlowflake Schema
• Normalisation and Denormalisation
• What is ETL Tool., ETL vs ELT and SSDT introduction
• SSIS Architecture
• Connection Managers and Data Sources
• Aggregate, Data Conversion, Derived column, Character Map, Audit
• Transactions in SSIS
• Merge, Merge Join, Union All, Sort
• Multicast, Conditional Split, Oledb command
• Lookup, Fuzzy lookup, Copy column
• Pivot, Un pivot, Term Extract, Term Lookup
• Loops
• Different Dataflow components
• Transactional Processing
• SCD data loading
• Error Handling
• Using File System to move, copy, create folders
• Execute Sql for Single, Multi SQL, Procedure, functions with Various parameters and implementing DML, DDL
statements
• Working on Master, Child Packages using Execute Package task and variables
• Expression task for evaluations, iterations
• Precedence Constraints
• SCD (type 1,2 and 3 loading)
• CDC
• Package deployment using manifest file (File System, Sqlserver deployment)
• Project deployment using Catalog database (SSDB) and explaining various features
6.AZURE
• Cloud Introduction
• OnPrem Vs Cloud
• IAAS,SAAS and PAAS
• What is Azure
• Azure Accounts, Subscription and Tenant
• Services in Azure
• Azure Regions and Resource Manager
• Azure Storage
• Azure Compute
• Azure SQL
• Azure VM
• Azure Functions and Logic Apps
• Azure Databricks and Synapse Intro
