Oracle Video Training Tutorials – 64 Hours
Here is a collection of over 64 hours of premium video tutorials on Oracle by Pluralsight. In order to view the videos, you need to become a member of Pluralsight.
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: Oracle 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 |