Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
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
Requirements
Knowledge of relational databases, free use of the SELECT statement in terms of projection, selection, joins and subqueries.
14 Hours