Oracle 10g :  IZ0-147

Programme with Pl/Sql

  
 

What will you learn:

This course offers students an introduction to Oracle Database 10g database technology. In this class students 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.

Course Objectives:

  • Retrieve row and column data from tables with the SELECT statement.

  • Employ SQL functions to generate and retrieve customized data.

  • Run data manipulation statements (DML) to update data in the Oracle Database 10g.

  • Control user access and manage schema objects

  • Search data using advanced sub queries
Course Topics:
  • Introduction: An Overview of components, Internet platform, Apps server and developer suite.
  • 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 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
 
About us Why Miracle? Training Services Client Profile Contact Us Site Map Home
 
Send mail to webmaster@miracleinfotech.com with questions or comments about this web site.
Copyright © 2000 Miracle Information Technologies