Oracle SQL

Oracle SQL

Course Contents

  • Introduction 
  • Retrieving Data Using the SQL SELECT Statement 
  • Restricting and Sorting Data 
  • Using Single Row Functions to Customize Reports 
  • 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 
  • 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 
  • Hierarchical Data Retrieval Performing Regular Expression Support and Case Insensitive

 

 

Features: 
Learner Centered Approach 
Individual Training 
Practice in real Business Applications 
Creativity Building Training 
Certificate approved by Ministry of Education