Oracle Database 12c is a powerful relational database management system (RDBMS). It is designed for enterprise-level data management and supports high-volume workloads.
Oracle Database 12c is a powerful relational database management system (RDBMS). It is designed for enterprise-level data management and supports high-volume workloads.
The Oracle Database: SQL Workshop II Ed 2 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.
Learn To:
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.
Skills Covered
Upon completing this course, the learner will be able to meet these overall objectives:
Control database access to specific objects
Add new users with different levels of access privileges
Manage schema objects
Run data definition language (DDL) statements to create and manage schema objects
Manage objects with data dictionary views
Manipulate large data sets in the Oracle database by using subqueries