@media only screen and (min-width: 1024px) { #accordions-523 { width: 100%; } } @media only screen and (min-width: 768px) and (max-width: 1023px) { #accordions-523 { width: 100%; } } @media …
Need the PL/SQL Benefits of PL/SQL Different type of PL/SQL blocks Output Message of PL/SQL Block
Valid and Invalid identifier Use of Variables Data Types %TYPE attributes Bind Variables
Lexical Units in a PL/SQL blocks SQL functions in PL/SQL Nested Blocks Sequences in PL/SQL expressions
PL/SQL executable blocks DML statements in PL/SQL TCL in PL/SQL Use of INTO clause in SQL statement Implicit Vs Explicit Cursors
Types of Control Structures IF Statement CASE Statement Loop statement Conditional Control Structure
User defined PL/SQL records %ROWTYPE attribute INDEX BY Table INDEX TABLE of records Different among records tables, and tables of records
Implicit Vs Explicit Cursor Using explicit Cursors Control explicit Cursors Cursor FOR loops Cursors with Parameters WHERE CURRENT OF Clause
PL/SQL Exceptions Unhandled Exceptions Types of exceptions handlers Exception in Nested Blocks PL/SQL exceptions messages
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
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 …
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
Using Oracle Supplied Packages List of some Oracle-supplied Packages DBMS_OUTPUT UTL_FILE,IS_OPEN,HTP,UTL_MAIL, DBMS_SCHEDULER Creating a Job, Creating a Job for a Program with Arguments Creating Job Using Scheduler Setting a Repeat …
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 …
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 …
Understanding Dependencies Local Dependencies Displaying Direct Dependencies by Using USER_DEOENDENCIES Understating Remote Dependencies
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 …
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 …
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
Native and Interpreted Compiler Features and Benefits of Native Compiler Parameters Influencing Compilation Switching Between Native and Interpreted Compilation Using Native Compilation DBMS_WARNING Package
Basic SELECT statement Arithmetic expressions and NULL values Column alias Concatenation operator Literal character string Alternative quote operator DISTINCT keyword DESCRIBE command
Single-row SQL Functions Character Functions Number Functions Working with dates Date Functions
Implicit and explicit data type conversion TO_CHAR, TO_DATE, TO_NUMBER functions Nested Functions General Functions CASE and DECODE Conditional expressions
Group Functions MIN MAX, COUNT, AVG,DISTINCT within group functions NULL values in a group functions
Types of JOINS Natural join Self-Join Non-equijoin Outer join Cartesian Products
Single row subquery Group Function in subquery HAVING clause with subquery Multiple-row subquery NULL values in Subquery
INSERT, UPDATE, DELETE TRUNCATE and COMMIT ROLLBACK and SAVEPOINT Read consistency FOR UPDATE clause
Naming rules CREATE Table Data Types Constraint NOT NULL PRIMARY KEY FOREIGN KEY UNIQUE,ALTER Table Create table using a subquery
Managing constraints Creating Index Performing flashback operations Creating and using external tables
Table information Column information Constraint information View information Sequence Information Synonym information Comment to a table
Unconditional INSERT Pivoting INSERT INSERT ALL Merging rows Tracking the chnages
INTERVAL data types EXTRACT TZ_OFFSET FROM_TZ TO_TIMESTAMP TO_YMINTERVAL TO_DSINTERVAL
Using scalar subquery correlated subqueries EXISTS and NOT EXISTS WITH clause
REGEXP_LIKE REGEXP_REPLACE REGEXP_INSTR REGEXP_SUBSTR Accessing subexpressions REGEXP_COUNT
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 …
If you are looking for the best Python training in Mumbai & Thane then your search ends over here. Yes, Petaa Bytes is one of the best Python Programming Training …
Learning Objectives – In this module, you will get an understanding of Architecture of mongoDB® and Design Goals. This Module will also cover installation of mongoDB® and all relevant tools. …
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 …
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 …
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 …
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 & …
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 …
Who wants to get into IT without any prior knowledge of programming
Student should bring their laptops otherwise machines will be provided.
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, …
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: …
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 …
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 …
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, …
Table Transformation Generic Load Cross Tables Hierarchy Create Theme File Book Marks
Qlikview Functions Radar Chart Scatter Chart Grid Chart Fast Change of Charts Cyclic Chart Drill Down Chart
Set Analysis Set Identifier, Operator, Modifier Indirect Set Analysis: P(), E() Mekko Chart Tips and Tricks
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
Introduction to Data Mining Understanding Machine Learning Supervised and Unsupervised Machine Learning Algorithms K-means Clustering
Association Rule Mining Sentiment Analysis
Decision Trees Algorithm for creating Decision Trees Greedy Approach: Entropy and Information Gain Creating a Perfect Decision Tree Classification Rules for Decision Trees Concepts of Random Forest Working of Random …
Creating an application using Shiny Accessing R objects through Shiny interface
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
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 …
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 …
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: …
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, …
Learning Objectives – In this module, you will learn mongoDB® tools to develop and deploy your applications. This module will also help you understand the multiple package components. Topics –API …
Learning Objectives – In this module, you will understand how multiple mongoDB® components work together in a mongoDB® project implementation. We will also discuss multiple case studies and specifications of …
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 …
