Oracle Training Courses

Oracle Training

Oracle Courses

Client Testimonials

Oracle Application Express Introduction

The format was really good, the exercises were not too difficult and helped us to fully understand the tool.

Juan Salvador Rios Hoyos- Oracle

Oracle Application Express Introduction

The format was really good, the exercises were not too difficult and helped us to fully understand the tool.

Juan Salvador Rios Hoyos- Oracle

Oracle Course Outlines

ID Name Duration Overview
34 SQL Fundamentals 14 hours This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases. RDBMS (Relational DataBase Management System) Relational Operators SQL as Declarative Language SQL Syntax SQL Sublanguages DQL, DML, DDL, DCL DQL (Data Query Language) in Detail SELECT clause Column aliases Table aliases Date types and Date functions Group function Table joins JOIN clause UNION operator Nested queries Correlated subqueries DML (Data Manipulation Language) Overview Inserting rows (INSERT) Inserting rows using subquery Updating rows (UPDATE) Deleting rows (DELETE) DDL (Data Definition Language) Overview Creating, altering and dropping objects (CREATE, ALTER, DROP) Creating tables using subquery (CREATE TABLE .... AS SELECT...) CONSTRAINTS Overview NULL i NOT NULL CONSTRAINT clause ENUM type SET type PRIMARY KEY UNIQUE FOREIGN KEY DEFAULT clause Transactions Overview COMMIT ROLLBACK SAVEPOINT Implicit and explicit rollbacks and commits SQL Dialects Overview MySQL Microsoft Access and SQL Server Oracle and PostgreSQL
1949 ORACLE SQL Fundamentals 21 hours This 3 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2. The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements. Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database. Introduction Overview Aims and Objectives Sample Data Schedule Introductions Pre-requisites Responsibilities Relational Databases The Database The Relational Database Tables Rows and Columns Sample Database Selecting Rows Supplier Table Saleord Table Primary Key Index Secondary Indexes Relationships Analogy Foreign Key Foreign Key Joining Tables Referential Integrity Types of Relationship Many to Many Relationship Resolving a Many-to-Many Relationship One to One Relationship Completing the Design Resolving Relationships Microsoft Access - Relationships Entity Relationship Diagram Data Modelling CASE Tools Sample Diagram The RDBMS Advantages of an RDBMS Structured Query Language DDL - Data Definition Language DML - Data Manipulation Language DCL - Data Control Language Why Use SQL? Course Tables Handout SQL*Plus SQL*Plus Login Easy Connect Using /NOLOG Using SQL*Plus Ending the Session SQL*Plus Commands SQL*Plus Environment SQL*Plus Prompt LOGIN.SQL File Changing the Password Finding Information about Tables Getting Help Where Clause Using SQL Files iSQL*Plus SQL*Plus Commands Data Retrieval SQL Developer SQL Developer - Connection Viewing Table Information Using SQL, Where Clause Using Comments Character Data Users and Schemas AND and OR Clause Using Brackets Date Fields Using Dates Formatting Dates Date Formats TO_DATE TRUNC Date Display Order By Clause DUAL Table Concatenation Selecting Text IN Operator BETWEEN Operator LIKE Operator Common Errors UPPER Function Single Quotes Finding Metacharacters Regular Expressions REGEXP_LIKE Operator Null Values IS NULL Operator NVL Accepting User Input Data Definition Creating a Table Datatypes Simple Create Example Naming Tables Constraints Not Null Primary Key Foreign Key Check Unique Altering Constraints Full Create Example Data Dictionary Alter Table Secondary Indexes B-tree Index Bitmap Index Create Index Explain Plan Using Indexes Clusters Partitioned Tables Creating a Partitioned Table Rename Drop Statement Flashback Table Managing the Recycle Bin Data Update Insert Some Values Insert All Values Insert Date Values Insert TO_DATE Default Values Using Substitution Variables Transactions Commit Rollback Using Constraints Update Date Arithmetic Update TO_DATE TRUNC Delete Truncate Sequences Grant Create Synonym Create Public Synonym Locking Revoke Savepoint Auto Commit Multi-Table Retrieval Calculations Precedence ROUND Function Column Alias Date Arithmetic Using Aliases CEIL and FLOOR Cartesian Product Table Join Table Alias Selecting the Join Column Joining without Selecting Views Dropping Views Finding Views Derived Columns With Check Option Snapshot Views Flashback Query Using Functions TO_CHAR TO_NUMBER LPAD RPAD NVL NVL2 Function DISTINCT Option SUBSTR INSTR Date Functions Aggregate Functions COUNT Group By Clause Rollup and Cube Modifiers Having Clause Grouping By Functions DECODE CASE Workshop Sub-Query & Union Single Row Sub-queries Union Union - All Intersect and Minus Multiple Row Sub-queries Union – Checking Data Outer Join More On Joins Joins Cross Join or Cartesian Product Inner Join Implicit Join Notation Explicit Join Notation Natural Join Equi-Join Cross Join Outer Joins Left Outer Join Right Outer Join Full Outer Join Using UNION Join Algorithms Nested Loop Merge Join Hash Join Reflexive or Self Join Single Table Join Workshop Advanced Queries ROWNUM and ROWID Top N Analysis Inline View Exists and Not Exists Correlated Sub-queries Correlated Sub-queries with Functions Correlated Update Snapshot Recovery Flashback Recovery All Any and Some Operators Insert ALL Merge Sample Data ORDER Tables FILM Tables EMPLOYEE Tables The ORDER Tables The FILM Tables PL/SQL What is PL/SQL? Why Use PL/SQL? Block Structure Sample Code SELECT Statement Using Variables Accepting User Input Exceptions Other DML Statements Creating Procedures Showing Errors Describe a Procedure Calling Procedures Creating and Running Functions Showing Errors Describe a Function Calling Functions Creating Triggers Showing Errors Query Optimisation Query Optimisation Creating The Tables Timing SQL Statements Other Timing Statements Explain Plan Creating the PLAN_TABLE Table Using SET AUTOTRACE Collecting Statistics Primary Key Secondary Indexes The Query Optimizer Rule Based Optimization Cost Based Optimization Choose Keyword Gathering Statistics Optimizer Hints How to Specify Hints Using Indexes Index Types B*tree Indexes Bitmap Indexes Index-organized table When to Create Indexes Choosing Composite Indexes Using Objects Object-oriented Database Object-relational Database Creating Objects Creating Tables with Objects Using Objects in Tables Large Object Support LOB Datatypes Creating Tables with LOBs Inserting an Empty LOB Creating Tables with BFILEs Creating Directories for BFILEs Inserting a BFILE SQL*PLUS REPORTS Objectives ACCEPT and PROMPT Define and Undefine Creating an SQL*Plus Report Break Command Compute Command Saving the Output in a File Utilities What is a Utility? Export Utility Using Parameters Using a Parameter file Import Utility Using Parameters Using a Parameter file Unloading Data Batch Runs SQL*Loader Utility Running the Utility Appending Data
1950 ORACLE PL/SQL Fundamentals 21 hours This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands. The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements. Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database. Introduction Aims and Objectives Course Schedule Introductions Pre-requisites Responsibilities SQL Tools Objectives SQL Developer SQL Developer - Connection Viewing Table Information Using SQL, SQL Developer - Query SQL*Plus Login Direct Connection Using SQL*Plus Ending the Session SQL*Plus Commands SQL*Plus Environment SQL*Plus Prompt Finding Information about Tables Getting Help Using SQL Files iSQL*Plus, Entity Models The ORDERS Tables The FILM Tables Course Tables Handout SQL Statement Syntax SQL*Plus Commands What is PL/SQL? What is PL/SQL? Why Use PL/SQL? Block Structure Displaying a Message Sample Code Setting SERVEROUTPUT Update Example, Style Guide Variables Variables Datatypes Setting Variables Constants Local and Global Variables %Type Variables Substitution Variables Comments with & Verify Option && Variables Define and Undefine SELECT Statement SELECT Statement Populating Variables %Rowtype Variables CHR Function Self Study PL/SQL Records Example Declarations Conditional Statement IF Statement SELECT Statement Self Study Case Statement Trapping Errors Exception Internal Errors Error Code and Message Using No Data Found User Exceptions Raise Application Error Trapping Non-defined Errors Using PRAGMA EXCEPTION_INIT Commit and Rollback Self Study Nested Blocks Workshop Iteration - Looping Loop Statement While Statement For Statement Goto Statement and Labels Cursors Cursors Cursor Attributes Explicit Cursors Explicit Cursor Example Declaring the Cursor Declaring the Variable Open, Fetching the First Row Fetching the Next Row Exit When %Notfound Close For Loop I For Loop II Update Example FOR UPDATE FOR UPDATE OF WHERE CURRENT OF Commit with Cursors Validation Example I Validation Example II Cursor Parameters, Workshop Workshop Solution Procedures, Functions and Packages Create Statement Parameters Procedure Body Showing Errors Describe a Procedure Calling Procedures Calling Procedures in SQL*Plus Using Output Parameters Calling with Output Parameters Creating Functions Example Function Showing Errors Describe a Function Calling Functions Calling Functions in SQL*Plus Modular Programming Example Procedure Calling Functions Calling Functions In An IF Statement Creating Packages Package Example Reasons for Packages Public and Private Sub-programs Showing Errors Describe a Package Calling Packages in SQL*Plus Calling Packages From Sub-Programs Dropping a Sub-Program Finding Sub-programs Creating a Debug Package Calling the Debug Package Positional and Named Notation Parameter Default Values Recompiling Procedures and Functions Workshop Triggers Creating Triggers Statement Triggers Row Level Triggers WHEN Restriction Selective Triggers - IF Showing Errors Commit in Triggers Restrictions Mutating Triggers Finding Triggers Dropping a Trigger Generating an Auto-number Disabling Triggers Enabling Triggers Trigger Names Sample Data ORDER Tables FILM Tables EMPLOYEE Tables Dynamic SQL SQL in PL/SQL Binding Dynamic SQL Native Dynamic SQL DDL and DML DBMS_SQL Package Dynamic SQL - SELECT Dynamic SQL - SELECT Procedure Using Files Using Text Files UTL_FILE Package Write/Append Example Read Example Trigger Example DBMS_ALERT Packages DBMS_JOB Package COLLECTIONS %Type Variables Record Variables Collection Types Index-By Tables Setting Values Nonexistent Elements Nested Tables Nested Table Initialisation Using the Constructor Adding to a Nested Table Varrays Varray Initialization Adding Elements to a Varray Multilevel Collections Bulk Bind Bulk Bind Example Transactional Issues BULK COLLECT Clause RETURNING INTO Ref Cursors Cursor Variables Defining REF CURSOR Types Declaring Cursor Variables Constrained and Unconstrained Using Cursor Variables Cursor Variable Examples
2141 Administering GlassFish Server with Java EE applications introduction 21 hours Introduction to GlassFish Server Overview of the Java EE Architecture GlassFish Background GlassFish Basic Architecture GlassFish Basic Features Installing and upgrading Installation Upgrade Administering and deploying applications Administration High Availability Administration Security Application Deployment Message Queue Administration Troubleshooting Troubleshooting Error Message Scaling and tuning the performance Deployment Planning Performance Tuning Developing applications Your First Cup: An Introduction to the Java EE Platform The Java EE Tutorial Application Development Guide Message Queue Developer's Guide for Java Clients Message Queue Developer's Guide for JMX Clients Message Queue Developer's Guide for C Clients Extending and embedding Add-On Component Development Guide Embedded Server Guide
287845 Oracle SQL Intermediate 14 hours Listeners All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge. Format of the course 25% lectures, 75% labs Create complex queries to databases Use available operators Queries with multiple conditions Creating tables and references DDL commands (create, alter, and drop) Create referential integrity Normalization of tables (up to 3 normal form) anomalies and ways to avoid them Changes in the structure of existing tables ALTER clause Manipulation of data DML commands (insert, update, delete) Creating new users and granting permissions DCL commands (grant, revoke) Linking Tables Internal and external joins Data Aggregation Features of grouping functions Use the GROUP BY clause and HAVING Grouping multiple column Subqueries multi-column correlated WITH clause
2566 Oracle SQL for beginners 21 hours Listeners This training is addressed for people starting to work with the SQL language in Oracle database The course answer for questions: How to build a query? What possibilities have SQL? What is a relational database? What is the structure and SQL commands Relational database models The structure of a relational database Connection types of tables The normalization and denormalization database Relational Operators Download the data Rules for writing SQL queries The syntax for the SELECT Selecting all columns Inquiries from arithmetic operations Aliases columns Literals Concatenation operator Limiting results The WHERE clause Comparison operators LIKE Condition Prerequisite BETWEEN ... AND IS NULL condition Condition IN Boolean operators AND, OR and NOT Many of the conditions in the WHERE clause The order of the operators. DISTINCT clause Sorting Data The ORDER BY clause Sorting by multiple columns or expressions SQL functions The differences between the functions of one and multilines Features text, numeric, date, Explicit and implicit conversion Conversion functions Nesting functions Viewing the performance of the functions - dual table Getting the current date function SYSDATE Handling of NULL values Aggregating data using the grouping Grouping functions How grouping functions treat NULL values Create groups of data - the GROUP BY clause Grouping multiple columns Limiting the function result grouping - the HAVING clause Retrieving data from multiple tables Types of connectors The use NATURAL JOIN Aliases tables Joins in the WHERE clause INNER JOIN Inner join External Merge LEFT, RIGHT, FULL OUTER JOIN Cartesian product Subqueries Place subqueries in the SELECT command Subqueries single and multi-lineage Operators Subqueries single-line Features grouping in subquery Operators Subqueries multi-IN, ALL, ANY How NULL values ​​are treated in subqueries Operators collective UNION operator UNION ALL operator INTERSECT operator MINUS operator Insert, update, and delete data INSERT command Copy data from another table UPDATE command DELETE command TRUNCATE command Transactions Commands COMMIT, ROLLBACK, and SAVEPOINT DDL commands The main database objects Rules for naming objects Creating tables The data types available for columns DEFAULT option Option NULL and NOT NULL Managing tables Referential integrity CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE Create a table by the query Delete a table DROP TABLE DESCRIBE command Other schema objects Sequences Synonyms Views
2565 Oracle SQL Advanced 14 hours Listeners This course is designed for people who want to use the advanced features of SQL in Oracle The course answers the questions How to build advanced queries? How to create advanced reports? Control user access User Management System permissions and object Granting Receiving permission Roles Using the links Managing schema objects ALTER TABLE command Adding, modifying, and deleting columns Add, remove, turn off constraintów Create indexes Flashback operations External tables Operations on large data sets MERGE command DML operations of podzapytaniami DML operations with RETURNING clause INSERT command multi tables Conditional expressions CASE expression DECODE expression Generate reports by grouping related data The GROUP BY clause The HAVING clause Aggregating data - ROLLUP and CUBE operators Identification summaries - GROUPING function Aggregating data - GROUPING SETS operator Managing data in different time zones Time zones Variations TIMESTAMP Differences between DATE and TIMESTAMP Conversion operations Advanced subqueries Subqueries Multi-column subqueries The subquery in the FROM clause Correlated subqueries WITH clause - re-use query blocks Join tables Inequality in the WHERE clause and the FROM clause Semijoin Antijoin The processing of hierarchical data The tree structure hierarchical Queries Pseudo column Sort data in a hierarchical query Useful functions Regular expressions Simple and complex patterns
Weekend Oracle courses, Oracle boot camp, Oracle instructor, Oracle on-site, Oracle trainer, Weekend Oracle training, Evening Oracle training, Oracle coaching, Evening Oracle courses, Oracle private courses, Oracle instructor-led , Oracle one on one training, Oracle classes

Some of our clients