• Oracle 11g SQL for Business or Data Analysts培訓
  Oracle 11g SQL for Business or Data Analysts培訓
  培訓大綱：
  1. Intro to Structure Query Language (SQL) for Analyst
  SQL the language
  Data Manipulation Language (DML)
  Data Definition Language (DDL)
  SQL*Plus the Environment
  Scripting using Oracle''s Procedural Language option (PL/SQL)
  Overview of complete SQL SELECT syntax
  2. Intro to Oracle''s RDBMS Objects
  Objects, Tables, Columns, Pseudo columns, Rows
  Data domains, Duplicate values, Null values
  Indexes, Views, Sequences, Synonyms
  Declarative Constraints
  Primary, Foreign, Unique keys
  Check, Not Null, Default
  3. Using SQL in Different Scenarios
  SQL using SQL*Plus
  Starting SQL*Plus
  Entering and executing SQL commands
  The SQL command buffer within SQL*Plus
  Editors, Editing commands in the buffer
  SQL*Plus commands
  Set, Show, Column, Others
  Using SQL*Plus Worksheet
  SQL Developer
  Starting iSQLPlus
  Entering and executing SQL commands
  4. More SQL SELECT
  Arithmetic calculations
  Character, Comparison, and Logical operators
  WHERE clause, Pattern matching, Using SQL*Plus substitution variables
  &, &&, &1
  ORDER BY clause
  How NULLS are processed
  Multiple Columns
  ASC vs. DESC
  DISTINCT vs. UNIQUE
  5. Single Row FUNCTIONS
  What are Functions?
  Analytic
  Character
  Numeric
  Date
  Conversion
  Miscellaneous
  6. GROUP BY Clause & Group
  FUNCTIONS
  What are GROUP Functions?
  Aggregate (Group)
  Analytic functions
  COUNT(*) vs. COUNT(column_name)
  SUM(), AVG(), MIN(), MAX()
  VARIANCE(), STDDEV()
  GROUP BY and HAVING clause
  ROLLUP(), CUBE(), GROUPING()
  7. Advanced Topics
  Joining Tables
  Subqueries
  Correlated Subqueries
  IF EXIST
  8. SQL*Plus Reporting
  Building a SQL script
  COLUMN command
  Titles, Control Breaks, Sorting
  TTILE vs. REPHEADER
  BTITLE vs. REPFOOTER
  BREAK command
  COMPUTE command (Aggregates)
  Using variables in SQL*Plus
  SQL*Plus substitution variables &, && and &1
  ACCEPT and PROMPT commands
  DEFINE and BIND variables
  9. Getting Data into Oracle
  SQL*Loader
  Field delimited files
  CSV files
  10. Getting Data out of Oracle
  Field delimited files
  CSV Files
  ODBC connections like:
  Excel, Access, Crystal Reports, and SAS
  11. Intro to PL/SQL Scripting
  What is this thing called PL/SQL
  Features and Benefits
  Where do you fit?
  12. PL/SQL Basics
  An Anonymous block structure
  Lexical Units
  Variable Declarations, Expressions and operators
  Branching
  IF and CASE statements
  Looping: Simple and WHILE
  FOR loops
  13. Working with Database Data
  SELECT statement (single row)
  Other DML
  14. Intro to CURSORs
  Implicit and Declared CURSOR
  SELECT statement (multiple rows)
  Using a LOOP to FETCH a CURSOR
  15. Exception Handling
  What EXCEPTIONS are
  Oracle Pre-defined, User defined, and Other Oracle exceptions
  RAISE_APPLICATION_ERROR function
  Exception Propagation
  Preventing un-handled exceptions
  16. Writing Scripts
  How to automate routine reoccurring tasks
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?