Retrieving Data Using the SQL SELECT Statement
[ ]	List the capabilities of SQL SELECT statements
[ ]	Execute a basic SELECT statement
[ ]	Describe how schema objects work

Restricting and Sorting Data
[ ]	Limit the rows that are retrieved by a query
[ ]	Sort the rows that are retrieved by a query

Using Single-Row Functions to Customize Output
[ ]	Describe various types of functions that are available in SQL
[ ]	Use character, number, and date functions in SELECT statements
[ ]	Describe the use of conversion functions

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

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

Managing Objects with Data Dictionary Views
[ ]	Use the data dictionary views to research data on your objects
[ ]	Query various data dictionary views

Controlling User Access
[ ]	Differentiate system privileges from object privileges
[ ]	Grant privileges on tables
[ ]	View privileges in the data dictionary
[ ]	Grant roles
[ ]	Distinguish between privileges and roles

Managing Schema Objects
[ ]	Add constraints
[ ]	Create indexes
[ ]	Create indexes using the CREATE TABLE statement
[ ]	Creating function-based indexes
[ ]	Drop columns and set column UNUSED
[ ]	Perform. FLASHBACK operations
[ ]	Create and use external tables

Manipulating Large Data Sets
[ ]	Manipulate data using subqueries
[ ]	Describe the features of multitable INSERTs
[ ]	Use the following types of multitable INSERTs (Unconditional, Conditional and Pivot)
[ ]	Merge rows in a table
[ ]	Track the changes to data over a period of time

Generating Reports by Grouping Related Data
[ ]	Use the ROLLUP operation to produce subtotal values
[ ]	Use the CUBE operation to produce crosstabulation values
[ ]	Use the GROUPING function to identify the row values created by ROLLUP or CUBE
[ ]	Use GROUPING SETS to produce a single result set

Managing Data in Different Time Zones
[ ]	Use Various datetime functions

Retrieving Data Using Subqueries
[ ]	Write a multiple-column subquery
[ ]	Use scalar subqueries in SQL
[ ]	Solve problems with correlated subqueries
[ ]	Update and delete rows using correlated subqueries
[ ]	Use the EXISTS and NOT EXISTS operators
[ ]	Use the WITH clause

Hierarchical Retrieval
[ ]	Interpret the concept of a hierarchical query
[ ]	Create a tree-structured report
[ ]	Format hierarchical data
[ ]	Exclude branches from the tree structure

Regular Expression Support
[ ]	Using Meta. Characters
[ ]	Regular Expression Functions
[ ]	Replacing Patterns
[ ]	Regular Expressions and Check Constraints

ITPub博客

1Z0-047 Oracle Database SQL Expert