EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE
The JBI Oracle SQL training course provides a thorough introduction to SQL language coding. Basic features are covered in detail, and then the course moves on to more advanced topics such as wide selection of scalar and group functions, group by, SQL Joins (including ANSI standard join syntax) and correct use of union, intersect and minus. The course finishes with introducing main-line approaches to using DML (insert, update and delete) plus a simple review of basic DDL (creating tables, indexes, plus use of primary keys and foreign keys. Delegates are encouraged to work with the lecturer in class, trying smaller demo techniques, and then going on to more interesting coding challenges in a set of exercises. Often skeleton code is available, so code adaption is possible (thus mimicking common coding practice).
What is SQL and what is it used for?
Using the Data Dictionary
The WHERE Clause
The ORDER BY Clause
Lexical and Bind variables
Numeric, Character, and Miscellaneous Functions
Group Functions SUM, AVG, COUNT, STDDEV
GROUP BY and HAVING Clauses
Queries within Queries
Basic Sub Queries
Complex Sub Queries
EXISTS and NOT EXISTS Clauses
Standard Table Joins
Self Referencing Table Joins
Inner and Outer Joins
Restricting Data Access with Views
Simplifying Database Design
Changing your password
Allowing Other Users Access to Your Tables
Inserting Data Into Tables
Commit and Rollback
Table and Row Level Locking
Assigning your own Locking Level
Generating SQL from SQL
Basic Performance Tuning
Performance Information using Explain Plan Utility
See why people choose JBI
03/10/2017: Traditionally Cyber security has been associated mainly with penetrating networks and infrastructure. Now a more subtle level of attack needs...
05/10/2017: Back in March 2014, the Angular team dropped a bomb by announcing Angular 2 and everyone started yelling. Instead of an evolutionary step forward,...
05/10/2017: MVC The Model View Controller (MVC) architectural pattern has a long history (together with its variants) and has been used in many languages...
13/10/2017: This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....
12/10/2017: The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...
07/10/2017: This client had previously utilised third parties to develop and deliver its customer facing products and services. A strategy change required...
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
Get in touch
0800 028 6400
Excellent feedback, consistently !
"great tips help reduce build times"
"we got access to exclusive content"
"Short course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"