Oracle 19c Training Courses

NameDescription
Oracle SQL for Report Writers This course gives a basic introduction to Oracle`s version of SQL, focusing on the select statement for use within reports. This will be relevant for all versions of the database, from 8i onwards. Designed to introduce concepts and functionality in an accessible and friendly format, the course has been prepared to assist report writers understand what reporting tools will do behind the scenes and is aimed at those using any reporting tool that generates SQL.
Oracle Database - SQL I Introduction Learning the SQL language is one of the key tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This course introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS). Participants become acquainted with the differences in the working environment between a traditional on-premises database installation and the Oracle database service cloud-computing platform. This course incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning.
Oracle Database - SQL II Intermediate This course builds upon the prerequisite introductory course and considers intermediate-level SQL topics such as writing database queries using the SQL-99 syntax and exploiting the power of built-in functions that extend the capabilities of SQL. You will learn how to complete an application schema definition by creating database objects such as relational views, sequences, synonyms, indexes and others to compliment the table definitions. The crucial topic of data integrity and how this is protected using declarative constraints is covered.
Oracle Database - PL/SQL I Introduction This course introduces participants to Oracle database programming using the PL/SQL programming language. You will learn the syntax, structure and features of the language. This course will also lay the foundation to allow you to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.

PL/SQL may be considered as one of the key skill sets required for any Oracle professional, nearly as important as the SQL language itself.
Oracle SQL Performance Tuning Tips & Techniques - 2 Days Give your technical staff that competitive edge with this local Oracle Workshop. This course is designed for the Oracle professional with novice or no SQL tuning skills. The focus of this tuning course is to illustrate coding techniques that insure a consistent response time between instances and releases of the Oracle database. This course works closely with performance tuning of actual SQL statements. This course supports Oracle databases up through and including Oracle19c SQL tuning topics. The course starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. This course goes in-depth on understanding and controlling the explain plan (how Oracle retrieves data and in what order). The discussion includes considerable detail, with SQL examples, on how the optimizers (both rule-based and cost-based but mostly cost-based) make their decisions. Students will work with a variety of SQL statements, reviewing explain plans and making changes to make these SQL statements perform better. Lectures include index design, using hints and coding style to control the explain plans, and how to use useful tools such as index monitoring, SQL Trace, and the PL/SQL profiler. This course takes a close look at indexes: how Oracle selects them, why they are sometimes not used, and how to tell if indexes are being used/not being used. Dan says: “I feel the Indexing part of this course is worth the cost of the course alone!” The focus of this course is tuning SQL via coding style. The instructor finds that tuning in this fashion maintains the performance of the SQL when migrating to other Oracle environments (upgrades to newer releases). Lectures and topics are enhanced with live illustrations and hands-on exercises
Toad Data Point for End Users Give your technical staff that competitive edge with this Workshop for end users. This course introduces students to the querying and analytical capabilities of using Toad Data Point and Intelligence Central. Students will learn to load/modify/save data, create spreadsheets and other deliverables, and refine/run ad hoc queries. They will learn to view, chart, and analyze multidimensional data. They will also learn to produce individual ad hoc reports and make these reports and information easy to access via dash boards. Lectures are supported by hands on student lab exercises.
TOAD Data Point SQL for End Users Give your technical staff that competitive edge with this SQL Training for Business Analysts. This course is based on the internal RDBMS that comes with Toad Data Point but the skills are transferable to any relational database. The course uses Toad Data Point for the class lectures and lab exercises…so…the attendee will learn the SQL language while learning more about Toad Data Point.