Writing Basic SQL Select Statements
- List the capabilities of SQL SELECT statements
- Execute a basic SELECT statement
- Differentiate between SQL statements and iSQL*Plus commands
Single-Row Functions
- Describe various types of functions available in SQL
- Use character, number, and date functions in SELECT statements
- Use conversion functions
Displaying Data from Multiple Tables
- Write SELECT statements to access data
- Outer joins
- Join a table to itself using a self-join
Aggregating Data using Group Functions
- Identify the available group functions
- Use group functions
- Group data using the GROUP BY clause
- Include or exclude grouped rows by using the HAVING clause
Producing Readable Output with iSQL*Plus
- Produce queries that require a substitution variable
- Produce more readable output
- Create and execute script files
|
Manipulating Data
- Describe each DML statement
- Insert,Update,Delete rows in a table
- rows from a table
- Merge rows in a table
Creating and Managing Tables
- Describe the main database objects
- Datatypes
- Alter table definitions
- Drop, rename and truncate tables
Including Constraints
- Describe constraints
- Create and maintain constraints
Creating Views
- Create, alter the definition, and drop
- Retrieve data through a view
- Insert, update and delete data
Creating Other Database Objects
- Create, maintain and use sequences
- Create and maintain indexes
- Create private and public synonyms
|
