Oracle Courses

Microsoft Courses

Java Courses

Consultancy

HomeContact UsAbout UsDownloadFAQPublic CoursesLondonEdinburghBirminghamManchesterDublinLeedsCardiffNewcastleBelfastSwanseaOracle CoursesSQLSQL for Users Part 1Query BuilderEssential SQL10G SQL9i SQLUsing SQL with SQL DeveloperSQL Developer Part 1SQL Developer Part 2PLSQLPLSQL 1PLSQL 2PLSQL 10gPLSQL 9i9i New Features8i New FeaturesDiscoverer10g Administration10g Desktop10g Plus9iAdministrationDesktop4iAdministrationDesktop3.1AdministrationUserFormsForms 10gForms 9iForms 6iForms 6i New FeaturesReportsReports 10gReports 9iReports 6iReports 6i New FeaturesGraphics 6iDBA10g DBA 110g DBA 210g New Features9iNew Features for DBAsDBA 1DBA 2Database TuningNetwork AdministrationAS Basic Administration8iNew Features for DBAsDBA 1DBA 2Database TuningNetwork AdministrationMicrosoft CoursesWordExcelAccessPowerpointFrontpageProjectJava CoursesFundamentals of JavaJava ProgrammingJava SwingConsultancyDiscoverer ConsultancyData ConsultancyOracle Consultancy

Opening up the world of Oracle

Oracle Training Courses

Seer Computing offers specialist Oracle training for diverse clients across the UK, Ireland and Europe.

Browse our list of popular Oracle training courses below, including SQL, PLSQL, Discoverer and Oracle Forms and click here to find your next public training course or talk to us about easy onsite training.

SQL Training Courses

What is SQL?

SQL is Structured Query Language, pronounced 'sequel' or by its letters, SQL is a language specifically written for Users, Developers and Administrators to communicate with a Database. SQL can be used for querying records from the Database, inserting and updating records as well as creating objects. Objects can be as simple as Tables, Views or Sequences, or as sophisticated as the Database itself.

By its very name, its structure is very formalised and has strict programming conventions, its syntax will seem pretty unforgiving to the User attempting to learn the SQL language without proper guidance and training.

SQL Training from Seer Computing

Seer Computing offer training in Oracle SQL at a variety of different levels, for the occasional user right up to the professional Developer.

- One-day 'SQL for Users Part One' course
- Two-day 'Essential SQL' course
- Four-day '9i SQL' course
- Five-day '10g SQL' course

With comprehensive SQL training in the UK, Ireland and Europe, click here to be taken to our contact details.

Need to use SQL with a software package ? Seer can train your delegates using SQL*Plus, SQL Developer or Toad products.

Oracle Discoverer Training Courses

What is Discoverer?

Discoverer is an ad hoc reporting tool produced by Oracle to allow Users to access the Database using a GUI front end similar in style to Microsoft Excel, although with increased functionality similar in structure to SQL.

Oracle Discoverer can be rolled out to Users by using the 'Plus' version (accessed with a browser which needs the use of the Oracle Application Server) or by using 'Desktop' , installed on individual's PCs.

No previous experience of Databases or SQL is needed to learn to use Oracle Discoverer, however some aspects of the Discoverer product are easier to use (or dont have to rely on the Administrator) if the User has some SQL knowledge.

Although ad hoc at the User side, Oracle Discoverer needs to be set up and maintained by a Discoverer Administrator using the Discoverer Administrator product to control access and the view of the Database for Users using an End User Layer.

Discoverer Training from Seer Computing

Seer Computing runs Discoverer training courses for Users, Developers and Administrators. We've been supporting Discoverer End User Layers since Discoverer 3.1, through Discoverer 4i, Discoverer 9i and now our latest courses are for Discoverer 10G.

Three types of standard courses are available:

- The two-day course for Developers and Users in either the web-based version; Discoverer Plus, or the client based version in Discoverer Desktop.

- Three-day Discoverer Administrator course - develops the End User Layers to the highest standard of usability and professionalism and we offer comprehensive consultancy following the courses.

As with all our Discoverer courses, when presented onsite, Seer Computing can customise the content to suit your requirements.

Choose the course length and securely use data pertinent to your Company. Click here to find out more about onsite Discoverer training.

Oracle Developer Training Courses

What is PLSQL?

PLSQL or Procedural Language SQL is essentially Oracle's extended programming language created to allow Developers to perform tasks not normally possible with one single SQL statement. This includes techniques such as looping, error handling, validation and sophisticated inserting and updating of Database records.

In addition, PLSQL is used to create Database program units such as Triggers, Procedures and Functions, essential objects to ensure Database integrity.

PLSQL Training from Seer Computing

Seer Computing offer a variety of PLSQL courses:

- PLSQL I - The fundamental PLSQL programming course, this covers the essential techniques needed to develop using the language, covering all major topics.
- PLSQL II - This covers more advanced techniques of PLSQL programming.
- PLSQL 9i - This combines the PLSQL I and PLSQL II training courses and new features from version 9i of the Oracle Database.
- PLSQL 10G - This training course covers PLSQL I and PLSQL II and all the new features from version 10g of the Oracle Database.
- 8i New Features for Developers - For established Developers, this brings delegates up to speed with the major development features post Oracle 8i Databases.
- 9i New Features for Developers - For established Developers this covers the features of an Oracle 9i Database and above.

What is Oracle Forms?

Oracle Forms is a front end application designed to give Developers total control over Users and their access to an Oracle Database. Originally created with simple top down data fields for Users to query, create and amend records, latest versions of the product contains elements such as Tree Hierarchies, Check boxes, Radio Groups.

Complete systems can be built using Oracle Forms and Reports, and a lot of the functionality within Oracle Forms is created using built-in PLSQL objects, We therefore recommend the delegates attend the PLSQL I course before taking an Oracle Forms course.

Since version 9i of Oracle Forms the product can only be run via a web browser, necessitating the use of Oracle's Application Server, Forms 6i can be used via the browser or installed on individual user's PCs

Oracle Forms Training from Seer Computing

Seer Computing run three different versions of Oracle Forms training;

- Oracle Forms Version 6i
- Oracle Forms Version 9i
- Oracle Forms Version 10g

What is Oracle Reports?

Oracle Reports is a product designed to produce reports from an Oracle Database with accuracy and consistency, no matter how many times it is run or against any size Database.

A sophisticated program, Oracle Reports can be programmed to produce output in a variety of different styles from printable text to XML. In addition by using the build-in PLSQL, changes can be made to the Database when a report is run for auditing purposes for example.

Reports Training from Seer Computing

Seer Computing run three different versions of Oracle Reports training;

- Oracle Reports Version 6i
- Oracle Reports Version 9i
- Oracle Reports Version 10g

Oracle Database Administration Training Courses

What is a Database?

A Database is a collection of computer files which store data electronically for ease of access and manipulation, like an electronic filing cabinet.

A poorly organised Database will result in the data being held in tables difficult to access quickly or with little relevance to Users requirements.

What is a Relational Database?

A relational Database promotes efficient storage of data in the Database by reducing the amount of duplicate and redundant data held within the tables.

A relational Database works by identifying commonality within data and storing them in separate tables linking them together by relationships (commonly called foreign keys).

By placing the data in differant tables duplication can be avoided, for example if a manufacturer in Edinburgh produces 1000 different products it will be inefficient to store their contact details next to every product they supply, by placing the manufacturers details in one table and their products in another the data can be linked via possibly a Manufacturer Identifying code and both tables queried together to return all the details required.

Some modern relational Databases can hold thousands of tables most of which link to other tables to form complete records.

What is a DBA?

A DBA or Database Administrator is the person responsible for ensuring that the Database is running efficiently, their responsibilities can range from ensuring that the correct software patches are applied to making sure that there is sufficient storage for the Company's data.

A DBA will have many different skills from being able to program in SQL and PLSQL to understanding how the Database is organised, keeping a constant eye on the performance of the Database serving the Users.

Oracle DBA Training from Seer Computing

Seer Computing's DBA courses are designed to develop a DBAs skills in setting up, understanding, maintaining and improving an Oracle database, 8i, 9i and 10G versions of the Oracle Database are catered for.

Contact us now to talk about setting up your Oracle DBA Training course..