Introducing Optimized Infotech

Course details

Extract, transform, load or ETL technology is  a combination of three actions to extract data from databases. Students will be taught on the below mentioned areas: 

 

Oracle Objects

2. DDL Statements

3. DML Statements

4. TCS Statements

5. Joins

6. Sub Query

7. Correlated Sub Query

8. Oracle Analytical functions

9. Views, Materialized views

10. PL/SQL

Datawarehouse Concepts

1. Data Warehouse

2. Data Mart

3. OLAP VS OLTP

4. Data Warehouse Architecture (Basic)

5. Data Warehouse Architecture (with a Staging Area)

6. Dimensional Modeling

7. Star Schema

8. Snowflake Schema 

Course details

Learning Perl is about knowing this general purpose programming language which is use in areas like system administration, web development, network programming, GUI development and much more. Folowing are some of the components of our Perl programming language syllabous: 

History of evolution

Why Perl

Uses of Perl

Perl on Linux, windows

Real life examples

Books on perl

Perl Fundamentals

First program with minimal explanation

Variables : scalar, array, hash

Operators

Print statements

Comments

Executing the program

Use of use strict and use warnings pragma

Subroutines

Course details

Selenium provides a software testing framework for web applications. Following are the areas on which the programme is conducted: Manual, Selenium, SQL Web security testing, Agile Methodology, S/W Architecture etc. All the aspects of the technolgy is taught in great detail and wioith scope of plenty of practice and rectification of doubts, problems etc.

Course details

Hadoop is the core platform for structuring Big Data and solves the problem of formatting it for subsequent analytics purposes. Knowledge of Core Java is desirable in this course. We have designed this programme to enable the students in Mastering the concepts of HDFS and MapReduce framework, Understand Hadoop 2.x Architecture, Setup Hadoop Cluster and write Complex MapReduce programs, learn the data loading techniques using Sqoop and Flume, Perform Data Analytics using Pig, Hive and YARN, Implement HBase and MapReduce Integration, Implement Advanced Usage and Indexing, Schedule jobs using Oozie, Implement best Practices for Hadoop Development, Work on a Real Life Project on Big Data Analytics etc.

Course details

Amidst immensely competitive web commerce environment one needs technologies to enhance their brand value. Search engine Optimization is the new tool for online marketing and we have all the requisite areas to make you an all rounder in the SEO technologies:

PART I – About Search Engine Optimization

PART II – Search Engine Basic Components & their working.

PART III– Keyword Research, Keyword Analysis, Keyword Selection.

PART IV– KEI Check, Keyword Density Check, Keyword Repetition Check.

PART V – On-Page Search Engine Optimization

PART VI– Search Engine Submission & Sitemaps

PART VII– Introducing Page Rank, Alexa Rank, IBLs, OBLs, Link Juice

PART VIII– Estimating Page Rank.

PART IX– Automated Content Generation for your website.

PART X – Website Submission to Non-Spidered Indexes, Directories.

PART XI – Submitting to Local Search, Geo Search.

PART XII – Creating Press Releases & Distribution.

PART XIII – Managing RSS Feeds for your website in SEO.

PART XIV – Social Media Optimization.

Course details

Interested to learn this unique programming language that can be applied ingeneral purposes,and has easier and shorter syntax compared to C++ or JAVA.Learner of this language will be able to work quickly and integrate systemsmore effectively.

Course details

To gauge the quality of a software as per the requirement is learnt through this course. One will go through manual, automation and database testing, advance QTP, Selenium IDE, Load runner etc. Some of the topics of this programme are 1. Introduction

2. Models of Software Engineering

3. Fundamentals of testing

4. Testing Methodologies

5. Testing Levels

6. Types of Testing

7. Project Life Cycle

8. Live Project (Lab)

9. Quality Assurance and Quality Control

10. Risk Management

11. Configuration Management

Course details

This widely used operating system Android is learnt through the below mentioned topics:   

• An Introduction to Android
• Android & Smart Phones
• A Brief History
• Important Versions
• Android & Applications
• Android Resources
• Starting with IDEs and Android –SDK
• Eclipse IDE or IntelliJ Studio for creating UIs effectively or starting with Android ADT-Bundle