Oracle Database 12c: SQL Fundamentals I Exam Number : (1Z0-061) |
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables
- Using Sub queries to Solve Queries
- Using the Set Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
|
Oracle Database 12c: Administration I Exam Number : (1Z0-062) |
- Exploring the Oracle Database Architecture
- Preparing the Database Environment
- Creating an Oracle Database
- Managing the Oracle Instance
- Configuring the Oracle Network Environment
- Managing Database Storage Structures
- Administering User Security
- Managing Data and Concurrency
- Managing Undo Data
- Implementing Oracle Database Security
- Database Maintenance
- Performance Management
- Intelligent Infrastructure Enhancements
- Backup and Recovery Concepts
- Performing Database Backups
- Performing Database Recovery
- Moving Data
|