This course will assist in preparation for the Oracle Database SQL 1Z0-071 certification exams. The Oracle Database SQL Workshop II course provides step-by-step instructions on how to use a combination of database modelling and development techniques to address your business challenges.
On successful Completion of the Fundamentals of Modelling course you will be able to:
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
Control database access to specific objects
Manipulate large data sets in the Oracle database by using subqueries
Manage data in different time zones
Write multiple-column subqueries
Use scalar and correlated subqueries
Use the regular expression support in SQL
Course Requirements
Prerequisites
Familiarity with data processing concepts and techniques
Target Audience
Audience
Database Developers
Database Administrators
End Users