Oracle 11g DBA Technology 

List the features of Oracle Database 12c

Discuss the basic design, theoretical, and physical aspects of a relational database

Categorize the different types of SQL statements

Describe the data set used by the course

Generate a report of data from the output of a basic SELECT statement

Select All Columns

Select Specific Columns

Use Column Heading Defaults

Use Arithmetic Operators

Describe the differences between single-row and multiple-row functions

Manipulate strings with character functions in the SELECT and WHERE clauses

Manipulate numbers with the ROUND, TRUNC, and MOD functions

Perform arithmetic with date data

Describe implicit and explicit data type conversion

Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

Nest multiple functions

Apply the NVL, NULLIF, and COALESCE functions to the data

Categorize the main database objects

Review the table structure

List the data types available for columns

Create a simple table

Decipher how constraints can be created at table creation

Differentiate system privileges from object privileges

Create Users

Grant System Privileges

Create and Grant Privileges to a Role

Add, Modify, and Drop a Column

Add, Drop, and Defer a Constraint

How to enable and Disable a Constraint?

Create and Remove Indexes

Create a Function-Based Index

Data Model Columns

Maintaining Data Source Columns

Producing File Content Output

Creating a Column

Creating Summary Columns

Running Reports Using OracleAS Reports Services

Report Request Methods

Oracle Application Server Components

Enabling Single Sign-On Access

Running the Web Layout: JSP Run-time Architecture