Have Queries? Ask us +91 75065 23339
04 July

Hadoop Training

jQuery(document).ready(function($){$("#accordions-523.accordions").accordion({active: "",event: "click",collapsible: true,heightStyle: "content",animated: "swing",})}) #accordions-523{ text-align: left;} #accordions-523{ background:#ffffff url() repeat scroll 0 0; padding: 0; } #accordions-523 .accordions-head{ color:#ffffff; font-size:14px; background:#70b0ff; } #accordions-523 .accordions-head-title{ } #accordions-523 .ui-accordion-header-active{ …
04 July

Hadoop Training Introduction

jQuery(document).ready(function($){$("#accordions-523.accordions").accordion({active: "",event: "click",collapsible: true,heightStyle: "content",animated: "swing",})}) #accordions-523{ text-align: left;} #accordions-523{ background:#ffffff url() repeat scroll 0 0; padding: 0; } #accordions-523 .accordions-head{ color:#ffffff; font-size:14px; background:#70b0ff; } #accordions-523 .accordions-head-title{ } #accordions-523 .ui-accordion-header-active{ …
17 March

Creating Stored Procedures

What is Procedure Syntax and Developing Procedure What are Parameters IN/OUT/IN OUT Procedures Calling PL/SQL Using Host Variables and Using Default Options for Parameter Invoking Procedures and Handled Exceptions

17 March

Creating Stored Functions

Overview of Stored Functions Syntax and Developing Store Functions Advantages of User-Defined Functions in SQL statements Functions in SQL expressions Locations to call User-defined functions Restrictions on Calling Functions from …

17 March

Creating Packages

PL/SQL Packages Component of PL/SQL Packages Visibility of Package Components Developing PL/SQL Packages Creating Package Specification and Body Invoking Package Subprograms Creating and Using Bodiless Packages Advantages of Using Packages

17 March

Dynamic SQL and Metadata

Execution Flow of SQL Dynamic SQL Native Dynamic SQL Using the EXECUTE IMMEDIATE Statement Dynamic SQL with a DDL Statement Dynamic SQL with DML Statement Dynamic SQL with Single-Row Query …

17 March

Design Considerations for PL/SQL Code

Standardizing Constants and Exceptions Local Subprograms Definer’s Rights Vs Invoker Rights Autonomous Transactions Returning Clause Bulk Binding Bulk Collect FORALL, BULK COLLECT INTO with RETURNNG Clause Using NOCOPY Hint PARALLEL_ENABLE …

17 March

Manipulating Large Objects

What is LOB Contrasting LONG and LOB Data Types What is BFILES Securing BFILES Managing BFILES Preparing to use BFILES Using DBMS_LOB Migrating from LONG to LOB DBMS_LOB DBMS_LOB.READ, and …

17 March

Creating Triggers

Types of Triggers Guidelines for Designing Triggers Creating DML Triggers Types of DML Triggers Trigger Timing Trigger Firing Sequences Trigger Event Types and Body Creating a DML Statement Trigger Using …

17 March

Application for Triggers

Creating Database Trigger Creating Trigger on DDL statement Creating Triggers on System Events LOGONG and LOGOFF Trigger CALL statement Reading Data from a Mutating Table Benefits of Database Triggers

17 March

Using Subquery

Single row subquery Group Function in subquery HAVING clause with subquery Multiple-row subquery NULL values in Subquery

28 March

Komal Laad

To kick start your career in Big Data analytics, Petaa Bytes is the correct choice. Under Shrikant Sir’s guidance, all the concepts gets clear related to Big data technologies. He …

28 March

BASIC EXCEL

  Introduction to MS Excel / Advanced Excel Course in Mumbai Brief Tour of Excel 2007 Formatting, Format Painter Pasting data, Paste Special Values, Filters Data Sorting, Grouping, Text to Column …

28 March

ADVANCED EXCEL

Advanced Formulas – Vlookup, Hlookup, Countifs, Sumif, Sumifs, Extensive If Conditions, Conditional Formatting, Logical Functions, Text Functions and Much more Functions for Advanced Excel Course in Mumbai. Excel Tables Excel …

28 March

BASICS of EXCEL VBA

Software Development Life Cycle VB(Visual Basic) v/s VBA(Visual Basic for Application) Brief Computer Architecture Computer Program – Compiler, Interpreters Brief Introduction to MS Office Brief Introduction to MS Excel & Advanced …

28 March

VBA

Tour of VBE (Visual Basic Editor) Code Window, Project Window, Properties Window Introduction to Module, User forms and Class Writing First Program Recording Macro Absolute Recording Relative Recording Constraints in …

23 March

ABOUT THE COURSE

Learn Oracle SQL from a certified Oracle instructor with more than 14 years of IT experience in Oracle. Basics of Database CRUD operations of Database. How to write queries & …

23 March

TOPICS COVERED

SQL – Overview RDBMS Concepts Databases Architecture CRUD operations Data Types Operators Expressions Create Database Drop Database Select Database Create Table Drop Table Update Tables Insert Data into Tables Select …

23 March

BASICS of QLIKVIEW

What is Qlikview? Why Qlikview? Who can use Qlikview? Thinking through a BI solution build Structured approach for first dashboard build in a Visualisation tool Understanding Qlikview Desktop, Publisher, Server, …

23 March

QLIKVIEW SCRIPTING

Necessity of Scripting Connecting to Data Source: Select and Load Connecting to Data Base (thru OLEDB), Excel File, QVDs, Qlikview Application (Binary Load) etc; Understanding Preceding Load What if Analysis: …

23 March

DATA MODELLING in QLIKVIEW

Loading Multiple files to QV, Table Viewer Table Joins: Join, Left, Right, Inner Joins Keep: Left, Right, Inner Concatenate Tables (Implicit, Explicit Concatenation), Prevent Implicit Concatenation Start Schema, Snow Flake …

23 March

DATA MODELLING OPTIMIZATION

Challenges of Data Modelling: Synthetic Key, Circular References, Loosely Coupled Tables Solution: Rename Fields, Auto number, Qualify (UnQualify), Concatenate, Composite Key Linked Tables Dashboard Real Estate space Optimization Techniques Multi …

23 March

DATA LOAD TYPES

Cross Tables Mapping Load and Mapping Tables Reading and Writing QVD files, csv Files in the script Advantages of QVDs and creation of QVDs from Chart Buffer Load, Incremental Load, …

21 March

Gaurav Singh

I started learning hadoop in 2014 at Petaa Bytes in guidance of Shikant Sir. It helped me in understanding hadoop concepts, hands-on and provided valuable study material. Even after course …

21 March

Abhishek Das

It was an outstanding classroom training felicitated by Mr Shrikant Gawande. This happens to be one of my best training experiences where he mixed up the technological aspects with real …

21 March

Mohit R Sudhera

If anybody wants to experience a sound learning aura and that too from a calm and composed personality like Shrikant sir, please go for Petaa Bytes Training. I joined here …

21 March

Ramesh Shetty

I would recommend Petaa Bytes to anyone who is serious about pursuing a career in BigData -Hadoop, MongoDB, Python or taking their IT skills to the next level. I took …

21 March

Komal Laad

To kick start your career in Big Data analytics, Petaa Bytes is the correct choice. Under Shrikant Sir’s guidance, all the concepts gets clear related to Big data technologies. He …

16 March

INTRODUCTION TO DATA ANALYTICS

Understand Business Analytics and R Knowledge on the R language community and ecosystem Understand the use of ‘R’ in the industry Compare R with other software in analytics Install R …

16 March

INTRODUCTION TO R PROGRAMMING

The various kinds of data types in R and its appropriate uses The built-in functions in R like: seq(), cbind (), rbind(), merge() Knowledge on the various Subsetting methods Summarize …

16 March

DATA MANIPULATION IN R

The various steps involved in Data Cleaning Functions used in Data Inspection Tackling the problems faced during Data Cleaning Uses of the functions like grepl(), grep(), sub() Coerce the data …

16 March

DATA IMPORT TECHNIQUES IN R

Import data from spreadsheets and text files into R Import data from other statistical formats like sas7bdat and spss Packages installation used for database import Connect to RDBMS from R …

16 March

EXPLORATORY DATA ANALYSIS

Understanding the Exploratory Data Analysis(EDA) Implementation of EDA on various datasets Boxplots Understanding the cor() in R EDA functions like summarize(), llist() Multiple packages in R for data analysis The …

16 March

DATA VISUALIZATION IN R

Understanding on Data Visualization Graphical functions present in R Plot various graphs like tableplot Nhistogram boxplot Customizing Graphical Parameters to improvise the plots Understanding GUIs like Deducer and R Commander …

16 March

SESSION 1

What is Big Data & Hadoop? Limitations of the existing solutions for Big Data Hadoop Training Solving the problem with Hadoop Online Introduction to Hadoop Online Training HadoopEco-System HadoopCore Components …

16 March

SESSION 2

Hadoop 2.0 Hadoop 2.0 Configuration Files Hadoop Cluster Modes Hadoop Cluster Architecture Hadoop Cluster planning: Hardware Considerations Hadoop Cluster planning: Software Considerations Popular Hadoop Distributions

16 March

SESSION 3

NN High Availability –Quorum Journal Manager Hadoop server roles and their usage Plan your Hadoop Cluster: Hardware Considerations Cluster Network Configuration Plan your Hadoop Cluster: Software Considerations Popular Hadoop Distributions …

16 March

SESSION 4

HDFS Architecture Monitoring Commands Schedulers FIFO Scheduler Fair Scheduler Configuring a Fair Scheduler Capacity Scheduler Introduction to Oozie

16 March

SESSION 5

Oozie Common Admin Commands Data Backup and Recovery Data Backup Name Node Recovery Data Node Addition/Removal Hadoop 2.0 HDFS Snapshot

16 March

SESSION 6

Introduction to oozy Hive Architecture Hive Administration HBase Deployment and Administration

16 March

CRUD OPERATIONS

Learning Objectives – In this module, you will get an understanding of CRUD Operations and their functional usage. Topics –Introduction, Read and Write Operations, MongoDB® CRUD Tutorials, MongoDB® CRUD Reference

16 March

SCHEMA DESIGN & DATA MODELLING

Learning Objectives – In this module, you will learn Schema Design and Data Modelling in mongoDB®. Topics –Concept, Examples and Patterns, Model Relationships Between Documents, Model Tree Structures, Model Specific …

16 March

ADMINISTRATION

Learning Objectives – In this module you will learn MongoDB® Administration activities such as Backup, Recovery, Data Import/Export, Performance tuning etc. Topics – Operational Strategies, Data Management, Optimization Strategies for …

16 March

SCALABILITY & AVAIBIITY

Learning Objectives – In this module, you will understand the setup and configuration of mongoDB® High Availability, Disaster Recovery, and Load Balancing. Topics – Replication: Introduction, Concepts, Replica Set Sharding: …

16 March

INDEXING & AGGREGATING FRAMEWORK

Learning Objectives – In this module, you will learn the Indexing and Aggregation Framework in mongoDB®. Topics –Indexes: Introduction, Concepts, Index Types, Index Properties, Index Creation Aggregation: Introduction, Concepts, Map-Reduce, …

15 March

About

Petaa Bytes is the leading training provider of Apache SPARK, Hadoop, MongoDB and Big Data related open source technologies with classroom and online training around the world. We offer the …

14 March

Chinmay Palkar

PetaByte : An excellent gateway to step into BigData Arena/ BigData career, where you can learn Hadoop in depth , Shrikant Sir: Highly experienced and knowledgeable guide and mentor who …

Subscribe Now for Our Courses
Tell us more about your requirements so that we can connect you to the right hadoop Training in Mumbai
Name *

Email *

Mobile No:*
Courses:
Message
Contact Us
close slider



Request a Demo

We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.

Your Name (required)

Your Email (required)

Your Mobile Number (required)

Subject
OnlineOffline

Your Message

X