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
31/07/2018: Example programmes delivered: Professional Scrum Master PSM I Agile and Scrum These are 2 day courses which focus on understanding the agile/scrum...
10/02/2018: A leading Financial institution commissioned JBI to run a series of Agile/Scrum courses for various teams - inhouse. Pre-course consultation...
12/10/2017: The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...
06/08/2018: Kotlin develops quickly! Last year brought us many changes and possibilities. Both in the community and in the language. Let’s summarize them....
31/07/2018: Happy 3rd birthday PowerBI!!! A note from a user/trainer... PowerBi, after 3 years from its initial release, is a mature and rich tool for data...
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"