Mentoring 1Z0-047 Oracle Database SQL Expert

Target Audience
Expected Duration
Lesson Objectives
Course Number

SkillSoft Mentors are available to help students with their studies for exam 1Z0-047 Oracle Database SQL Expert. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.

Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.

Expected Duration (hours)

Lesson Objectives

Mentoring 1Z0-047 Oracle Database SQL Expert

  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views
  • Controlling User Access
  • Managing Schema Objects
  • Manipulating Large Data Sets
  • Generating Reports by Grouping Related Data
  • Managing Data in Different Time Zones
  • Retrieving Data Using Subqueries
  • Hierarchical Retrieval
  • Regular Expression Support
  • Course Number: