0345 4506120

Oracle Database 11g: Introduction for Experienced SQL Users

This Oracle Database 11g Introduction for Experienced SQL Users training course is designed for students with previous ANSI SQL experience. On this Oracle 11g SQL course students are introduced to the Oracle Database 11g environment, SQL Developer, the SQ

We don't currently have any courses listed for Oracle Database 11g: Introduction for Experienced SQL Users, would you like to view all courses for Oracle?

Learning Objectives

The Oracle Database 11g Introduction for Experienced SQL Users course provides students with an overview of the basic elements of SQL. Students learn about the SELECT statement, pseudonyms, and different types of operators, conditions, expressions, and functions in SQL.

Students also learn how to query from tables using joins and other advanced subqueries. Students learn to create and manage database objects such as tables, views, indexes, sequences, and synonyms. In addition, you learn how to control user access to the database and how to create roles and grant privileges.

Pre-Requisites

PC Fundamentals

Course Content

Oracle Database 11g Introduction for Experienced SQL Users Training Course Contents

Understanding the Oracle Database Environment

  • Identify Oracle Database components
  • Define an instance and how to connect to it
  • Describe parsing of a SQL statement
  • Describe the processing of a SQL statement
  • Declare, reference, and display bind variables
  • Describe read consistency

Using SQL Developer

  • List the key features of Oracle SQL Developer
  • Install Oracle SQL Developer
  • Identify the menu items of Oracle SQL Developer
  • Create a database connection
  • Manage database objects
  • Use SQL Worksheet
  • Save and Run SQL scripts
  • Create and save reports

Getting Started with Oracle SQL

  • Execute a SELECT statement
  • Implement pseudocolumns in SQL
  • Utilize the different types operators, conditions, expressions, and functions in SQL
  • Convert between data types using explicit data type conversion
  • Describe how SQL treats NULL values

Combining Tables using Advanced Queries

  • Write subqueries
  • Update and delete rows using correlated subqueries
  • Explain the concept of hierarchical query
  • Perform joins in SQL
  • Create a tree-structured report
  • Exclude branches from the tree structure

Creating and Managing Tables

  • Create and maintain tables by using the CREATE, ALTER, DROP, RENAME, and TRUNCATE statements
  • Use the data dictionary to view and maintain information about tables
  • Create and maintain integrity constraints
  • Discuss constraint states

Creating and Managing Other Oracle Database Objects

  • Create and maintain a view
  • Retrieve, insert, update, and delete data through a view
  • Create, maintain, and use sequences
  • Create and maintain indexes
  • Create private and public synonyms

Controlling User Access

  • Discuss the concepts of users, roles, and privileges
  • Create users
  • Create roles
  • Grant and revoke object privileges
  • Create and access database links

Oracle Database Extensions to DML and DDL Statements

  • Describe the features of multi table INSERT statements
  • Use multi table INSERT statements
  • Merge rows using the MERGE statement
  • Create and use external tables
  • Describe transaction processing

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include