Advanced data analysis with Oracle 11g Course

What is Advanced data analysis with Oracle 11g?

The course 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 course is based on the software version 11g XE

Content

• 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