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 Part II
Part 2 naturally follows a Part 1 of a training course, unless of course the Company has decided to use roman numerals in that case, Part ii would follow Part i, here at Seer Computing we don’t
like to over-complicate things, Part 2 of the Oracle SQL Developer 19c course follows on from where we left off on Part 1, to re-cap, Part One of the SQL Developer 19c course left the Delegates with a very
strong understanding of how to use the SQL Developer interface for extracting data and producing relevant information having manipulated the SQL to filter, group and produce readable output. We will assume on this
course that the Delegates will have already attended the Part 1 course or at least have a good understanding of these techniques, Part 2 therefore (as all good sequels do) will continue the story from that point on.
We've published the index for the SQL Developer Part 2 course lower down on this page but this course concentrates on techniques in changing the Oracle Database, updating and inserting data, creating tables and
views and deep breath, dropping Oracle Database objects, of course all this depends on whether the Oracle Database Administrator grants the Delegates the relevant permissions to perform these tasks, but on this course we
explain everything and let them practice it in our controlled environment. Did we say controlled environment? yes, we use our own Oracle Databases, they are not let loose on your live systems to practice, we come with our own
workstations and Oracle Database machine and need no access to your systems, in fact on other courses we even bring our own wireless hubs for users to access the Internet.
When we teach Delegates about a certain aspect of using SQL Developer with the Oracle Database we talk about best practices too, for example, when we look at indexing tables not only do we give the syntax for Primary Keys,
Foreign Keys, Unique Keys and non-Unique keys, we also discuss the benefits of using each, we discuss what makes good index able columns and we talk about the consequences of too many or the wrong types of indexing strategy –
this we can do because we create Oracle Databases as part of our Consultancy roles for other clients and we've been doing it for over 20 years.
The Oracle SQL Developer Part 2 course is available onsite or we can set it up at a local conference centre near to your venue, location is not an issue, our Consultants regularly travel to all extremes of the British Isles
and Ireland, we will also come to you anywhere providing the course can be presented in English.
This Part 2 course is also available together with its Part 1 partner as a four day public event, the difference between a public and onsite training course is that the public is available throughout the year at various locations,
we have fixed the dates and the venue, with onsite you have the freedom to pick from anyone of our in house written training courses and tell us when and where you want the training performed. We will arrive (at the time arranged)
set up our training laboratory and get on with the job, stress free training scheduling, all you have to do is agree the dates with your Delegates, book us and leave the rest to us, happy satisfied colleagues with new skills to use for your Company.
Why not speak to us about your training requirements? We offer no obligation advice and free quotations for work, if you are just at that stage of putting together a training strategy or case for funding we can help you
work out your different strategies and put together a series of illustrative costings and schedules, then if you go away while you sort out your funding we won't badger you and we'll honour our pricings for as long as the
machinery in your Company takes to sort out Purchase Orders … it’s a win-win for you
Look through our website, have a look at the other IT training courses we can provide for you, read our reviews, and then speak to us