Training Courses
Oracle Certified Oracle Database 11g Administrator Training

What is Oracle?

Oracle database is a relational database management system. It is known as Oracle database, OracleDB or simply Oracle. It is produced and marketed by Oracle Corporation. Oracle database is the first database designed for enterprise grid computing. The enterprise grid computing provides the most flexible and cost effective way to manage information and applications

CURRICULUM

Oracle

Module

Module

  • 2.1 Limit the rows that are retrieved by a query
  • 2.2 Sort the rows that are retrieved by a query
  • 2.3. Use ampersand substitution to restrict and sort output at runtime
    •

Module

  • 3.1 Describe various types of functions available in SQL
  • 3.2 Use character, number, and date functions in SELECT statements

Module

  • 4.1 Describe various types of functions available in SQL
  • 4.2 Use character, number, and date functions in SELECT statements
    •

Module

  • 5.1 Identify the available group functions
  • 5.2 Describe the use of group functions
  • 5.3 Group data by using the GROUP BY clause
  • 5.4 Include or exclude grouped rows by using the HAVING clause
    •

Module

  • 6.1 Write SELECT statements to access data from more than one table using equijoins and nonequijoins
  • 6.2 Join a table to itself by using a self-join
  • 6.3 UView data that generally does not meet a join condition by using outer joins
  • 6.4 Generate a Cartesian product of all rows from two or more tables
    •

Module

  • 7.1 Define subqueries
  • 7.2 Describe the types of problems that the subqueries can solve
  • 7.3 List the types of subqueries
  • 7.4 Write single-row and multiple-row subqueries

Module

  • 8.1 Describe set operators
  • 8.2 Use a set operator to combine multiple queries into a single query
  • 8.3 Control the order of rows returned
    •

Module

  • 9.1 Describe each data manipulation language (DML) statement
  • 9.2 Insert rows into a table
  • 9.3 Update rows in a table
  • 9.4 Delete rows from a table
  • 9.5 Control transactions
    •

Module

  • 10.1 Categorize the main database objects
  • 10.2 Review the table structure
  • 10.3 List the data types that are available for columns
  • 10.4 Create a simple table
  • 10.5 Explain how constraints are created at the time of table creation
  • 10.6 Describe how schema objects work
    •

Module

  • 11.1 Create simple and complex views
  • 11.2 Retrieve data from views
  • 11.3 Create, maintain, and use sequences
  • 11.3 Create and maintain indexes
  • 11.3 Create private and public synonyms
    •
;