Course Outline
To enable the creation, manipulation, extraction of data from an Oracle database it is essential to have a thorough understanding of the SQL Language. The course takes you through creating and populating relational data structures, querying that data and using SQL*Plus as a reporting tool. The course is organised into chapters covering the course objectives in a lecture format interspersed by sets exercises designed to illustrate the points covered and are completed by the delegate. See also our 2-day Introduction to SQL - Relational Database Design & Info Retrieval which is a great introduction to the generic SQL language and can be applied to any relational database that adheres to SQL standards (SQL Server,Access, Oracle, Sybase etc)
Course Content
This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email sales@jbinternational.co.uk
What you will learn
1. Create and maintain Oracle tables.
2. Insert, update, delete data from Oracle tables.
3. Produce complex queries.
4. Format queries in to Reports.
Oracle 9i Intro to SQL Training Course Outline
Introduction to SQL.
What is SQL and what is it used for?
Data Dictionary
Using the Data Dictionary
The SELECT Statement
Mandatory Clauses
The WHERE Clause
The ORDER BY Clause
Substitution Variables
Lexical and Bind variables
Functions
Numeric, Character, and Miscellaneous Functions
Group Functions SUM, AVG, COUNT, STDDEV
Rollup, Cube
GROUP BY and HAVING Clauses
Sub-queries
Queries within Queries
Basic Sub Queries
Complex Sub Queries
EXISTS and NOT EXISTS Clauses
Joining Tables
Cartesian Products
Standard Table Joins
Self Referencing Table Joins
Inner and Outer Joins
Report Formatting
Page Settings
Page Titles
Page Numbering
Views
Creating Views
Restricting Data Access with Views
Simplifying Database Design
Users, Privileges and Synonyms, Security
Changing your password
Allowing Other Users Access to Your Tables
Data Manipulation
Inserting Data Into Tables
Updating Data
Deleting Data
Table Locking
Commit and Rollback
Table and Row Level Locking
Assigning your own Locking Level
Nested functions
Advanced SQL*Plus Techniques
Generating SQL from SQL
Spooling Output
Copying Tables
SQL*Plus Performance Tuning, using Explain Plan
Basic Performance Tuning
Performance Information using Explain Plan Utility
