Live Instructor-Led Training
The course SQL Data Analysis with Toad Intermediate (Oracle Training) explores the SQL language with Oracle and Toad. The training includes SQL basics including filtering, sorting, single and multi table join strategies, subqueries, correlated subqueries & more. The course also covers stored procedures and discusses common SQL tasks in an Oracle environment.
Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00
Working with Toad
Overview of the Toad Environment
Organizing File with Toad
Writing Scripts with Toad
Debugging Scripts with Toad
Exploring Toad’s Functional Capabilities
Configuring Toad to Work for You
Relational Database Essentials
Relational Database Concepts » Tables, Fields and Rows
Understanding Data Normalization
About Entity Integrity: Primary Keys
About Referential Integrity: Foreign Keys
About Domain Integrity: Checks and Defaults
Overview of Oracle Data Storage Structures and Performance Implications
Mastering the Data Retrieval: The Basics
The Basic Structure
About Statement Processing
Working with Aliases and Headers
Writing Where Statements
Performing Pattern Matching
Querying for Ranges
Writing Predicates for Specific Data Types
Sorting Data
Retrieving Unique Values
Making use of Union
Mastering Data Retrieval: Working with Multiple Tables
The Anatomy of the Statement
Working with Point and Range Queries
Writing Multi-Table Statements: Exploring Joins
Exploring Join Types: Inner Outer and Cross
Optimizing Joins
Using Regular Sub-Queries
Using Correlated Sub-Queries
Comparing Performance Profiles
Mastering Aggregate Calculations
The Anatomy of Aggregate Value Statements
Exploring Group By
Exploring Oracle Aggregate Functions
Dealing with Multiple Tables
Modifying Data
Working with New Data
Working with Data Modification
Working with Data Suppression
Working with Multiple Records
Performing Bulk Operations
SQL Common Tasks
Working with Automatic Increments
Working with Strings
Working with Dates and Time
Working with NULL Values
Working with Numeric Data Types
Advanced Tasks
Identifying Duplicate Values
Generating Rank
Generating Median
Generating Running Totals
Generating Percent To Total
Generating Cumulative Percent To Total
Creating Stored Procedures
The Performance Advantages of Stored Procedures
Creating Stored Procedures
Working with Input Parameters
PLSQL Programming Essentials
Storing Stored Procedures
Putting it All Together
PLSQL Training: Mastering Database Programming with PL/SQL
The course Mastering Database Programming with PL/SQL (PLSQL Training) covers the essential elements of the PL/SQL language. The training includes the creation and deletion of tables and the use of SQL to display, insert, delete and modify relational data. The course also covers blocks, data types, variables, program flows, stored procedures & functions and PL/SQL packages.
Training course titled PLSQL Training: Mastering Database Programming with PL/SQL that will allow you to hone your professional skills.
Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00
PLSQL Training: PLSQL Deep Dive
The course PLSQL Training: PLSQL Deep Dive for Operations will have you explore practical PLSQL for every day operations. The course starts with a quick review of Oracle database architecture and table structure for normalization. What follows is a truly exhaustive study of SQL syntax, indexes, aggregate data, and everything that you ever wanted to know about both regular and correlated sub-queries. The course ends with good old-fashioned PLSQL programming starting with the core language and ending with procedures and functions. If you want to learn how to write practical PLSQL, this is the PLSQL training course that you need.
Training course titled PLSQL Training: PLSQL Deep Dive that will allow you to hone your professional skills.
Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00
PLSQL Training: The Complete PL/SQL Programming Course
The course The Complete PL/SQL Programming Course (PLSQL Training) is a detailed exploration of the PL/SQL language and it many nooks and crannies. The course covers basic & advanced SQL techniques and PL/SQL programming fundamentals. The training also includes cursors, triggers, stored procedures & functions, sequences and packages. Finally, the course discusses object oriented programming, Java integration, XML processing & performance tuning with indexes. This PL/SQL course will teach you how to write great PL/SQL code.
Training course titled PLSQL Training: The Complete PL/SQL Programming Course that will allow you to hone your professional skills.
Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.00
PLSQL Training: Introduction to Data Design & Manipulation
The course Introduction to Data Design & Manipulation (PLSQL Training) is an introduction to PL/SQL programming. Beginning with the creation of database tables, the course presents a variety of PL/SQL language features in a logical and sequential order beginning with SQL syntax and ending with packages and functions. If you need to work with PL/SQL, this course will get you started in the right direction.
Training course titled PLSQL Training: Introduction to Data Design & Manipulation that will allow you to hone your professional skills.
Feb 12 - 14, 2025$3,350.00Mar 12 - 14, 2025$3,350.00Apr 16 - 18, 2025$3,350.00May 14 - 16, 2025$3,350.00Jun 11 - 13, 2025$3,350.00Jul 16 - 18, 2025$3,350.00
PLSQL Training: Objects, Librairies, XML, Java & More
The course Objects, Libraries, XML, Java & More (PLSQL Training) covers the advanced elements of PL/SQL. Beginning with stored procedures & functions, the training discusses database triggers, PL/SQL records, PL/SQL collections, PL/SQL error handling & object oriented programming in PL/SQL. The course concludes with XML processing, Java integration and performance tuning & optimization in Oracle.
Training course titled PLSQL Training: Objects, Librairies, XML, Java & More that will allow you to hone your professional skills.
Jan 29 - 31, 2025$2,750.00Feb 26 - 28, 2025$2,750.00Mar 26 - 28, 2025$2,750.00Apr 30 - May 2, 2025$2,750.00May 28 - 30, 2025$2,750.00Jun 25 - 27, 2025$2,750.00Jul 30 - Aug 1, 2025$2,750.00