Learn Oracle 11g - A Comprehensive Training Course

Compare Solaris and Oracle Enterprise Linux as integrated operating systems for the Oracle stack, detailing OS-level virtualization with Solaris zones, encryption, self-healing filesystems, snapshotting, cloning, and scalable storage features.

Examine Oracle's middleware stack from application servers such as Oracle Application Server and WebLogic to Fusion Middleware powering Fusion Applications with CRM, HR payroll, HCM, governance and risk, and procurement.

Explore Oracle hardware innovations, from Exadata database machines and data appliances to X2 and X8 configurations, featuring offload storage, compression, SSD storage, and scalable, high-throughput systems.

Define what a database is and how it stores information, and explain the DBMS role, plus the ACID properties (atomicity, consistency, isolation, durability) for reliable transactions.

Catalogs the main database types: flat file databases, hierarchical, network, relational, object, and object-relational, plus key-value and document storage concepts; notes spatial and olap types are not covered.

Explore MySQL, a popular open source relational database management system developed by Oracle, with features like views, tables, and stored procedures, plus cross-platform support and language libraries.

TimesTen is an in-memory relational database delivering fast responses and high throughput. It serves as an embedded cache fronting Oracle, writing to disk with buffered access while maintaining real-time synchronization.

Discover Berkeley DB, an open source, embedded SQL-based ACID database library you plug into your application, storing data as binary files and supporting many languages with Java as default.

Explore NoSQL as a scalable, open-source key-value data store built on Berkeley DB, featuring a simple put/get/delete interface, built-in replication, and integration with Oracle appliances.

Explore the Oracle database server, a high-performance, secure relational database management system that runs on Linux, Windows, Unix flavors including z/Linux; it's sql-based, enterprise-grade, reliable, scalable, highly available.

Explore Oracle database server editions from enterprise to express edition, highlighting real application clusters, data guard, and partitioning, and how licensing and upgrades fit developers and enterprises.

Explore where Oracle freely provides documentation and software, including the main site and Oracle TechNet, with links to database releases, fusion middleware, express edition, and community forums.

Explore the Oracle database architecture across supported operating systems, led by Solaris and Linux as premier options, including Oracle Enterprise Linux, Red Hat, AIX, HP-UX, z/OS, z/Linux, and Windows.

Distinguish between a database server, a database, and an instance, describing how the binary database management system, hardware, data and configuration files, log files, and clustering relate.

Explore how the Oracle server stores data on disk as data files (binary files) accessed by a database instance, and how the database exists even when no processes run.

Explore the database instance, its memory storage area, and the background processes that manage data, including the sga with buffers and caches and the pga for individual sessions.

Explore Oracle background memory processes, including PMON, SMON, DBWR, LGWR, CKPT, archiver, and the recover process, and how redo logs and flashback data archive support recovery.

Explore how user processes act as the foreground connection between clients and the database, linking sessions via dedicated or shared servers and guiding active connection management.

Explore how the system global area, the instance-wide memory, stores buffers and shared data, including the buffer cache, redo log buffer, and the various pools.

Learn how system global area and program global area provide memory for Oracle processes, including per-session PGA, session memory, and the user global area in dedicated and shared server modes.

Explore Oracle net services that connect clients, middle tiers, and back ends using common protocols like TCAP and IP, with Oracle wrappers and the listener as key components.

Listen for incoming connections and route them to the correct database instance, as the listener uses PMON to register services and hand off users to the appropriate instance.

Real application clusters enable multiple database instances on separate servers to share a single database with a shared cache, delivering high availability and potential performance gains through parallel queries.

Explore how Oracle storage uses operating system physical blocks and Oracle data blocks as the smallest storage units, with data blocks containing headers, table data, rows, and free space.

Understand that an extent is a contiguous set of data blocks. Ensure extents are multiples of block size and show how Oracle stores tables and indexes.

Understand how extents form segments, the logical containers for tables, indexes, and partitions; learn how data blocks and extents combine into a segment.

Discover how a tablespace acts as a logical container for segments, and how those segments reside in one or more data files that physically store tables and indexes.

Learn how Oracle stores all application data and database content in data files, the physical OS files that form a tablespace, with multiple data files for performance and storage options.

Learn how the Oracle control file, a binary disk file that tracks data file locations, is essential to open and recover a database, with multiplexing across disks.

Explore online redo log files as a recovery method that records every database change to protect data loss and enable point-in-time recovery from archive redo and backups.

Identify server parameter file as a physical disk file storing initialization parameters such as processes, open cursors, memory, and database global name, with changes at the session level or restart.

Understand how the password file controls privileged access to the dbms, auto-adding entries when granting privileges, and how the pwt tool maintains its maximum entries for secure connections.

Automate and centralize recovery-related files with the fast recovery area, simplifying database administration. Store backups, redo, control files, and archived redo with retention policies to speed backups and recovery.

Explore the alert log, a physical disk file that stores error messages, informational messages, and exceptions from database operations; access via sml format or a readable text file.

Trace files are diagnostic files that capture session activity to help investigate problems and tune queries; enable tracing for a session and review parse, execute, fetch, and the execution plan.

Examine automatic storage management and grid technologies in Oracle 11g, including ASM disk pools, RAC, cloud provisioning, and encrypted backups to Amazon S3 for scalable, fault-tolerant storage.

Discover Oracle's data dictionary, a set of read-only objects describing the database, including tables, views, indexes, and permissions, and why it should never be updated directly.

Define users as database accounts with passwords and permissions, and schemas as containers for the users' objects; creating a user also creates a matching schema.

Explore how Oracle tables store data, including relational and object tables, with data types such as char, varchar2, number, date, and blob, plus virtual columns.

Partitioning splits large tables into partitions behind the scenes to boost performance and availability. Use a partition key with range, interval, list, or hash partitions and apply partition pruning.

Explore global temporary tables in Oracle 11g, learn how session- and transaction-scope data behave, and compare in-memory temp tables with permanent structures for efficient data handling.

Explore Oracle 11g b-tree indexes and how usable and invisible states, plus index monitoring, affect access paths. Learn about unique, reverse-key, descending, and composite indexes, plus range and skip scans.

Understand index organized tables, stored in primary key order to speed data retrieval. Compare IOT with B-tree indexes and learn when to partition and apply secondary indexes.

Explore how bitmap indexes use bitmaps to quickly filter low-cardinality columns, merge predicates, and support bitmap join indexes for efficient data warehouse queries.

Explore function-based indexes in Oracle 11g and how deterministic expressions like upper create index keys. Learn why non-deterministic expressions such as system date or current user cannot be indexed.

Explore how Oracle 11g views store a query, not data, create or replace views, and apply where clauses and aggregations, with updates that preserve primary keys.

Explore primary keys and unique constraints in Oracle 11g, including composite keys and not-null rules. Learn how constraints tie to indexes and enforce foreign keys.

Learn how foreign keys enforce referential integrity by linking child records to valid parent keys, including self-referencing relationships, with primary keys and department IDs.

Explains how check constraints enforce data validity in Oracle 11g, ensuring salary is between 10000 and 50000, commission is non-negative when provided, and name is not null.

Learn how synonyms act as aliases for schema objects to expand the database namespace, including private and public synonyms, and how permissions apply to underlying tables.

Explore Oracle 11g table clusters, where tables sharing common columns are stored together to reduce i/o for joins, using a cluster key and composite index, with limitations.

Oracle 11g sequences generate increasing numbers for surrogate and unique primary keys, ideal in data warehousing. They may have gaps from caching or rollbacks and aren’t in sync across replicas.

Oracle gathers statistics from the data dictionary to optimize access to tables and indexes, including table, index, column, and system statistics, automatically collected daily.

Learn how Oracle 11g performance views—dynamic (dollar) views, fixed views, and global views—reveal current database state, memory use, and cluster metrics within the data dictionary.

Explore Oracle SQL Plus as a console-based tool for accessing and programming the database across Windows and Linux, write PL/SQL with a text editor, run procedures, and recall commands.

Learn how to use SQL Developer to connect to databases, manage connections and the data dictionary, browse schemas, edit and run SQL scripts, view output, and explore data modeling tools.

Master the Oracle universal installer, a GUI wizard that prepares the environment, sets Oracle base and Oracle Home, and supports standard or custom installations.

Master Oracle Enterprise Manager to administer Oracle databases through a dashboard of health, alerts, and performance. Navigate schema, server, data movement, replication, and patches for security fixes.

Explore the oracle database configuration assistant to create, configure, and delete databases, choose types like general purpose, transaction processing, data warehouse, and customize templates and scripts.

Explore SQL's three statement types—DDL, DML, and transaction control—and learn to create tables, constraints, and sequences. Manage data with commits, rollbacks, and save points to control changes.

Master the basic select syntax to return rows from user tables, choosing all or specific columns, with from, where, and order by (asc/desc), using like and in with %.

Learn how to insert data into Oracle 11g tables, using insert into with column lists and values, handle sequences and scalar queries, and commit or rollback changes.

Use update statements to modify employee records, set addresses from a scalar subquery, apply where clauses, handle embedded quotes, and showcase salary updates and surrogate keys versus primary keys.

Master joining tables in Oracle 11g, using inner and outer joins to connect employees with departments and locations via foreign keys and column aliases.

Learn to delete records with and without a where clause, back up the employees table, and perform complex deletes to remove unused locations.

Learn how the merge statement in Oracle 11g combines insert and update operations, updating existing rows and inserting new ones from a backup and employees table.

Explore aggregates in Oracle 11g by summing salaries, grouping by department, joining department names, and rolling up to organization for analytical reports of average and max salaries.

Explore Oracle analytics to extend aggregates with partitioning and window clauses, producing company-wide and department-level salary metrics and comparisons to the average and max.

Explore how the Oracle query optimizer, a cost-based kernel, analyzes a select statement, assesses joins and access paths, and uses statistics and hints to generate efficient execution plans.

Explore transactions and concurrency in Oracle, detailing atomicity, consistency, isolation, durability, and ACID properties, with commit, rollback, undo/redo logs, and deadlock handling.

Explore how PL/SQL combines data manipulation with procedural programming in Oracle, covering blocks, variables, assignment, exceptions, collections, date math, concatenation, and embedded SQL.

Explore anonymous blocks, their nesting, and how they handle exceptions so execution continues after the block ends, with labels and the go to command.

Learn how to convert an anonymous block to a stored procedure in Oracle 11g, using in and out parameters, anchored types, and exception handling for single-row results.

Convert a prior procedure to a function in Oracle SQL, returning a value, using function calls in select and update statements to calculate raises and update salaries.

Explore how Oracle packages bundle related code into a public specification and private body, enabling secure access, reuse, and efficient dependency management.

Explore Oracle object types by defining a data and code object with a type specification and body; create constructors, methods, and a collection of objects using bulk collect.

Explore dynamic sql and native dynamic sql in oracle 11g, weighing compact syntax against dynamic column handling. Learn binding, parsing, executing statements, and using execute immediate for ddl and dml.

Explore Oracle APEX, a web app development environment for rapid creation from spreadsheets or CSV data, using workspaces, simple app creation, and interactive reports.

Explore the extensible markup language, a markup language that identifies data rather than displaying it, using employee records with elements like first name, last name, salary, and commission in xml.

Explore XMLDB in Oracle 11g, a high-performance set of database technologies for storing, generating, indexing, and transforming XML data with native SQL support and access via Java and WebDAV.

Learn XMLType in Oracle 11g by using an object type with methods and attributes, constructors, and string operations, then validate, transform with SSL, and view relational data as XMLType.

Explore sql/xml to generate xml fragments and documents from query results using ex-MIL element. Use ex-MIL AG and ex-MIL forest to aggregate fragments into a single valid xml document.

Explore XQuery in Oracle 11g, a declarative functional language for extracting and returning data from the employees view, with examples of rows and wrapping results in an employees tag.

Explore the Oracle XML repository, a database component storing resources as folders and files with paths, names, content, and access control lists, and linking XML data to SQL.

Explore XML storage models for SML: structured storage offers near relational queries and in-place updates, unstructured storage enables quick full-document access, and binary storage supports fast indexing of fragments.