Oracle SQL - advanced

Knowledge of relational databases, free use of the SELECT statement in terms of projection, selection, joins and subqueries.

Level
Advanced
Form
Lecture, Presentation, Workshop
Purpose of the training
The training is dedicated to people with the profile of user, programmer or administrator who already have some knowledge of working with Oracle database and want to deepen and systematize it. It is a complement to the ORA_S1 training course.
Benefits of completing the training
The training will provide participants with the skills to efficiently store and process data using SQL, introducing knowledge of optimization, analysis and various methods of data extraction. At the same time, it will provide knowledge of the database architecture and its advanced capabilities to create effective applications.

SQL analytical extension

• Summary during groupings
• Operations on strings of records
• Analytical form of aggregation functions
• Rankings and windows

Hierarchical queries and samples

• Tree construction (CONNECT BY PRIOR clause and START WITH clause).
• SYS_CONNECT_BY_PATH function
• Samples of data (SAMPLE clause)

Regular expressions in SQL

• Searching through data
• Data transformations

Repository operations

• System dictionary
• Constraint management
• Temporary tables
• Views
• Sequences
• Indexes
• Synonyms
• Database links
• External tables

Appendix A - Managing users and permissions

• Users and schemas
• System and object permissions
• Roles
• Profiles

Suggested pre-training
ORA_S1 or ORA_SA1
Suggested supplementary training courses
ORA_SP3, ORA_P1,ORA_P2