Oracle Video Training Tutorials – 64 Hours

Here is a collection of over 64 hours of premium video tutorials on by Pluralsight. In order to view the videos, you need to become a member of Pluralsight.

The logo of Oracle Corporation
The logo of Oracle Corporation
By Oracle Corporation. Original uploader was Cristan at en.wikipedia – Transferred from en.wikipedia(Original text : the German Wikipedia where it was uploaded by Afrank99.), Public Domain, https://commons.wikimedia.org/w/index.php?curid=11777903

Background: is an object-relational database management system created by Oracle Corporation.

Larry Ellison and his two friends and former co-workers, Bob Miner and Ed Oates, started a consultancy called Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex.

An Oracle database system—identified by an alphanumeric system identifier or SID—comprises at least one instance of the application, along with data storage. An instance—identified persistently by an instantiation number (or activation id: SYS.V_$DATABASE.ACTIVATION#)—comprises a set of operating-system processes and memory-structures that interact with the storage. (Typical processes include PMON (the process monitor) and SMON (the system monitor)). Oracle documentation can refer to an active database instance as a “shared memory realm”.

The server-side memory-structure is called the SGA (System Global Area). The SGA usually holds cache information. Examples of cache information include: data-buffers, SQL commands, and user information. In addition to storage, the database consists of online redo logs (or logs), which hold transactional history. Processes can in turn archive the online redo logs into archive logs (offline redo logs), which provide the basis (if necessary) for data recovery and for the physical-standby forms of data replication using Oracle Data Guard.

If the Oracle database administrator has implemented Oracle RAC (Real Application Clusters), then multiple instances, usually on different servers, attach to a central storage array. Some of the benefits of this configuration include: better performance, scalability and redundancy. However, support becomes more complex, and many sites do not use RAC. In version 10g, grid computing introduced shared resources where an instance can use (for example) CPU resources from another node (computer) in the grid. The advantage of Oracle RAC is that the resources on both nodes are used by the database, and each node uses its own memory and CPU. Information is shared between nodes through the interconnect—the virtual private network.

The Oracle DBMS can store and execute stored procedures and functions within itself. PL/SQL (Oracle Corporation’s proprietary procedural extension to SQL), or the object-oriented language Java can invoke such code objects and/or provide the programming structures for writing them.

Oracle

Series Title Date Presenter Min
Triggers in Oracle Triggers in Oracle 10/16/2015 Pankaj Jain 165
Getting Started with JD Edwards EnterpriseOne Business Services Getting Started with JD Edwards EnterpriseOne Business Services 8/14/2015 Shaun Meyer 145
Working with Collections in Oracle PL/SQL Working with Collections in Oracle PL/SQL 5/8/2015 Pankaj Jain 293
Oracle Developer Essentials: Views, Synonyms and Triggers Oracle Developer Essentials: Views, Synonyms and Triggers 2/17/2015 David Berry 100
Oracle Developer Essentials: Data Types Oracle Developer Essentials: Data Types 1/28/2015 David Berry 157
Oracle Developer Essentials: Tables and Indexes Oracle Developer Essentials: Tables and Indexes 1/28/2015 David Berry 310
SQL Data Wrangling in Oracle: Table Data SQL Data Wrangling in Oracle: Table Data 11/27/2014 Scott Hecht 318
Oracle PL/SQL: Transactions, Dynamic SQL & Debugging Oracle PL/SQL: Transactions, Dynamic SQL & Debugging 11/20/2014 Pankaj Jain 242
Oracle Database 12c Performance Tuning and Optimization Oracle Database 12c Performance Tuning and Optimization 9/24/2014 Tim Warner 177
Oracle Database 12c Disaster Recovery and Data Movement Oracle Database 12c Disaster Recovery and Data Movement 8/12/2014 Tim Warner 207
Oracle Database 12c Fundamentals Oracle Database 12c Fundamentals 6/28/2014 Tim Warner 222
Oracle Database 12c: Installation and Upgrade Oracle Database 12c: Installation and Upgrade 6/28/2014 Tim Warner 168
Oracle Performance Tuning for Developers Oracle Performance Tuning for Developers 6/24/2014 David Berry 422
Oracle PL/SQL Fundamentals – Part 2 Oracle PL/SQL Fundamentals – Part 2 6/14/2014 Pankaj Jain 310
Optimizing SQL Queries in Oracle Optimizing SQL Queries in Oracle 4/15/2014 Scott Hecht 227
Oracle PL/SQL Fundamentals – Part 1 Oracle PL/SQL Fundamentals – Part 1 3/3/2014 Pankaj Jain 269
Introduction to Dates, Times and Intervals in Oracle Introduction to Dates, Times and Intervals in Oracle 12/6/2013 Scott Hecht 144
      Total 3876