Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Oracle Training Courses

Oracle SQL 10g: Level 2

Course Code: ORSQL2      Days: 2
Show all Oracle Courses
Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.

Course Overview

This course is highly interactive and consists of theory coupled with plenty of hands on practical sessions. It will introduce delegates to the creation, security and maintenance of objects in an Oracle database. In addition the course will provide an understanding of SQL performance issues.

Audience

This course is for programmers, developers and support staff who wish to gain a comprehensive understanding of how to perform the more advanced tasks whilst developing and maintaining an Oracle Database.

Prerequisites

Delegates should have a good basic understanding of Oracle SQL and Oracle SQL*Plus. Previous attendance of our course, Oracle SQL Part 1, is highly recommended.

Skills Gained

On completion of the course delegates will be able to:

  • Utilise the SQL language to create and populate new objects.
  • Establish security for those objects.
  • Understand the performance of the SQL itself in respect of data retrieval.

Course Outline

  • Database Definition
  • Creating database objects
  • Creating tables
  • Altering tables
  • Renaming tables
  • Temporary tables
  • Btree indices in oracle
  • When to use btree indices
  • Creating btree indices
  • Altering indices
  • Bitmap indices
  • Index only tables
  • Partitioned tables
  • Clusters
  • Indexing
  • Hashing
  • Hashing vs. Indexing
  • Views
  • Materialised views
  • Synonyms
  • Sequences
  • Dropping objects
  • Quiz and practical session on database object definition
  • Oracle Data Dictionary
  • Introduction
  • Views
  • Quiz and practical session on oracle data dictionary
  • SQL Performance Issues & Tracing
  • Introduction
  • Index issues
  • Analyse & optimisation
  • Explain plan
  • Sql trace
  • Performance monitoring tools
  • Quiz and practical session on sql performance issues & tracing
  • Optimiser Hints
  • Introduction
  • Optimiser goal hints
  • Access method hints
  • Join order hints
  • Join operation hints
  • Parallel execution hints
  • Miscellanous hints
  • Quiz and practical session on sql performance issues
  • Query Rewrites
  • Introduction
  • Using query rewrites
  • The optimiser decision process
  • Quiz and practical session on query rewrites
  • Oracle Security Facilities
  • Introduction
  • Access to system pivileges
  • Access to database objects
  • Removing access to the database
  • Removing access to database objects
  • Quiz and practical session on oracle security facilities


How to make a booking for the ORSQL2 course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership