Oracle Courses

Oracle Database Management 11g (SQL, OCA, OCP)

This course offers a comprehensive introduction to Oracle Database 11g. You learn how to design, build and manage robust database applications with Oracle database tools. Oracle 11g is a large, complex system. This course provides an overview of the power and flexibility of Oracle databases and serves as the foundation for other courses in the Learning Tree Oracle Databases curriculum.

Register Now



  • Weekdays – 4 Months
  • Weekends – 6 Months

Course Description

The Oracle Database 11G Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup/recovery techniques.

The Oracle Database 11G Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has such as performing backup and recovery, diagnosing and repairing data failures with Flashback technology etc

Who will benefit from this course? This course benefits a wide range of professionals, including:

  • Developers, analysts, administrators, managers, programmers, consultants, power users and others who design and write Oracle applications using Oracle 11g
  • Database administrators who want to become proficient in querying and manipulating an Oracle database
  • Data processing professionals with experience working in a traditional database system (hierarchical or network), who are now moving to a client/server or Web environment Technology managers and project leaders who need a general overview of Oracle 11g

Certificate Earned

  • Oracle Certified Associate (OCA), Oracle Certified Professional (OCP)

Career Prospects

  • Database Administrator, Data Analyst, IT manager, IT Consultants

Course Outline

  • Introduction to Oracle 11g Technology – Applying data modeling techniques – Oracle database tools: SQL Developer and SQL*Plus
  • Database Installation and Administration Assessing the Oracle database architecture – Defining memory structures, processes and SGA – Establishing a storage framework
  • Managing Oracle databases – Configuring Oracle Database 11g – Working with Oracle SQL Developer
  • Accessing and Manipulating Data Retrieving data efficiently with SQL Developer- Selecting, restricting and ordering data – Avoiding pitfalls in null values – Exploiting built-in SQL functions
  • Applying powerful SQL techniques – Joins, outer joins and ANSI joins – Grouping data and applying aggregate functions – Combining result sets with set operators – Comparing simple and correlated subqueries
  • Modifying data with SQL statements – Inserting, updating, deleting and merging data – Controlling transactions with ROLLBACK and COMMIT
  • Creating and Managing Database Objects Implementing the physical design- Mapping logical model to physical design – Creating users and schemas
  • Constructing and maintaining tables – Altering and dropping columns – Restoring data with Flashback and the recycle bin
  • Building views, sequences and synonyms – Filtering data with views – Generating unique IDs with sequences – Streamlining access to objects with synonyms
  • Maintaining Integrity, Security and Performance Enforcing integrity – Implementing referential integrity with primary, unique and foreign keys – Managing transactions and data with deferred and enforced constraints
  • Securing the data – Authenticating users with password aging – Controlling access with system and object privileges – Simplifying privilege management with roles
  • Improving performance – Guidelines for creating indexes – Indexing the data for optimal access – Managing unique, nonunique and composite indexes
  • Programming with PL/SQL Writing basic programs – Controlling logic with IF and CASE statements – Performing iterations with WHILE and FOR LOOPs – Defining and managing PL/SQL records – Trapping errors with exception handlers
  • Processing data with cursors – Declaring cursors to perform row-level operations – Passing parameters to cursors to increase flexibility – Simplifying cursors with FOR LOOPs – Improving performance with CURRENT OF or ROWID
  • Implementing Server-Side Logic Modularizing code – Constructing procedures and functions – Debugging programs with DBMS_OUTPUT
  • Creating packages and triggers – Bundling subprograms in packages – Defining statement and row-level triggers – Governing triggers with conditional predicates