Upcoming Workshops

Oracle Database 11g: SQL (Oracle Certified Expert-OCE)

Hi i`m very happy to say this I got job in Ora-Tech System Pvt Ltd, Because through the placement assistance given by the Oranet. They provided best lab facilities and Excellent Real time trainer

Read More Yawar Abbas Rawalpindi

Student Review

Hi i`m very happy to say this I got job in Ora-Tech System Pvt Ltd, Because through the placement assistance given by the Oranet. They provided best lab facilities and Excellent Real time trainer

Read More Yawar Abbas Rawalpindi

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

Course Objectives

Oracle Database 11g: SQL Fundamentals I

  • Employ SQL functions to generate and retrieve customized data
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Identify the major structural components of the Oracle Database 11g
  • Create reports of aggregated data
  • Write SELECT statements that include queries
  • Retrieve row and column data from tables with the SELECT statement
  • Run data manipulation statements (DML) to update data in the Oracle Database 11g
  • Create tables to store data
  • Utiliye views to display and retrieve data
  • Write multiple-column sub-queries
  • Use scalar and correlated sub-queries Use
  • the regular expression support in SQL
  • Create reports of sorted and restricted data
  • Controlling User Access
  • Manipulating Data
  • Managing Data in Different Time Zones
  •  

Oracle Database 11g: SQL Fundamentals II

  • Oracle Database 11g: Controlling User Access and Managing Schema Objects
  • Oracle Database 11g: Data Dictionary Views and Large Data Sets
  • Oracle Database 11g: Managing Data in Different Time Zones
  • Oracle Database 11g: Using Subqueries and Regular Expressions
Course Content Exam(s)

  

Exame Name Exame Number Product Version Exam Cost

Oracle Database SQL Certified Expert

1Z0-047

Oracle Database SQL

$ 150

 

 

Student Review

Hi i`m very happy to say this I got job in Ora-Tech System Pvt Ltd, Because through the placement assistance given by the Oranet. They provided best lab facilities and Excellent Real time trainer

Read More Yawar Abbas Rawalpindi
1
1
 
1
1
Fly-me-a-Trainer is a one of its kind service by Oranet. As per client requirements, Oranet sends expert trainers to corporate locations. With our trainer at your venue, you just need a conference room. The participants will be provided remote access to server at our Data Center.
For any Query or Custom Plan info@oranet.com.pk Lahore: 042-36619618-9 | Islamabad: 051-2806466
Order Summary
asdfsdsdf
Course Oracle Database 11g: SQL (Oracle Certified Expert-OCE)
Training Mode
Training Type
Training Location
Accomodation
Date
Total




Order Summary
asdfsdsdf
Course Oracle Database 11g: SQL (Oracle Certified Expert-OCE)
Training Mode
Training Type
Training Location
Accomodation
Training Days
Date
Total