Oracle 11g - Advanced data analysis - workshops Training Course

For who
These workshops are a continuation and complement the training of Oracle 11g data-analysis - a workshop dedicated to end users, data analysts and software testers for execution of professional duties which require more advanced techniques for working with the database. As in the case of the training of Oracle 11g data-analysis - workshops, participants do not need to be computer scientists, but the people who need efficient, and above all efficiently use the Oracle database, processing and analyzing stored in the large amounts of data
Purpose of training
The workshop aims to broaden the knowledge of participants about programming using PL / SQL and issues related to the optimization commands. Particular emphasis in this training is the performance of the data collection to ensure a smooth operation for very large amounts of data. In addition, workshops supplement an understanding of the elements necessary to any advanced user of Oracle in their daily work, such as copying and downloading large amounts of information, data modeling, modification of an existing data model and reverse engineering techniques using Oracle tools.
The content of the training
Moving and loading
Procedural language PL / SQL allows you to expand the analytical capabilities of a SELECT statement
Improving the performance of SQL queries
Data modeling and acquisition and modification of the existing data model based on Oracle SQL Modeler
Notes
The workshops are based on the software version 11g XE