• Skillsoft Blog
  • Skillsoft Facebook
  • Skillsoft Twitter
  • Skillsoft YouTube
  • Skillsoft LinkedIn

Oracle Database 10g – Introduction to SQL 


Course Objective:

  This course gives hands on training for the requirement for Oracle Database 10g SQL Certification. The course prepares Students for Certification Exam # 1Z0-047.


 Pre-requisite:

· Familiarity with Data Processing Concepts and Techniques


 Course Contents:

· Introduction to SQL
· Writing SQL SELECT Statements
· Restricting and Sorting Data
· Using Single-Row Functions to Customize Output
· Reporting Aggregated Data Using the Group Functions
· Displaying Data from Multiple Tables
· 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
· Manage Schema Objects
· Manipulating Large Data Sets
· Generating Reports by Grouping Related Data
· Managing Data in Different Time Zones
· Searching Data Using Advanced Sub queries

  

Find out more about Amfasoft's education offerings


Enroll in this Amfasoft Course Now