
Rajnees

-
Claimed Profile
Some amazing things about us you should know.
-
0+Students
-
4+Courses
-
8+Total Instructors
-
3+Services offered
About Rajnees
Informatica
We offer a 6 Week intensive Informatica Training followed by
Interview guidance and technical support during the 1st project.
Instruction will be both in class and online. Students will be given 24/7
Access to Informatica Software (Power Center 8.6, Power Exchange 8.6).
LimitedAccommodation is available*
Eligibility: Preferably BS/MS in CS/ IS/ IT, IT Professionals. Candidates from Non-IT background are also welcome if they are willing to devote at least three (3) hours a day.
Module : ETL Developer Target Audience: IT aspirants and IT Professionals looking to switch fields Topics Data Warehousing Concepts, SQL, PL/SQL, Informatica 8.6, Live Project Total Hours 54 ( Approx 6 weekends)
Course Details
Week 1:
Data Warehousing
Introduction to Data warehousing: Types of Systems, OLTP, DSS, Maintenance of Data warehouse, Data warehousing Life Cycle, Datawarehousing Testing Life Cycle, Data warehousing Architecture,Source, Integration Layer, Staging Area, Targets, Analysis & Reporting, ODS.
Data Modeling
Introduction, Different phases of Modeling, Multi Dimensional Modeling , Dimensions, Facts, Multi Dimensional Model Hierarchies,OLAP, MOLAP, ROLAP, HOLAP, Cubes and their Functions, Star Schema, Fact Table, Dimensional Tables, Snow flake Schema, Factless Fact Table, Confirmed Dimensions
Week 2:
Day 1: SQL Basics | Day 2: Informatica | Day 3: SQL Continued |
Introduction to Relational Database Systems: ORACLE, DB2, SQL Server Introduction to SQL:Basic SQL commands, the SELECT Statement,Ordering the output, Conditional retrieval of data , Working with variables Pseudo columns and functions, character functions, date functions , Using non-character function multiple tables, Different type of Joins, Writing Outer Joins ,Using the SET operators Aggregating data using group functions | Introduction to Informatica, Overview, Basic Definitions, Informatica Products, Informatica Architecture, Tools and their roles, Folders Sub Folders Power center, Differences between 7x and 8x | Creating Subqueries Enhancing groups function ,Transaction Control Language, Rollback, Commit, Processing hierarchies , Creating the Tree structure, Data Manipulation Language Data Definition Language, Using Declarative Constraints Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null |
Week 3:
Day 1: Informatica Designer | Day 2, 3: Transformations |
Introduction to designer, Designer interfaces, Designer tools, Defining Sources, Database as a source, Defining Targets, Importing from database, Creating a new target Creating target database objects Mapping Introduction, Ports, Mapping Table to Table, Mapping flat file to Table | Expression Transformation, Aggregator Transformation, Joiner Transformation, Homogeneous, Heterogeneous, Sequence Generator Transformation, Rank Transformation, Router Transformation,Union Transformation, Source Qualifier, Source Qualifier Transformation, SQL override in Source Qualifier Transformation,Mapping Source Qualifier as Filter Source Qualifier to join data, Flat Files sources & targets, Delimited Fixed width, Debugger |
Week 4:
Day 1, 2: | Day 3: |
Lookup: Static, Dynamic, Unconnected, Cached & Uncached,Customized Named Cache use technique from static & dynamic lookup Flat file lookup, Handling sub second precision for a Lookup transformation, Filtered lookup Mapping Wizards, Implementing of SCDs (Each types by at least by five Methods), Type-I, Type-II, Type-III | SQLT, Normalizer, Transaction Control, Stored Procedure Transformation, XML Transformation, Custom Transformation Informatica Workflow Manager Workflow Introduction, Tasks, Workflow Tools, Connections Defining Tasks, Command Task, Email Task, Session Task Link Conditions,Event Wait & Event Raise, Setting properties of Session Task ,Creating Workflow, Starting Workflow, Monitoring Workflow,Workflow Parameters |
Week 5 (day 1,2):
Advanced Topics Incremental Aggregation, Mapping Analyst for Excel (MAE), Push-down Optimization Mapplet Implementation, Meta Data Backup & Restore,Copying Repository, Sending Notification Messages, Informatica Tuning,User Defined Function, Version Control, Copy folder and Deployment,Shortcut, pmcmd commands
Week 5 / 6:
PROJECT
The project will be conceived and developed by the group from scratch,right from gathering requirement to final mappings. Various persons will assume various roles and the roles will be interchanged as the project progresses. The project may be based on Insurance/ Financial/Pharmaceutical industry
Support during the 1st project
Technical Support will be provided to Individuals throughout the 1st project/1st Year
Certification Guidance
Individuals interested in Preparing for Certification in Informatica will be given the required material and guidance
Unix
Summary
We offer a 4 week intensive course in POSIX with a concentration on UNIX ( SOLARIS & HP ) and Enterprise Linux to train IT professionals and students followed by extensive interview preparation by industry experts to enable the students reach an industry-demanding expertise in System Admin and related work.
Course Detail
Week1 Day 1 | Week 1 Day 2,3 | |
UNIX Overview, UNIX File structure, Basic Commands | UNIX Shell, Editor, UNIX Man Pages, Basic UNIX commands | |
Week 2 Day 1 | Week 2 Day 2,3,4 | |
UNIX Shells and Shell Commands | UNIX Editors VI, VIM, EMACS and Others | |
Week 3 Day 1 | Week 3 Day 2,3 | |
The root and users | Networking, Adding/Removing Hardware | |
Week 3 Day 3,4 | Week 3 Day 5 | |
Advanced Sheel Programming | UNIX Utilities | |
Week 4 Day 1,2 | Week 4 Day 3,4,5 | |
Installing the UNIX OS, File Partitioning, | Developing Applications in C/C++, |
Business Object
Summary
Intensive Five weeks training (In-class and online) in Business Objects including Real-Time Project to help achieve expertise in the industry leading reporting tool followed by a full scale preparation for interview with mock interviews by our panel of experts.
Course Detail
Week: 1
Day 1:
- Business Objects Overview
- Business Objects Architecture
- Tools and their roles
- Business Intelligence/DWH concepts
Day 2:
- Business Objects Introduction
- Documents
- Reports
- Blocks
- Universes, Classes and Objects
- Data Providers
Day 3 :
- User Interface:
- Toolbars and Menus
- Help
- The Data/Properties Zone
- The Status Bar
Week: 2
Day 4-6:
- Reports and Analyzing Data
- Editing Blocks to Manipulate Data
- Adding Blocks to an Existing Report
- Creating Sections in Reports
- Adding New Reports to a Document
- Using the Query Panel
- Editing a Query, Building a Query
- Running a Query
- Simple Query Filters
- User Defined Single Value Conditions
- Pre-Defined Query Filters
- Filtering, Sorting, Ranking Data
- Using Alerts
- Inserting Simple Calculations
Day 7
- Report presentation styles
- Tables, Crosstabs, Charts and Forms
- Formatting Blocks
- Formatting Pages
- Formatting Breaks
- Special Fields
- Using Headers and Footers
- Adding Logos and Pictures
- Creating Templates
Week: 3
Day 8-9
- Using Multiple Data Providers
- Understanding the concept of a Data Provider
- Multiple Queries (Data Providers) from a Single Universe
- Naming Data Providers
- Querying Multiple Universes in a Single Document
- Using Personal Data Files (Eg. Microsoft Excel spreadsheets) as Data Sources
- Synchronizing Data Providers by Linking
Day 10
- Defining and Using Variables
- Creating Variables
- Resetting Calculations across Breaks
- If..Then…Else Variables
- The Group Function
- Creating a Variable Using the Group Function
- Understanding Calculation Contexts
Day 11
- Using Slice and Dice
- The Slice and Dice View
- Converting Tables to Crosstabs
- Converting Table Blocks to Charts
- Adding Breaks, Totals, Filters and other Functions
Day 12
- Drilling
- Understanding Hierarchies
- Setting the Scope of Analysis
- Pre-Defined Hierarchies
- Drilling on Single Hierarchies
- Drilling on Multiple Hierarchies
- Creating Custom Hierarchies
- Drilling on Charts
- Displaying the Drill Information
- Saving Snapshots
Week: 4
Day 12
- Semantic Layer (Universe) creation
Day 13-16
- Real-Time Project
Week: 5
Day 17-20
- Real-Time Project
TeraData
Summary
We offer a five weeks intensive training in Teradata covering from the very basics to advanced level to meet with the current and future industry demands of database management. training involves Real-time project, interview preparation and mock interviews by a team of subject experts.
Course Detail
Week: 1
Introduction to TERADATA
TERADATA Architecture
Primary Index
Secondary Index
Week: 2
Teradata SQl
Types of Tables
Teradata Spaces
Joins
Week: 3
Set Operators
Views
Macros
Data and Times
Rank Function and Qualify Usage
OLAP Function
Week: 4
Teradata Utilites
Locks
Protection Features
Stores Procedure
Performance Tuning
Project
Week: 5
Project
Contact us@
rajnees@gmail.com
1-201-993-3798
Business highlights
-
IT Professionals as Trainers
Learning a technology with a professional who is well expertise in that solve 60% of your needs.
-
Hands-on Training
We support any training should be more practical apart from theoretical classes. So, we always give you hands-on training.
-
Affordable Fees
We are dead cheap in fees. We are having options to make the payment in instalments as well if needed.
-
10000+ old students to believe
We satisfied 10000+ students from the day we started GangBoard
-
Counselling by Experts
We have every course material to understand which is prepared by our trainers and we will share with you after session completes.
-
Own Course Materials
We have every course material to understand which is prepared by our trainers and we will share with you after session completes.
Services offered
- Online Training
- Classroom Training
- Placements
- Visa Assistance
- Accommodation
- H1B Transfer
Popular IT training modules
- Microsoft Azure training
- SAP Security training
- Robotic Process Automation (RPA) training
- SAP BW training
- SAP APO SNP training
- Oracle Applications Financial training
- Generative AI For Data Scientists training
- DevOps Development Tools training
- SQL Server Analysis Services training
- ITIL Foundation training
- SAP Analytics Cloud training
- Agile Scrum BA training
- Systems Analyst training
- TIBCO training
- MS SQL Server DBA training
- IoT MQTT training
- Azure Developer Associate training
- Adobe Dreamweaver training
- Oracle E-Business Suite Financial Management training
- Hadoop Developer training
- IBM Websphere Application Server training
- Hadoop training
- SAP Netweaver training
- SAP APO DP training
- SAP BO training
- QA training
- Enterprise Risk Management training
- Database Management training
We value your time
Become a prime member and teach what you love in your free time, because can pick their desired time to teach their trainers
