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 Extensions
- Aggregation during groupings
- Operations on record sets
- Analytic form of aggregation functions
- RANKING and window functions
Hierarchical Queries and Sampling
- Tree construction (CONNECT BY PRIOR clause and START WITH clause).
- SYS_CONNECT_BY_PATH function
- Data sampling (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, with the ability to freely use the SELECT statement regarding projection, selection, joins, and subqueries.
14 Hours
Testimonials (2)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Greg was very patient and helpful
