Certificazioni Oracle-Introduction to Oracle 9i: SQL

Il corso “Introduction to Oracle 9i: SQL” introduce ai concetti sulla tecnologia data server, saranno illustrati nozioni e concetti, in modo approfondito sia di database relazionale che di database relazionale a oggetti e le istruzioni del linguaggio di programmazione SQL.

Obiettivi

Il corso mira ad introdurre gli utenti nel mondo dei database relazionali partendo dalle prime nozioni di database e utilizzando il linguaggio di programmazione SQL. Sarà infatti descritto come creare e gestire oggetti di database, come memorizzare e recuperare dati, l'uso di tecniche avanzate per il recupero di dati. Sarà ancora illustrato come scrivere script SQL e SQL*Plus utilizzando lo strumento iSQL*Plus per generare output sotto forma di report.

Destinatari

Tutti gli utenti che vogliono acquisire le conoscenze necessarie nella gestione di DataBase Server in ambiente Oracle.

Prerequisiti

Conoscenza di base dell’informatica e dimestichezza con l’utilizzo del Personal Computer.

Qualifiche dei docenti

I nostri docenti sono in possesso delle seguenti tipologie di certificazioni: OCA (Oracle9i Database Administrator Certified Associate) e OCP (Oracle9i Database Administrator Certified Professional).

Sbocchi professionali

Il database administrator è impiegato nelle aziende ove richiesto un responsabile addetto all’implementazione di opportune procedure di disaster ricovery e manutenzione dei server e si occupa della sicurezza degli accessi interni ed esterni al database.

Esame

Il percorso formativo prevede il seguente esame finale:

Ø 1ZO-007 Introduction to Oracle 9i: SQL

L’esame in questione, è primo dei due esami richiesti per il conseguimento della certificazione OCA - Oracle9i Database Administrator Certified Associate, nonché primo dei quattro esami richiesti per la certificazione OCP - Oracle Certified Professional.

Per ulteriori informazioni generali sulle certificazioni consultare il sito Thomson Prometric all’indirizzo internet /Exam.asp

Programma didattico per la certificazioneCourse Topics:Introduction

Describing the Life Cycle Development PhasesDefining a Relational DatabaseDiscussing the Theoretical, Conceptual, and Physical Aspects of a Relational DatabaseDescribing How a Relational Database Management System (RDBMS) Is Used to Manage a Relational DatabaseDescribing the Oracle Implementation of Both the RDBMS and the Object Relational Database Management System (ORDBMS)Describing How SQL Is Used in the Oracle Product Set

Writing a Basic SQL Statement

Describing the SQL Select CapabilitiesExecuting a Basic Select Statement with the Mandatory ClausesDifferentiating Between SQL and iSQL*Plus Commands

Restricting and Sorting Data

Limiting the Rows Retrieved by a QuerySorting the Rows Retrieved by a Query

Single Row Functions

Describing Various Types of Functions Available in SQLUsing a Variety of Character, Number, and Date Functions in SELECT StatementsExplaining What the Conversion Functions Are and How They Are UsedUsing Control Statements

Displaying Data from Multiple Tables

Writing SELECT Statements to Access Data from More Than One TableDescribing the Cartesian ProductDescribing and Using the Different Types of JoinsWriting Joins Using the Tips Provided

Aggregating Data by Using Group Functions

Identifying the Different Group Functions AvailableExplaining the Use of Group FunctionsGrouping Data by Using the GROUP BY Clause

Writing Subqueries

Describing the Types of Problems That Subqueries Can SolveDescribing Subqueries Listing the Types of SubqueriesWriting Single-Row and Multi-Row SubqueriesDescribing and Explaining the Behavior of Subqueries When NULL Values Are Retrieved

Producing Readable Output with iSQL*Plus

Producing Queries That Require an Input VariableCustomizing the iSQL*Plus EnvironmentProducing More Readable OutputCreating and Executing Script Files

Manipulating Data

Describing Each Data Manipulation Language (DML) CommandInserting Rows into a TableUpdating Rows in a TableDeleting Rows from a TableMerging Rows into a TableControlling TransactionsDescribing Transaction ProcessingDescribing Read Consistency and Implicit and Explicit Locking

Creating and Managing Tables

Describing the Main Database ObjectsCreating TablesDescribing the Oracle Data Types Altering Table DefinitionsDropping, Renaming, and Truncating Tables

Including Constraints

Describing ConstraintsCreating and Maintaining Constraints

Creating Views

Describing Views and Their UsesCreating a ViewRetrieving Data by Means of a ViewInserting, Updating, and Deleting Data Through ViewsDropping ViewsAltering the Definition of a ViewInline ViewsTop 'N' Analysis

Other Database Objects

Creating, Maintaining, and Using SequencesCreating and Maintaining IndexesCreating Private and Public Synonyms

Controlling User Access

Understanding the Concepts of Users, Roles, and PrivilegesGranting and Revoking Object PrivilegesCreating Roles and Granting Privileges to RolesCreating Synonyms for Ease of Table Access

SQL Workshop

Applying Techniques Learned in This CoursePreparing for Future Oracle Courses

Using Set Operators

Describing the Set OperatorsObeying the Set Operators Rules and GuidelinesUsing a Set Operator to Combine Multiple Queries into a Single SubqueryControlling the Order of Rows Returned

Oracle 9i Datetime Functions

Using DATETIME FunctionsUsing the NVL2 Function to Handle NULL Values

Enhancements to the GROUP BY Clause

Using ROLLUP as an Extension to the GROUP BY Clause to Produce Subtotal ValuesUsing CUBE as an Extension to the GROUP BY Clause to Produce Cross-Tabulation ValuesUsing the GROUPING Function to Identify the Row Values Created by ROLLUP or CUBE OperatorsUsing GROUPING SETS to Produce a Single Result Set That Is Equivalent to a UNION ALL ApproachUsing the WITH Clause

Advanced Subqueries

Multiple-Column SubqueriesWriting a Subquery in the FROM ClauseWriting and describing Correlated SubqueryUsing EXISTS and NOT EXISTS OperatorsUpdating and Deleting Rows Using Correlated SubqueriesUsing Scalar Subqueries in SQL

Hierarchical Retrieval

Discussing the Benefits of the Hierarchical QueryOrdering the Rows Retrieved by a Query in a Hierarchical MannerFormatting Hierarchical Data so That It Is Easy to ReadExcluding Branches from the Tree Structure

Oracle9i Extensions to DML and DDL Statements

Discussing Multitable InsertsCreating and Using External TablesNaming the Index and Using the CREATE INDEX Command at the Time of Creating Primary Key Constraint

Costo del corso

Il costo totale del corso è di € 1.950,00 + IVA

Il corso dura 5 giorni lavorativi da 7 ore.

Il costo del voucher d’esame è da considersi escluso dal costo del corso indicato.

Exam Topics

Writing Basic SQL Select Statements

· List the capabilities of SQL SELECT statements

· Execute a basic SELECT statement

· Differentiate between SQL statements and iSQL*Plus commands

Restricting and Sorting Data

· Limit the rows retrieved by a query

· Sort the rows retrieved by a query

Single-Row Functions

· Describe various types of functions available in SQL

· Use character, number, and date functions in SELECT statements

· Use conversion functions

Displaying Data from Multiple Tables

· Write SELECT statements to access data from more than one table using equality and nonequality joins

· View data that generally does not meet a join condition by using outer joins

· Join a table to itself using a self-join

Aggregating Data using Group Functions

· Identify the available group functions

· Use group functions

· Group data using the GROUP BY clause

· Include or exclude grouped rows by using the HAVING clause

Subqueries

· Describe the types of problems that subqueries can solve

· Define subqueries

· List the types of subqueries

· Write single-row and multiple-row subqueries

Producing Readable Output with iSQL*Plus

· Produce queries that require a substitution variable

· Produce more readable output

· Create and execute script files

Manipulating Data

· Describe each DML statement

· Insert rows into a table

· Update rows in a table

· Delete rows from a table

· Merge rows in a table

· Control transactions

Creating and Managing Tables

· Describe the main database objects

· Create tables

· Describe the datatypes that can be used when specifying column definition

· Alter table definitions

· Drop, rename and truncate tables

Including Constraints

· Describe constraints

· Create and maintain constraints

Creating Views

· Describe a view

· Create, alter the definition, and drop a view

· Retrieve data through a view

· Insert, update and delete data through a view

Creating Other Database Objects

· Create, maintain and use sequences

· Create and maintain indexes

· Create private and public synonyms