Sections of Oracle SQL with SQL Developer 18.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 18.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 18.2 training course
SQL Developer is the free to download GUI product produced by Oracle for Users, Developers and DBAs to interface with a Database, basically it gives people access to perform commands on the Database and extract information stored in it. It’s a nice product to use but it is has a lot of options within it and this course will cover all the essential parts for a Delegate to be able to use it.
What's the difference between SQL Developer and Toad? Well in a nutshell … cost, SQL Developer is free to download and Toad … isn’t !! Both products though offer a great way to access the Oracle Database whatever level of 'User' you happen to be. SQL is the start point of any training in Oracle, whatever the final goal in training, here is where you start.
This four day course is designed for Delegates wishing to use SQL Developer to perform SQL commands against an Oracle Database, not only do they leave with a thorough knowledge of SQL but also be able to navigate the SQL Developer product.
The first day will start with a rudimentary guide to starting SQL Developer, logging on etc. then moving onto to extracting basic datasets from the Database, our philosophy on this and every other course is to provide a thorough grounding in the topic, SQL Developer can give access to the information in the Database very quickly but its only by using SQL commands within the Editor that its true potential can be realised. Continually throughout the course new areas of SQL Developer will be discussed, demonstrated and then included as part of an exercise.
On the SQL side we start simple, concentrating on the first day or so on SQL queries, introducing aliases, where clauses, joining tables etc.. If you need to know exactly what's on the course, look below this synopsis where we list the index of this course, in fact, all courses we perform we list the topics / index of the course on the relevant course page.
Advanced topics of SQL Developer and SQL are introduced, these include exporting and importing data, advanced reporting etc. as well as creating database objects such as tables, views and indexes, all of these are explained in great detail before the Delegate gets to practice 'what we preach'.
All of our public courses commence at 9am, it’s a good idea to come a little early to get yourself settled and of course have a coffee or tea perhaps a chocolate biscuit and meet the other Delegates and our Consultant. Once everyone is seated in front of their individual workstations the Trainer will put everyone at ease by introducing themselves then encouraging everyone to give a brief breakdown of themselves and what they hope to gain from attending the course, we keep it light hearted and that’s our philosophy throughout the course, learning is easier when we enjoy.
All one hundred plus of our courses are available onsite, this means we come to your venue with our training equipment, this gives you many advantages over the public courses, firstly your Delegates are coming to work as normal, they don’t incur any travelling costs or indeed overnight stays, ideal if they have personal commitments which preclude them from being away from home for a few days at a stretch. Also you can choose the start date of the course and in most circumstances we can start at any time you choose, one course we gave a little while ago was for shift workers so we started at 6pm in the evening, that’s quite unusual but we try to be as flexible as possible for our clients. Another advantage of onsite training is that we give massive bulk discount for you, particularly if you have 5 or more Delegates.
Make a query about any course we give, our friendly non-pushy approach will surprise you, we give solid advice on career development even if we can't give the course you need, but we will work hard to make sure you are happy with what we do for you.