• Oracle 11g SQL & PL-SQL Express Introduction培訓
  Oracle 11g SQL & PL-SQL Express Introduction培訓
  培訓大綱：
  1. Database Management System Overview
  What a Database Is
  Types of DBMSs
  2. Entity Relationship Modeling
  Data Model
  Why to Use an Entity Relationship Model
  3. Fundamentals of Relational Database Management Systems
  What a Relational Database Management System (RDBMS) Is
  Relationships Between Tables
  4. SQL Basics and SQL*Plus
  Difference Between SQL, SQL*Plus, and PL/SQL
  Entering and Executing Commands
  5. Using iSQL*Plus
  iSQL*Plus Environment and Commands
  6. The WHERE and ORDER BY Clause
  Using the Data Dictionary
  7. Single Row Functions
  Functions, Date, and Numeric Format Models
  Data Conversion
  Control Statements
  8. Joining Data from Multiple Tables in Queries
  The JOIN Condition
  The Cartesian Product
  Outer JOINs
  SET Operators
  ANSI SQL99 Join Syntax
  9. Group Functions and the GROUP BY Clause
  Distinct Operator in Group Functions
  10. Using Subqueries and CASE Clauses
  Single-Row, Multi-Row, and Multi-Column Subqueries
  SELECT, FROM, WHERE, HAVING, and ORDER BY Subqueries
  11. Analytic Functions
  Single Row and Aggregating Analytic Functions
  12. SQL*Plus Reporting
  SQL*Plus Report Writing Commands
  Control Breaks
  Computing Aggregate Amounts
  13. Data Manipulation Language (DML) Commands
  INSERT, UPDATE, and DELETE
  MERGE Command
  Use of Subqueries, Transaction Control, and Locking
  14. Getting Data In and Out of Oracle
  SQL*Loader Basics
  Importing into Excel
  Direct Database Queries Using ODBC
  15. PL/SQL BASICS
  PL/SQL Anonymous Block Structure and Datatypes
  Variable Declarations
  Object Naming Rules
  Executable Statements Repetition Control
  CASE Expressions and Statements
  Basic Coding Standards
  16. Working with Database Data
  Referencing Other Variables or a Database Column''s Datatypes
  Implicit Cursor Attributes
  Transaction Control Commands
  Selecting Data into PL/SQL Variables
  Declaring Explicit Cursors
  17. Exception Handing
  Handling Predefined and User-Defined Exceptions
  Preventing Unhandled Exceptions
  Controlling Exception Processing
  18. Stored PL/SQL Objects
  Procedures and Functions Stored in the Database
  Creating Stored PL/SQL Objects
  Creating Procedures, Functions, Packages, and Package Bodies
  Database Triggers
  Viewing and Recompiling Stored Code
  ?
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?