Browse live Oracle training classes in New York, by top programming trainers such as Learning Tree International, New Horizons, Global Knowledge, . CodingGuru.com currently lists 4 live instructor-led Oracle training events state-wide.
Introduction and Overview
PL/SQL fundamentals
Declaring and anchoring variables to database definitions
Flow control constructs
Oracle 11g and 12c PL/SQL features
PL/Scope in Oracle 11g
Returning implicit cursor results from stored procedures in Oracle 12c
Declaring local functions within SELECT statements in Oracle 12c
Data Manipulation Techniques
Maintai
Introduction and Overview
The uses of SQL queries
Why SQL can be both easy and difficult
Recommendations for thorough testing
Enhancing query performance
Query optimization
Choosing the most efficient query method
Leveraging SQL Functions to Build Queries
Aggregate functions
Grouping in several levels
Grouping and NULLs
CUBE and ROLLUP
Building crosstab repor
