Oracle 19c SQL using Apex 20 training course

Synopsis for Apex 20 with Oracle 19c SQL training course

When you need to learn SQL to work with an Oracle Database, Seer Computing is the best place to come in the UK and Ireland, we've been giving SQL courses for over 20 years and have a variety of different front-ends available to interface with the Oracle Database.

Traditionally Developers would use the interface provided by Oracle in the 1980s which was SQL*Plus and we still have a training course in SQL using SQL*Plus, this is a command line interface, it's not changed much over the years and still gives the Developer the quickest route into the Database, is it User friendly?, well no not really, every command needs to be typed in or copied and pasted in and that includes finding out the structure of tables using the 'describe' command.

Over the years Oracle and other software manufacturers have come out with a number of front end GUI products to use SQL against the Oracle Database. Most Oracle Developers will have used the Toad product created by Quest software but for Users of the Database it will prove too expensive to roll out to occasional Users.

In the 1990s a lot of Companies used the Discoverer software to roll out an Oracle Database to Users, this involved limiting the access of the Database using an End User Layer, regardless of the knowledge a person may have in SQL they could not influence the values stored in the Database as it the data was read only, Seer Computing still offer Discoverer courses if your legacy system still uses it.

Around the beginning of the 21st century, Oracle brought out two more products other than SQL*Plus and Discoverer for running SQL against the Database; SQL Developer and Application Express.

SQL Developer is a free to download product from the Oracle website and we feel is comparable to the Toad product already mentioned. SQL Developer gives the User access to all schemas they have access to, listing all Objects and their structures. SQL Users would be most interested in Tables, Views and Columns within them for example. SQL Developer also gives Users a number of other facilities such as creating Objects, inserting values and of course downloading data into other formats for other products such as Microsoft Excel. Seer Computing offer a number of SQL Developer courses.

Let's turn our attention to Application Express. One of the main advantages of using Apex for Users of SQL is that the SQL*Plus software does not need to be installed on an individual's machine, instead it is reached via a URL of the server. Apex like all front ends to an Oracle Database can never by-pass the Database's security features, therefore a DBA can dictate what access the User has for a particular Schema, in addition Apex has an Administration of its own which can remove a lot of the front end options from specific Users.

This course is designed primarily for Delegates who have little or no experience of SQL or Apex, not only does it teach them the main areas of SQL but also how to use the commands and techniques within the Apex environment. At this point the Delegates can stop if all they wish to learn is how to use SQL in Apex, however we also provide a four day course in developing PLSQL within Application Express, as well as a course on the main feature of Application Express; Creating web applications.

We recommend anyone needing to learn how to create Application Express applications to attend both the SQL and PLSQL courses first so that they will have an iron clad understanding of how Databases work before they tackle the front ends to go onto the Database. Delegates already with SQL and PLSQL knowledge and training can go directly to learn creating Apps with Seer Computing.

This course as well as every other course that Seer Computing performs is available on-site at your premises, we come to you bringing our complete workshop, which consists of networked workstations, and at no point do we need access to your networks or Databases. We can perform on-site training for one or more delegates up to twelve delegates at a time and in fact the more on a course the more cost effective the charges are.

Contact our training advisers, they will help you decide on the correct training strategy, give options for all courses you are interested in, both dates and prices and ultimately support you through the whole process. If you need more than one quotation, ask away we can cater for any scenario you want to discuss.

Payment for courses and indeed any of our other services is via invoice, all our charges are subject to vat at the current UK rate of 20%, this can be settled by Bacs, cheque or credit card (4% surcharge).