|
|
|
Data WareHousing Classes In Pune
|
|
Number of Views: |
213 |
| Contact Person |
Girish |
| Trainings Offered |
Informatica, Cognos, SQL Server, Data Warehousing, Business Analyst, Ab Initio, Business Intelligence, Unix and Linux |
| About Institute |
BI & DATAWAREHOUSING CORPORATE TRAINING INSTITUTE
About Us:
Cformula. Having its Corporate Office at Akurdi, Pune vision to excel in the field of IT and IT Related Services, like software development and services consultancy, Quality Training(By Industry Experts) etc.
About Trainings:
We provide corporate training on BI and Database technologies from group of professionals and industry experts. With Live project Training with practical implementation This course trains you for Data warehouse Developer and BI technologies and any IT based roles.
Our Unique Features:
• We provide all material (full description) for study, Interview notes and certification material also.
• Limited student Batch (Max-10 per batch).We concentrate on each student.
• Very less fees(8k Rs. Only) for whole course.
• Quality Training (By Industry Experts) with practical implementation by yourself.
• We help for Resume development.
We provide training on following topics:
1. Basics Of Database
2. SQL
3. PL/SQL
4. Data WareHousing Concepts(with project example).
5. Database: Oracle ,SQL-Server
6 .ETL-Technology: Informatica (with 2 projects)
7. Unix(Basics)
Course contents
Database Basics:
.Need Of database .Comparison with other systems .How to decide which database will be suitable?
SQL:
. Basic SQL .DDL .DCL .DML .TCL .Sub-queries Joins Nested Queries Inbuilt- functions Views
Conditional Statements
PL/SQL :
. Cursors . Procedures . Functions . Triggers
DWH:
.Principles of Data warehouse • Benefits of DWH • What is Online transactional systems (OLTP)? • Difference between OLTP and DWH • Architecture of DWH • Approaches of Data warehousing • Normalization and Denormalization • DWH Lifecycle: • Data Modeling • Dimension table • Fact Table • Aggregate table • Schemas • Star schema • Snowflake schema • Types Of Fact Tables: • Cumulative • Snapshot • Fact less Fact • Types Of Facts: • Additive • Semi Additive different relationa models. types of dimensions SCD-in detail Degenerate,junk,role-play dimensions design of Data model with example
ETL-Tool:Informatica :
.Need Of ETL . Flow Of ETL Basic transformation .Introduction with Each Transformation with example
.Power center Designer . Source Analyzer .Target Analyzer . Mapping Designer . Mapplet Designer . Transformation . Workflow Manager . Task Developer .workflow designer .woklet designer .Workflow Moniter .Project(1) . project(2)
Unix:
.Structure of unix .Basic Unix command .Shell Introduction .Basic Shell Programming
Oracle:
All SQL/PL-SQL will be covered on Oracle.
SQL Server
Also respective syntax provided in SQL server also.
Contact:
Girish-9011025200
Batch Schedule: 8th Oct 2011 from 2 pm to 5pm {Batch will be only on week-end (sat and sun)basis }
Fees:
8000/- Rs Only
Class Duration:
2 months
Address:
CFormula Computers ,
Kute Complex, 1st Floor,
Near Hanuman Mandir, Akurdi, Pune, Maharashtra, India- 412130
|
| Address / Colony |
CFormula Computers ,
Kute Complex, 1st Floor,
Near Hanuman Mandir, Akurdi, Pune, Maharashtra, India-
/
kute complex... |
| City |
Pune |
| Phone |
9011025200 |
| Mobile Number |
9011025200 |
| Website |
|
| Trainings Center Ratings |
Not Yet Rated. Please Add your Review and help people |
| View Postings by this Trainer |
|
Contact Training Center
|
|