1.1. Introduction
     1.1.1. Database Study
     1.1.2. Database Design
     1.1.3. Implementation and loading
     1.1.4. Testing and evaluation
     1.1.5. Operation
     1.1.6. Maintenance and evolution

1.2.1. What are the roles of Database Analyst
1.2.2. Difference between Business Analyst and Database Analyst

1.3.1. What Is a Data Warehouse?
1.3.2. Data Mart
1.3.3. Operational Data Stores
1.3.4. Characteristics of a Data Warehouse
1.3.5. Differences between Database and Data warehouse and Data Mart and ODS
1.3.6. OLTP Vs OLAP Vs DataMart Vs ODS
1.3.7. Uses and benefits of an ODS
1.3.8. ODS and Data Warehouse Design
1.3.9. OLTP v/s OLAP     
1.3.10. Data Warehouse Architecture

1.4.1. Conceptual
1.4.2. Logical
1.4.3. Physical

• ETL

1.6.1. Anamolies
1.6.2. 1st Normal Form
1.6.3. 2nd Normal Form
1.6.4. 3rd Normal Form

1.7.1. 5 Challenges of Working with Subject Matter Experts
1.7.2. Easy tips to work with the SMEs

• Data profiling, Data cleansing

2.1. Evolution of the Database

2.2.1. Create table
2.2.2. Truncate
2.2.3. Drop Table

2.3.1. Insert
2.3.2. Update
2.3.3. Delete

2.4.1. Select Query

2.5.1. Where
2.5.2. Like
2.5.3. Order by
2.5.4. Group by
2.5.5. Having
2.5.6. Distinct

2.6.1. Aggregate Functions
       2.6.1.1. Count
       2.6.1.2. Max
       2.6.1.3. Min
       2.6.1.4. Sum
       2.6.1.5. Avg

2.6.2. String Functions
       2.6.2.1. Length
       2.6.2.2. Lower
       2.6.2.3. Upper
       2.6.2.4. Ltrim
       2.6.2.5. Rtrim
       2.6.2.6. Reverse
       2.6.2.7. Replace

2.6.3. Mescelaneous Functions
       2.6.3.1. Coalesce
       2.6.3.2. Nullif

2.7.1. Not null
2.7.2. Default
2.7.3. Unique
2.7.4. Primary Key
2.7.5. Foreign Key
2.7.6. Check

2.8.1. Inner join
2.8.2. Left Outer join
2.8.3. Right Outer join
2.8.4. Full Outer join
2.8.5. Self join

3.1. Business Requirement Document
3.2. Report Requirement Document
3.3. Test Case Document
3.4. Mapping Document

4.1. Aggregate
4.2. Character Map
4.3. Conditional Split without Default
4.4. Conditional Split with Default
4.5. Derived Column
4.6. Sort
4.7. Merge join

5.1. Aggregate
5.2. Character Map
5.3. Conditional Split without Default
5.4. Conditional Split with Default
5.5. Derived Column
5.6. Sort
5.7. Merge Join

6.1. Overview
6.2. Architecture
6.3. Data source connections
6.4. Joining between the tables
6.5. Measures and dimensions
6.6. Different types of charts
6.7. Filters
6.8. Groups
6.9. Sets
6.10. Parameters
6.11. Dashboards
6.12. Story Points
6.13. Super Store Workbook
6.14. World Indicator Workbook

• Interview Preparation

Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.

The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.

The trainer is a certified consultant and has significant amount of experience in working with the technology.

Yes, we accept payments in two installments.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.