Preparando el Examen 1Z0-051 Oracle Database 11g: SQL Fundamentals I

El examen 1Z0-051 corresponde al examen Oracle Database 11g: SQL Fundamentals I conducente a las siguientes certificaciones:

1. Oracle 10g DBA OCA
2. Oracle9i DBA OCA
3. Oracle PL/SQL Developer Certified Associate

Los contenidos

1. Retrieving Data Using the SQL SELECT Statement

· List the capabilities of SQL SELECT statements

· Execute a basic SELECT statement

2. 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

3. Using Single-Row Functions to Customize Output

· Describe various types of functions available in SQL

· Use character, number, and date functions in SELECT statements

4. Using Conversion Functions and Conditional Expressions

· Describe various types of conversion functions that are available in SQL

· Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

· Apply conditional expressions in a SELECT statement

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

11. 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