SERGIO TOMASBack to portfolio
Get in touch

Databases · Tool

Oracle

Mission-critical relational data.

01Overview

Oracle Database powers mission-critical systems in large enterprises. I know how to design for it and integrate services with it, especially in Java ecosystems.

02Key concepts

What anyone working with it needs to understand

  1. 01

    PL/SQL

    Procedural extensions, packages and triggers.

  2. 02

    Schemas & tablespaces

    How Oracle organizes data and storage.

  3. 03

    Performance tuning

    Execution plans, hints and statistics.

  4. 04

    Transactions

    Read consistency, undo and redo.

  5. 05

    High availability

    RAC and Data Guard concepts.

  6. 06

    Integration

    JDBC and connection pooling from Java services.

03In practice
Part of my database toolkit (MySQL, SQL Server, Oracle) for enterprise integrations.
04Related