Oracle SQL

Harbrook
Bristol, Cirencester, Harrogate, London, Leeds, Maidenhead, Manchester, Reading, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' After completing this course, the student should be able to:

Describe the basic structure of a relational database
Use the command line features of SQL*Plus
Use SQL Developer to access an Oracle Database
Create SQL statements to select data from an Oracle Database
Use SQL run time parameters
Use aggregate functions
Use numeric, character, date, conversion and miscellaneous functions
Use subqueries
Create and alter tables, indexes and views
Create, update and delete records
Manage sequences and synonymns
Use the Data Dictionary

Course outline

The Structure of a Relational Database
Using SQL*Plus
Using SQL Developer
The Basic SQL Select Statement
Selecting Data from Multiple Tables
Inner Joins, Outer Joins and Self Joins
Grouping and Sorting Output
Sub-queries and In-line Views
Character, Date and Numeric Functions
SQL*Plus Run-time Parameters and Variables
Creating and Changing Tables and Views
Constraints and Indexes
Inserting, Updating and Deleting Data
Basic Transaction Control
Controlling Access to the Database
Related Data Dictionary Tables and Views ...''

Elements of this syllabus are subject to change.

Phone:0845 850 8060

School Address:

Claro Court Business Centre
Claro Road
Harrogate
N Yorks UK
HG1 4BA

Jobs & Resumes: Bristol, Cirencester, Harrogate, London, Leeds, Maidenhead, Manchester, Reading
Houses & Roommates: Bristol, Cirencester, Harrogate, London, Leeds, Maidenhead, Manchester, Reading
Travel Agencies: Bristol, London, Leeds, Manchester,

Search other schools for Oracle SQL training resources.

Configuring Juniper Networks Firewall/IPSec VPN Products
Configuring Juniper Networks Secure Access
Juniper Security Manager Fundamentals
Operating Juniper Networks Routers in the Enterprise
Operating Juniper Networks WX Application Acceleration Platforms
Linux Essentials
Red Hat Linux
MySQL
MySQL Database Administration
Oracle Database 10g DBA
Oracle SQL Advanced
Oracle SQL PL
Solaris Fundamentals
Solaris System Administration
UNIX
UNIX Shell Programming
VMware Virtual Desktop Manager
VMware Infrastructure 3
Certified Wireless Network Administrator

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.