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 |
Most Visited
Featured Customers
Services