Book your SQL*Plus Training Course
This three day course is being run 22 times between Monday 18th June 2012 and Monday 10th December 2012 in London, Bristol, Leeds, Birmingham, Edinburgh, Manchester,
Book this course with us today from as little as £967.50 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
Sorry no downloadable outline found.Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Provider | Location | Rating | Price | ||
|---|---|---|---|---|---|---|
| Monday 18 June 2012 | StayAhead | London |  | Save £107.50 | £967.50+VAT | |
| Monday 25 June 2012 | StayAhead | Bristol | | Save £107.50 | £967.50+VAT | |
| Monday 02 July 2012 | StayAhead | Leeds | | Save £107.50 | £967.50+VAT | |
| Monday 09 July 2012 | StayAhead | London | | Save £107.50 | £967.50+VAT | |
| Monday 16 July 2012 | StayAhead | Birmingham | | Save £107.50 | £967.50+VAT | |
| Monday 06 August 2012 | StayAhead | Edinburgh | | Save £107.50 | £967.50+VAT | |
| Monday 13 August 2012 | StayAhead | London | | Save £107.50 | £967.50+VAT | |
| Monday 20 August 2012 | StayAhead | Manchester | | Save £107.50 | £967.50+VAT | |
| Monday 03 September 2012 | StayAhead | Bristol | | Save £107.50 | £967.50+VAT | |
| Monday 10 September 2012 | StayAhead | London | | Save £107.50 | £967.50+VAT | |
| Monday 24 September 2012 | StayAhead | Birmingham | | Save £107.50 | £967.50+VAT | |
| Monday 01 October 2012 | StayAhead | London | | Save £107.50 | £967.50+VAT | |
| Monday 01 October 2012 | StayAhead | Leeds | | Save £107.50 | £967.50+VAT | |
| Monday 15 October 2012 | StayAhead | Edinburgh | | Save £107.50 | £967.50+VAT | |
| Monday 22 October 2012 | StayAhead | London | | Save £107.50 | £967.50+VAT | |
| Monday 05 November 2012 | StayAhead | Bristol | | Save £107.50 | £967.50+VAT | |
| Monday 12 November 2012 | StayAhead | London | | Save £107.50 | £967.50+VAT | |
| Monday 19 November 2012 | StayAhead | Manchester | | Save £107.50 | £967.50+VAT | |
| Monday 26 November 2012 | StayAhead | Birmingham | | Save £107.50 | £967.50+VAT | |
| Monday 03 December 2012 | StayAhead | Edinburgh | | Save £107.50 | £967.50+VAT | |
| Monday 03 December 2012 | StayAhead | Leeds | | Save £107.50 | £967.50+VAT | |
| Monday 10 December 2012 | StayAhead | London | | Save £107.50 | £967.50+VAT |
|
|
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Summary:
This course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL*Plus. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.
PreRequisites:
- There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.
Audience:
- Anyone who needs to use and understand SQL to query and update an Oracle database.
Objectives:
- To provide the skills needed to query and update data held in an Oracle Relational Database.
Outline:
Course Contents - DAY 1
Session 1: RELATIONAL DATABASE CONCEPTS
- What is an Oracle Database
- Relational Database Structures
- Tables, Rows and Columns
- Indexes, Primary Keys and Foreign Keys
- Supported Datatypes
- The Data Dictionary
Session 2: USING SQL*PLUS
- What is SQLPlus
- Getting Started
- Entering and Executing SQL Statements
- Editing SQL Statements
- Creating, Editing and Executing SQL Files
Session 3: USING SQL DEVELOPER
- What is Oracle SQL Developer
- Starting SQL Developer
- Configure a Connection
- Navigation Tabs
- SQL Worksheet
Session 4: RETRIEVING DATA WITH THE SELECT STATEMENT
- The SELECT Statement
- The SELECT and FROM Clauses
- Conditions and the WHERE Clause
- Other Conditional Operators
- Logical Operators
- The ORDER BY Clause
- Column Aliases
- Arithmetic Expressions
- Precedence of Operators
Session 5: AGGREGATE FUNCTIONS
- Overview of Built In Aggregate Functions
- The GROUP BY Clause
- The HAVING Clause
Course Contents - DAY 2
Session 6: JOINING TABLES
- Overview of Table Joins
- Inner Joins
- Table Aliases
- Outer Joins
- Self Joins
- ANSI Standard Joins
- Set Operators
Session 7: NUMERIC, CHARACTER AND DATE FUNCTIONS
- Function Types
- Using the Table dual to try out Functions
- Numeric Functions
- Character Functions
- String Concatenation
- Date Arithmetic and Date Functions
Session 8: CONVERSION AND MISCELLANEOUS FUNCTIONS
- Conversion Functions
- The NVL and NVL2 Functions
- The DECODE Function
- CASE Expressions
- The COALESCE and NULLIF Functions
Session 9: SQL*PLUS PARAMETERS
- Command Line Substitution Parameters
- The Accept Command
- The Define and Undefine Commands
Session 10: USING SUBQUERIES
- Overview of Subqueries
- In-Line Views
- Top-N Queries
- Complex Subqueries
- Multi Column Subqueries
- Correlated Subqueries
- Subquery Rules
- Using the ANY, ALL and SOME Operators
Course Contents - DAY 3
Session 11: MANAGING DATA
- Inserting Rows
- Updating Rows
- Deleting Rows
- Verifying Updates
- Transaction Control
- Commit and Rollback
- Savepoints
- Commits and Constraints
- Amending Data in SQL Developer
Session 12: MANAGING TABLES
- Creating Tables
- Specifying Constraints
- Altering Tables, Columns and Constraints
- Dropping Tables, Columns and Constraints
- Copying Tables
Session 13: MANAGING INDEXES AND VIEWS
- Creating Indexes
- Dropping Indexes
- Listing Indexes
- Creating and Using Views
- Dropping Views
- Listing Views
Session 14: MANAGING SEQUENCES AND SYNONYMS
- Create a Sequence
- View Sequence Details
- Create a Synonym
- List Synonyms
Description:
This course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL*Plus. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.
StayAhead
StayAhead training has been offering high quality IT technical training courses since 1992. They specialise in UNIX, Oracle, Linux and MySQL training and pride themselves on the long term investments they put into attending delegates.
StayAhead has gained a reputation for offering high quality courses and is ranked as one of the UK’s top 50 business organisations in 2008.
Want to leave your own testimonial? click Here
The course is very well presented in a relaxed atmosphere. The trainers are easy to talk to and present the course in a friendly welcoming manner. Very flexible course learning style and the course materials are amazing. I recently bought an SQL teach yourself book and couldn't get to grips with some of the topics. The course covered the whole of the book and I now feel confident using SQL.