Training Syllabus
NCORC010 - Oracle 11g Introduction To SQL

Durasi : 5 hari

  • Introducing Oracle Database 11g
  • 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
  • Controlling User Access
  • Managing Schema Objects
  • Managing Objects with Data Dictionary Views
  • Manipulating Large Data Sets
  • Managing Data in Different Time Zones
  • Retrieving Data Using Sub-queries
  • Regular Expression Support