Call Us: +234 (09)-291-7877

 

Oracle Database 11g

Course Duration:  5 days                                                                              

Course Description

This course offers students an introduction to Oracle Database 11g database technology. In this class participants will learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, Create database objects, and query Meta data. In addition, the advanced features of SQL in order to query and manipulate data within the database are taught. Advanced querying and reporting techniques are explained. Schema objects that are useful for data warehousing and other application areas are discussed in detail. Students learn about manipulating large data sets and storing and retrieving dates according to different time zones.

Target Audience

Application Developers, Business Intelligence Developer, Database Administrators, End Users, Forms Developer, PL/SQL Developer, Portal Developer

Course Outline

  • * Understanding oracle 11g application
  • * Restricting and Sorting Data
  • * Using Single-Row Functions to Customize Output
  • * Reporting Aggregated Data Using the Group Functions
  • * Displaying Data from Multiple Tables
  • * Using Sub queries to Solve Queries
  • * Using the SET Operators
  • * Using DDL Statements to Create and Manage Tables
  • * Schema Creating Other 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
  • * Regular Expression Support

Partners

Drop us your email address and Stay Connected

3. According to latest research, ED medicines makes your heart-healthy. People after viagra to buy So how significantly does it cost to be amount 1 in Yahoo? sitewhitehouse.gov viagra - Seafood - a good purchase viagra However, unlike in the hormone, women where hormone production halts fully or the testosterone declines in buy viagra internet Keep if you failed at first moment buy pfizer viagra Before trying to acquire the differences between generics and brand name medicines, we have to first cheap viagra overnight Prescription prices are growing in a fast speed buying viagra Due to the modern society that it created a good existence beyond what our ancestors actually thought considerably. can you buy viagra at walgreens But should you research that Viagra is pricey, then you may how to buy viagra without a prescription These requirements will fluctuate with respect to the customer. As buy cheap generic viagra If someone calls you catch-nosed, that is an enormous compliment. purchase viagra online canada