Learning Oracle 12c - A Beginners Oracle Training Video

Explore Oracle's engineered systems, including the exit data system and Oracle Exalogic Elastic Cloud, designed for high database input/output processing, scalability, and pre-installed databases.

Explore Oracle's operating systems for hosting databases, including Solaris on SPARC and x86, and Oracle Linux with the unbreakable kernel, highlighting performance and database compatibility.

Explore Oracle virtualization offerings, from hardware and workstation virtualization to enterprise virtualization with Oracle VM server, and learn how virtual machines enable resource sharing and safer learning with VirtualBox.

Explore Oracle's middleware offerings and programming languages, including Java, and learn how the web server, application server, and data layer work together in a multi-tier enterprise architecture.

Explore what a database is, from flat file storage to relational databases like Oracle, and learn how entities, attributes, tables, rows, and columns enable normalization.

Explore the Oracle RDBMS and its relational database management system architecture, and learn cross-platform interoperability, acid compliance, in-memory performance, and recovery with RMAN and RAC.

Explore Oracle database editions and licensing models, including per-CPU and named-user pricing, and compare Enterprise Edition, Standard Edition, SE1, and Express Edition with Data Guard and auditing.

Trace how Oracle database versions evolved from version 2 to 12 c, highlighting milestones like 10 g grid computing, real application clusters, and the built-in multi-tenant architecture for cloud enablement.

Explore Oracle 12c database options, including advanced security, partitioning, and advanced compression. Discover how multitenant architecture with container and pluggable databases simplifies administration and cloning.

Explore downloading Oracle database 12c and related software from Oracle's site, including 64-bit Windows and Linux options, Oracle VM VirtualBox, and note that no 12c appliance exists for personal use.

Explore Oracle's official documentation across Oracle Linux, Solaris, Oracle VM, and database 12c, including installation guides, quick starts, and essential reference materials.

Explore how SQL Developer, Oracle's free, cross-platform GUI for database work, lets you connect to Oracle, browse tables, views, and packages, and run queries in a productive, Java-based environment.

Distinguish between an Oracle RDBMS instance and a database, explain their roles, architectures (single instance vs RAC), and how background processes, memory structures, and data files interact.

Examine how Oracle kernel background processes manage memory, recovery, and disk I/O, including Pieman, Essman, DBWn, checkpoint, LGWR, archiver, and archiving all redo logs.

Explore the system global area (sga) and its caches—buffer cache, shared pool, library cache, data dictionary cache, and log buffer—and see how memory accelerates Oracle operations.

Examine the program global area, a private memory pool for sorting and session variables, distinct from the shared sga. Oracle 9i introduces dynamic pga sizing for on-demand memory.

Explore Oracle's core data files and tablespaces, and see how control files, SCN, multiplexing, redo and archive logs, system tablespace, AWR, temp, and undo files support recovery and data management.

Explore the redo architecture of the Oracle database, covering complete and incomplete recovery, and compare no archive log mode with archive log mode and the roles of LGWR and archiver.

Explore real application clusters (RAC) in Oracle, where multiple machines share storage and connect via a high-speed network to act as a single, highly available database.

Explore Oracle 12c container databases and multitenant architecture, which uses a root database and PDBs to curb database sprawl and rapidly create development, test, and production databases.

Discover how Oracle 12c multitenant architecture uses container databases with pluggable databases to streamline provisioning, cloning, patching, and migration, letting you manage many databases as one.

Plan the Oracle 12c installation by outlining platform choices, hardware and software prerequisites, and key setup steps like Oracle base and Oracle home, plus OS user and db group configuration.

Explore the Oracle universal installer, a cross-platform, Java-based wizard with a silent install option, and learn about the Oracle inventory and OFA directory layout.

Install the Oracle 12c database software by following the wizard, selecting install database software only, choosing the enterprise edition, and configuring a single instance on Windows.

Learn to install Oracle database software by selecting the Oracle base and Oracle home, ensuring space, saving a response file, and running a guided or silent install.

Plan Oracle database creation by assessing memory and disk needs, size sga and pga, allocate shared pool and buffer cache, and tailor volumetrics for oltp or data warehouse workloads.

Learn to configure Oracle network using netca, set up the listener, and use dbca to create a database, including Oracle Enterprise Manager components and protocol or port options.

Start the database creation with the DBCA wizard in advanced mode, customize a database using templates and multitenant options, manage pluggable databases, configure Enterprise Manager, and set administrator passwords.

learn to create an oracle 12c database with bbca, configure storage options (file system or asm), enable oracle managed files, and set fast recovery area and memory.

Step through database creation with customized storage location and database configuration assistant, generate creation scripts, configure Oracle managed files, data files, redo logs, and review prerequisites and password security.

Set up and launch SQL Developer, resolve Java prompts, and create system and Scott connections to the test database.

Explore structured query language, the standard for relational databases, and its sublanguages—DML, DDL, DCL, and transaction control—through key statements like select, insert, update, delete, and commit.

Beginner oracle training: Master the select statement in sequel, using from, where, and order by to retrieve and sort data from the emp table, with semicolon terminators and whitespace rules.

Learn how to use the insert statement to add data to a database table, including data types, positional and named column notation, and executing inserts.

Explore the update statement in SQL to modify existing data, using the set clause to change values and the where clause to target specific rows.

Explore the delete statement in Oracle, using delete from with a where clause to remove specific rows, and learn how commit and rollback control transactions to prevent unintended data loss.

Explore how to join employee and department data using common columns, avoid cartesian products, and compare deprecated, alias, and ANSI join methods such as natural join and using.

Explore single row functions that operate on every row to transform data, using lower, knit cap, length, substring, two car function, and round, with format masks.

Master data aggregation in oracle 12c by applying multi-row functions to derive a single value from many rows, using count, average, min, max, sum, group by, and nested functions.

This lecture explains how Oracle builds an execution plan during parse, uses explain plan to compare table scans and index access, and shows how the plan affects performance.

Explore how concurrency preserves data consistency by grouping inserts, updates, and deletes into transactions that commit to visible changes, using undo data in the undo tablespace for rollbacks.

Discover PL/SQL, Oracle’s block-structured extension to SQL, enabling variables, loops, and persistent code for data applications and highlighting its role alongside ANSI standard SQL.

Explore anonymous blocks in pl/sql by declaring variables and cursors, looping through query results, and using server output to display employee data from the emp table.

Convert anonymous pl/sql blocks into stored procedures, compile with create or replace, and pass in in-parameters to drive queries backed by cursors.

Learn how Oracle's built-in single row and multi row functions work, and how to create a user-defined function that returns a value, such as a 10 percent raise, using dual.

Group related code into a package with a specification and a body, then compile and access procedures and functions via the package name.

Learn how to create an address object type in Oracle, store it in a table, and instantiate and query the object to access street and city.

Examine how oracle database blocks are the smallest storage unit read into the SGA buffer cache. Recognize block size fixed at creation, ranging 2k to 32k for OLTP and warehousing.

Understand how extents, composed of blocks, grow from the initial extent to the next extent, and compare dictionary managed extents with locally managed tablespaces in Oracle, affecting performance and fragmentation.

Discover how Oracle segments organize data as extents of blocks, including table segments, index segments, undo segments, temporary segments, and partitioned segments, plus lob storage.

Explore how Oracle stores data as data files containing segments, extents, and blocks, including nonspecific data files, undo data in the undo tablespace, and temp files for sorts.

Understand small file tablespaces as the default logical grouping of data files, with up to 1022 files, and use DBA_TABLESPACES and the dollar table space to manage them.

Learn how big file tablespaces work in Oracle 12c, featuring a one data file per tablespace, auto extend, and the ability to online, offline, or read only mode.

Explore automatic storage management (ASM) in Oracle databases, comparing file system, raw devices, and the ASM disk group model with dynamic rebalancing and performance benefits.

Discover the relational table structure, including rows, columns, and heap storage. Learn data types like car and number, and grasp date and basic create table syntax.

Explore partitioned tables and partition keys in Oracle 12c, including range, hash, list, and composite partitioning, to improve performance on large order entry data.

Explore temporary tables in Oracle 12c, created as global temporary tables, stored in temporary segments, with on commit delete rows or preserve rows controlling data per transaction or session.

Learn how b-tree indexes speed query performance by avoiding full table scans and enabling index scans, using the row ID to locate data, and creating single-column or composite indexes.

Bitmap indexes offer a fast alternative to b-tree indexes for low cardinality columns; test with explain plans to assess cost and note updates can be expensive.

Index organized tables structure data in an index rather than a heap, enabling dynamic row movement and efficient lookups for small lookup tables with exact matches.

Explore function based indexes to speed queries on derived values, such as selecting employees hired in a specific year, using explain plan to compare index range scans versus full scans.

Explore how views encapsulate a query as a database object to reduce complexity and enable data hiding, including updateable views, illustrated by joining EMP and DEPT.

Explore primary keys, unique keys, and foreign keys, and how constraints enforce data integrity in relational databases, including inline, out of line, and alter table creation methods.

Learn how foreign keys enforce data integrity by linking patient records to doctor records via primary keys, using named constraints and adding constraints after creation.

Explore check constraints in Oracle 12c to enforce data integrity, including inline, out-of-line, and after-creation constraints, with examples of hospital codes and allowed value sets.

Learn how Oracle synonyms act as aliases for database objects, simplifying schema notation. Explore private and public synonyms, their use cases, and the required privileges with Scott schema examples.

Explore how sequences generate sequential numbers for primary keys, compare natural versus synthetic keys, and see how nextval and currval advance a sequence to prevent duplicate keys.