Sections of Oracle SQL with SQL Developer 19.2 Part I
Introduction to SQL
The SQL Developer Interface
Object Details Dialog
Limiting Records in the Data Tab
Ordering Records in the Data Tab
Manipulating SQL Output
Limiting Data in the SQL Worksheet
Ordering Data in the SQL Worksheet
Aggregating Values in SQL Worksheet
Joining Tables in an SQL Statement
Query Builder in the SQL Worksheet
Merging Tables in an SQL Statement
Regular Expressions in Oracle SQL
Exporting Data in SQL Developer
SQL Developer Help Facility
Sections of Oracle SQL with SQL Developer 19.2 Part II
Data Manipulation in SQL Developer
Data Manipulation in SQL Worksheet
Importing External Data
Table Manipulation in SQL Developer
Table Constraints and Indexes
Invisible Columns in Oracle 12c
Tree Walking Tables in SQL Worksheet
Sub-Queries in Oracle SQL
Advanced SQL Query Techniques
Using Merge Into
Export DDL (and Data)
SQL Developer Reports
SQL Developer Help Facility
Synopsis for Oracle SQL with SQL Developer 19.2 training course
Oracle SQL Developer 19c, it’s a four day course so normally it would need to start on a Monday or a Tuesday in order for the delegates (and our Training Consultant – but who cares about them) to have the weekend off,
but this is Seer Computing, probably the most flexible IT training Company in the UK and Ireland so if you need this course and it needs to start early, late or over a weekend we can do it for you, providing of course you are
either coming to our offices in Swansea or we are coming to you for onsite training.
If you choose onsite training not only do we come to you but we bring all the equipment needed for the course, at no point do we need access to your Oracle Database, we bring that, at no point do you Delegates need
to use your workstations, we bring those, at no point do they need to go and get paper and pens, we bring manuals and really nice pens with lights on the end (gimmicky we know but they are very nice), and no
point will our Training Consultant need to use your toilet … oh hang on I don’t think we can bring one of those with us … but you get the point we bring everything needed for the course, all you provide is a suitable room
and let your Delegates know what time and where we are going to be and we'll take care of the rest, we start at the time we agree with you (convenient for attendees with lives outside of work) and on the day you specify.
Our public courses are held at convenient conference centres throughout the UK and Ireland at various times of the year, if the course is just for yourself or a couple of Delegates this may be a better option,
having said that ask for a quotation from us for both and our Advisors will help guide you to choosing the best option, our quotations are no obligation and hassle free, you don’t get put on any mail list and all
enquiries are dealt with efficiently and politely. Quotations given are valid for six months or thereabouts and subject to vat changes we will honour the monies quoted, and we always give a spread of scenarios
to help you when exact numbers are unknown.
Now returning to the SQL Developer 19c course, this is a combination of Part 1 and 2 courses of the same version, the only difference being it's held four days in a row, same content, same high quality
manuals and same experienced Training Consultants. It is suitable for Delegates with differing levels of experience, some who already have SQL knowledge might find even at the start of the course that they pick up a number of
useful tips and techniques and certainly by the first afternoon they will be learning new areas for their work. Newbies to the SQL language will enjoy the pace of the course and will enjoy the opportunity we give throughout
the days to try out the techniques on one of the many exercises given.
Ideally the course is suitable for people who need to use SQL Developer 19c to access the Oracle Database to use SQL and the product to extract data from the Database to produce quality reports or just check up on
facts and figures to be incorporated in external reports. The term 'Power User' has been used to describe the type of person for this course, because after the initial two days the course will turn its attention to using
SQL Developer 19c to create objects within the Oracle Database, we'll focus on creating tables, views, indexing strategy etc as well as some more advanced SQL query techniques, take a look at the index for this course, its
lower down on this page, if it's only the first half you are interested in, pop over to have a look at the SQL Developer 19c Part 1 training course, this may be a better option.
Incidentally if you need SQL training but using SQLPlus instead of SQL Developer, have a look at the Essential SQL 19c course we provide, slightly different content but it may be of interest.
Anyway, get in touch, we answer all email enquiries within two hours of receiving them during work days and will always give you the best attention at all times.