Oracle Training

Oracle Database 11g: SQL Fundamentals I Training

Oracle Database 11g: SQL Fundamentals I – 

Course is designed to teach you the fundamentals of SQL using Oracle Database 11g database technology. Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.

Course Topics:

Retrieving Data Using the SQL SELECT Statement 

List the capabilities of SQL SELECT statements

Execute a basic SELECT statement

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

Using Single-Row Functions to Customize Output 

Describe various types of functions available in SQL

Use character, number, and date functions in SELECT statements

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

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 the 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 queries into 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 

Describe how schema objects work

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

Benefits to You

Build a foundation of SQL knowledge on your own time, from anywhere in the world that’s convenient for you. We have professional and Certified Trainers that will provide you professional ORACLE Certification exam preparation online in the entire world.