Training Course:ORACLE FundamentalsSchool/Trainer:Catalyst Learning London, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' By the end of this course, the delegate will be able to:
Select data from an Oracle Database using SQL*Plus 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 Describe the Basic Structure of a PL/SQL Block Use PL/SQL IF Statements, Expressions and LOOP Constructs Declare and use Cursors Use record types and PL/SQL Tables Handle Errors and Exceptions within PL/SQL Scripts Topics Covered: The Structure of a Relational Database Using SQL*Plus The Basic SQL Select Statement Selecting Data from Multiple Tables Grouping and Sorting Output Character, Date and Numeric Functions SQL*Plus Run-time Parameters and Variables Producing Reports with SQL*Plus Creating and Changing Tables, Indexes and Views Inserting, Updating and Deleting Data Controlling Access to the Database Related Data Dictionary Tables and Views The Structure of a PL/SQL Block Declaring and Using Variables and Constants Using SQL Statements in PL/SQL PL/SQL Programming Constructs Declaring and Using Cursors Exceptions and Error Handling Record Types and PL/SQL Tables Requirements: An understanding of IT. Some practical programming experience would prove advantageous. ...''
Please go to the school's official website for training price and schedule: http://www.cbduk.biz
Phone:0800 953 0387
School Address:
175 Tottenham Court Road London, W1T 7NU UK
Jobs & Resumes: London Houses & Roommates: London
Other training courses offered by Catalyst Learning:
Linux System Administration (LPI)
Linux Advanced System Administration (LPI)
Lotus
Nortel Networks
MCDST, MCSA, MCSE, MCDBA, MCAD, MCSD
Novell
Relational Databases
Introduction to SQL
ORACLE Overview
PL/SQL
Oracle Program with PL/SQL
PL/SQL Web Applications
SQL Performance Tuning
Forms Web Deployment
DBA Fundamentals
Oracle Database 10g DBA using Enterprise Manager
10g Discoverer for Administrators
Oracle 10g Application Server Administration
Oracle 11i System Administration
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.
Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa. |
|
|