Cunoștințe prealabile:
- Familiarity with data processing concepts and techniques
- Understanding of SQL statements
Obiective:
- Identify the major structural components of the Oracle Database
- Utilize views to display data
- Control database access to specific objects
- Manage schema objects
- Display data from multiple tables using join
- Manage objects with data dictionary views
- Write multiple-column sub-queries
- Use scalar and correlated sub-queries
- Create reports of sorted and restricted data
- Identify poorly performing SQL
- Interpret execution plans and the different ways in which data can be accessed
- Understand how the Query Optimizer makes decisions about how to access data
- Decipher, decide and then apply tuning to SQL code
- Take advantage of bind variables, trace files and use the different types of indexes
- List the possible methods of accessing data, including different join methods
- Modify a SQL statement to perform at its best
Prețul include:
Suportul de curs oficial în format electronic și diploma de participare.