The Oracle Database: SQL Workshop II course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions.
- Grant and revoke privileges and roles.
- Manage schema objects and data dictionary views.
- Write efficient and complex subqueries.
- Use the in-built functions supporting the usage of regular expressions and time zone.