Oracle Certified Oracle Database 11g Administrator

Discussion in 'Oracle' started by Deepika, Oct 8, 2015.

  1. Deepika

    Deepika New Member

    Joined:
    Oct 8, 2015
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    Oracle Database 11g: SQL Fundamentals certification exams has a defined Syllabus to check your expertise. As per Oracle Official website, following is the list of chapters and covered topic to be examined in the certification exams.

    Retrieving Data Using the SQL SELECT Statement
    List the capabilities of SQL SELECT statements

    Execute a basic SELECT statement

    Restricting and Sorting Data

    Limit the rows that are retrieved by a query


    Sort the rows that are retrieved by a query

    Use ampersand substitution to restrict and sort output at runtime

    Using Single-Row Functions to Customize Output

    Describe various types of functions available in SQL

    Use character, number, and date functions in SELECT statements

    Using Conversion Functions and Conditional Expressions

    Describe various types of functions available in SQL

    Use character, number, and date functions in SELECT statements

    Reporting Aggregated Data Using the Group Functions

    Identify the available group functions

    Describe the use of group functions

    Group data by using the GROUP BY clause

    Include or exclude grouped rows by using the HAVING clause

    Displaying Data from Multiple Tables

    Write SELECT statements to access data from more than one table using equijoins and nonequijoins

    Join a table to itself by using a self-join

    View data that generally does not meet a join condition by using outer joins

    Generate a Cartesian product of all rows from two or more tables

    Using Subqueries to Solve Queries
    Define subqueries

    Describe the types of problems that the subqueries can solve

    List the types of subqueries

    Write single-row and multiple-row subqueries

    Using the Set Operators

    Describe set operators

    Use a set operator to combine multiple queries into a single query

    Control the order of rows returned

    Manipulating Data

    Describe each data manipulation language (DML) statement

    Insert rows into a table

    Update rows in a table

    Delete rows from a table

    Control transactions

    Using DDL Statements to Create and Manage Tables

    Categorize the main database objects

    Review the table structure

    List the data types that are available for columns

    Create a simple table

    Explain how constraints are created at the time of table creation

    Describe how schema objects work

    Creating Other Schema Objects

    Create simple and complex views

    Retrieve data from views

    Create, maintain, and use sequences

    Create and maintain indexes

    Create private and public synonyms
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice