UrbanPro
true

Overview

I am an IT professional work with one of the top most IT MNC. I have 9 + years of experience in Database and MSBI technology utilizing ORACLE, Microsoft SQL Server Database and Microsoft Business Intelligent ( MSBI) Tools. Teaching is my passion.

Apart form the training i am also happy to help you with best of my knowledge on real time database and MSBI related issues. This help has no charge and i love to do this. You can call me on my Number during day time. If i am free will surely try to help you. This is my step towards the inspiration from the thought that "What can give - Dr A. P. J Abdul Kalam"

Languages Spoken

Hindi

English

Education

Ignou 2007

Master of Computer Applications (M.C.A.)

Address

DLF City Phase 3, Gurgaon, India - 122002

Verified Info

Phone Verified

Email Verified

Facebook Verified

Report this Profile

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Teaches

SQL Server Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SQL Server Training

12

SQL Programming Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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

MS SQL Integration Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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

Data Warehouse Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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.

SSAS Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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.

MS SQL Reporting Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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.

Database Training classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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

Reviews

No Reviews yet!

FAQs

1. Which classes do you teach?

I teach Data Warehouse, Database Training, MS SQL Integration, MS SQL Reporting, SQL Programming, SQL Server and SSAS Classes.

2. Do you provide a demo class?

Yes, I provide a free demo class.

3. How many years of experience do you have?

I have been teaching for 12 years.

Answers by Amitesh Sri (7)

Answered on 14/08/2017 Learn IT Courses/SQL Programming

First you need to identify what causes the server.. 1)is it network/server is down 2) your password is not correct 3) database you are trying to access in not allowed 4) Firewall issue to access SQL Server service 5)SQL Instance is down
Answers 1 Comments
Dislike Bookmark

Answered on 14/08/2017 Learn IT Courses/SQL Programming

Try to Install "SQL Server Data tools" package from Microsoft website
Answers 1 Comments
Dislike Bookmark

Answered on 14/08/2017 Learn IT Courses/SQL Programming

For any custom Audit you may create BEFORE/AFTER trigger on that particular table to capture changes ...
Answers 1 Comments
Dislike Bookmark

Answered on 14/08/2017 Learn IT Courses/SQL Programming

in SQL query you can loop through CTE ( conman table expression) In T-SQL batch you can use While loop
Answers 1 Comments
Dislike Bookmark

Answered on 14/08/2017 Learn IT Courses/SQL Programming

Try to understand database internals ... some DBAs nativities... > Storage and retrieving mechanism in detail . > Disaster recovery plans > Indexes in more depth > Recovery Models Any many more
Answers 1 Comments
Dislike Bookmark

Teaches

SQL Server Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SQL Server Training

12

SQL Programming Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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

MS SQL Integration Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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

Data Warehouse Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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.

SSAS Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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.

MS SQL Reporting Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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.

Database Training classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

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

No Reviews yet!

Answers by Amitesh Sri (7)

Answered on 14/08/2017 Learn IT Courses/SQL Programming

First you need to identify what causes the server.. 1)is it network/server is down 2) your password is not correct 3) database you are trying to access in not allowed 4) Firewall issue to access SQL Server service 5)SQL Instance is down
Answers 1 Comments
Dislike Bookmark

Answered on 14/08/2017 Learn IT Courses/SQL Programming

Try to Install "SQL Server Data tools" package from Microsoft website
Answers 1 Comments
Dislike Bookmark

Answered on 14/08/2017 Learn IT Courses/SQL Programming

For any custom Audit you may create BEFORE/AFTER trigger on that particular table to capture changes ...
Answers 1 Comments
Dislike Bookmark

Answered on 14/08/2017 Learn IT Courses/SQL Programming

in SQL query you can loop through CTE ( conman table expression) In T-SQL batch you can use While loop
Answers 1 Comments
Dislike Bookmark

Answered on 14/08/2017 Learn IT Courses/SQL Programming

Try to understand database internals ... some DBAs nativities... > Storage and retrieving mechanism in detail . > Disaster recovery plans > Indexes in more depth > Recovery Models Any many more
Answers 1 Comments
Dislike Bookmark

Contact

Load More

Amitesh Sri describes himself as SQL Server Database Trainer. He conducts classes in Data Warehouse, Database Training and MS SQL Integration. Amitesh is located in DLF City Phase 3, Gurgaon. Amitesh takes Regular Classes- at his Home. He has 12 years of teaching experience . Amitesh has completed Master of Computer Applications (M.C.A.) from Ignou in 2007. HeĀ is well versed in Hindi and English.

X
X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Amitesh Sri

Let Amitesh Sri know you are interested in their class

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more