Oracle Database 11g: SQL Fundamentals I
About This Course
This course is offered as an e-Learning course and is comprised
of four (4) modules.
Target Audience
Database Administrators, Database Designers, Developer Support
Engineers, and Technical Administrators.
Module 1: Oracle Database 11g: Using SQL to Query Your
Database
Overview/Description
To identify the concepts and components of an Oracle Database
11g database, recognize how to retrieve information from it using
SQL, and identify the steps for sorting, limiting, modifying, and
formatting this information.
Lesson Objectives
Oracle Database 11g: Using SQL to Query Your
Database
- identify the functions, capabilities, and terminology
associated with Oracle Database 11g's components and relational
databases in general.
- recognize the steps for using Oracle SQL Developer to create a
new database connection and browse tables.
- recognize the steps for using the SQL SELECT statement to
retrieve different sets of data from a database.
- recognize the steps for limiting and ordering the rows returned
by a SQL query.
- recognize ways to sort data returned by a SQL query, using
substitution variables as well as the DEFINE and VERIFY
commands.
- recognize the steps for using SQL functions to modify, format,
and otherwise manipulate returned data.
- identify and write SQL queries to display, sort, and format
output in a given scenario.
Module 2: Oracle Database 11g: Conversion Functions,
Group Functions, and Joins
Overview/Description
To recognize the steps for writing queries that convert data
from one type to another, specify conditions, perform calculations
on groups of rows or even tables, and return values from more than
one table.
Lesson Objectives
Oracle Database 11g: Conversion Functions, Group
Functions, and Joins
- identify the steps for using functions to convert character,
date, and numeric values and perform operations pertaining to null
values.
- recognize the steps for using the CASE expression and the
DECODE function to implement conditional processing.
- identify and write queries that convert data types and
implement conditional processing, in a given scenario.
- recognize the benefits of using group functions to return
values for groups of rows.
- identify the steps for creating, restricting, and nesting group
functions.
- identify the steps for using joins to return data from more
than one table.
- write queries that calculate values for groups of data and
return values from multiple tables in a given scenario
Module 3: Oracle Database 11g: Subqueries, Set
Operators, and Data Manipulation
Overview/Description
To identify the steps for manipulating queries to return the
data you need, using subqueries and set operators, and also for
manipulating the actual data using INSERT, UPDATE, DELETE and other
data manipulation language (DML) statements.
Lesson Objectives
Oracle Database 11g: Subqueries, Set Operators, and Data
Manipulation
- recognize the steps for using subqueries inside other queries
to perform various actions.
- identify the steps for using set operators to combine the
results of two or more queries.
- write queries using set operators.
- identify the steps for adding new rows to a table, modifying
table data, and removing rows.
- recognize the steps for controlling database transactions, and
implementing read consistency.
- insert, update and delete rows in a table, and control data
transactions to it.
Module 4: Oracle Database 11g: Using DDL, Views,
Sequences, Indexes, and Synonyms
Overview/Description
To recognize the steps for creating, defining, and dropping
tables , manipulating how their data can be viewed, and using
schema objects to generate integers, improve queries, and rename
tables.
Lesson Objectives
Oracle Database 11g: Using DDL, Views, Sequences,
Indexes, and Synonyms
- recognize the steps for creating, defining, and naming a table,
and for specifying data types for its columns.
- recognize the steps for using constraints to prevent invalid
data entry into tables.
- recognize the steps for altering or dropping a table.
- identify the steps for creating and manipulating views to view
or hide a table's data.
- recognize the steps for using sequences to create integers,
using indexes to improve the performance of queries, and using
synonyms to give a table an alternative name.
- create a new table and create and use a sequence, index, and
synonym.