Amitesh Sri

Years of Experience in SQL Server Training

12

Years of Experience in SQL Programming Training

12

Teaching Experience in detail in SQL Programming Training

. Study Material . Real Time Examples . Example Case Studies . 24*7 availability to clarify doubts . Resume Preparation . Interview Questions with detailed answers . Sample Projects for each module

Years of Experience in MS SQL Integration Training

11

Teaching Experience in detail in MS SQL Integration Training

I have been a professional trainer for ORACLE and SQL Server in many IT Institute like DUCAT, and High Technology Solutions

Years of Experience in Data Warehouse Training

11

Teaching Experience in detail in Data Warehouse Training

.Data Warehouse Modeling .Dimension Facts creation .Creating new MOLAP , ROLAP, HOLAP structure . Detail discussion o storage mechanism . Creating Calculation , MDX Queries, and expressions . Cube deployment . Processing with different approaches . MDX Query basics writing and optimization . Data Mining . Real time troubleshooting . Discussion of real time problems and solutions.

Years of Experience in SSAS Training

10

Teaching Experience in detail in SSAS Training

Data Warehousing Concepts Why we need Data warehouse Data Warehousing Architecture Cube Designing Partitioning Cube MDX Queries and Functions Cube Optimization SSAS KPIs and Functions KPIs and Actions XMLA - Security Management SSAS Storage Models Data Mining Techniques Discussing real time problems etc.

Years of Experience in MS SQL Reporting Training

10

Teaching Experience in detail in MS SQL Reporting Training

Key Features of Training: . Study Material . Real Time Examples . Example Case Studies . Resume Preparation . Interview Questions with detailed answers . Sample Projects for each module.

Years of Experience in Database Training classes

11

Teaching Experience in detail in Database Training classes

Taking DATABASE classes for last 10 or more years. I completely deals in particle scenario and real tie problems. the topics i covers in my Database classes are as mentioned bellow: SQL Server Architecture Database Designing Techniques Database creation DML, DTL and TCL Statements INSERT, UPDATE DELETE Commands Isolations and Locks Analytical functions ALTER statements and its variations JOINS and its types CTE and CTE iteration Stored Procedures Functions Triggers and its Type Cursor and its Types Error handling Sub Query and Co related Queries Using Allies and Sub Queries Temporary table Derived tables Creating Users and Schemas Data security and Views Brief of DBA Activities Briefing of Complete Course