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
10/02/2018: A leading Financial institution commissioned JBI to run a series of Agile/Scrum courses for various teams - inhouse. Pre-course consultation...
10/02/2018: Background The Development Team found itself having legacy modules developed in Ruby script. These modules would rapidly render dynamically changing...
06/02/2018: Originating from Facebook, React is a component based front-end library that allows you to build applications out of a tree of small, testable,...
12/10/2017: The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...
27/02/2018: Mariella has put together this short briefing on the bookmarks functionality in Power BI... "I love it!" she says.. Bookmarks has been available...
27/02/2018: Our world is changing; this is hardly anything new. New startups emerge consistently, almost on a daily basis, each claiming to have the latest...
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"