Oracle SQL

Level
Logo Focus on Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: Oracle and PL/SQL.

Focus on Training offers this product as a default in the following regions: N/A

Description

This course is designed for anyone who needs to access and work with an Oracle Database.

Essential Oracle SQL skills

This course is a suitable introduction to SQL as used in Oracle Databases and associated tools. The course covers SQL statements that query and update data as well as defining the data structure.

Course Objectives
To provide delegates with the knowledge and skills needed to retrieve and update data held in an Oracle Relational Database.

Skills Gained
This course will enable delegates to:

Describe the basic structure of a relational database
Use the command line features of SQL*Plus
Create SQL statements to select data from an Oracle Database
Generate simple reports from selected da…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, PL/SQL, CompTIA A+ / Network+ / Security+, IT Security, and Retail (Management).

This course is designed for anyone who needs to access and work with an Oracle Database.

Essential Oracle SQL skills

This course is a suitable introduction to SQL as used in Oracle Databases and associated tools. The course covers SQL statements that query and update data as well as defining the data structure.

Course Objectives
To provide delegates with the knowledge and skills needed to retrieve and update data held in an Oracle Relational Database.

Skills Gained
This course will enable delegates to:

Describe the basic structure of a relational database
Use the command line features of SQL*Plus
Create SQL statements to select data from an Oracle Database
Generate simple reports from selected data
Create and alter tables, indexes and views
Create, update and delete records
Grant and revoke access privileges
Access the Data Dictionary

Course Content

Relational Database Concepts

Using SQL*plus

SQL Select Statement

Selecting data from multiple tables

Inner Joins, Outer Joins and Self Joins

Grouping and sorting data

Sub-queries and In-line views

Character, Date and Numeric Functions

SQL*Plus run-time parameters and variables

SQL*Plus Control Parameters

Producing reports with SQL*Plus

Creating and changing tables and Views

Constraints and Indexes

Inserting, Updating and deleting data

Basic Transaction control

Controlling access to the database

Related Data Dictionaty tables and views

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.