1、培訓過程中，如有部分內容理解不透或消化不好，可免費在以后培訓班中重聽；
        2、培訓結束后,授課老師留給學員聯系方式,保障培訓效果,免費提供課后技術支持。
        3、培訓合格學員可享受免費推薦就業機會。

• 1. Introduction to Oracle Database
  Features of Oracle Database 11g
  Basic design, theoretical, and physical aspects of a relational database
  Categorize the different types of SQL statements
  Data set used by the course
  Log on to the database using SQL Developer environment
  Save queries to files and use script files in SQL Developer
  2. Retrieve Data using the SQL SELECT Statement
  Capabilities of SQL SELECT statements
  Generate a report of data from the output of a basic SELECT statement
  Select all columns
  Select specific columns
  Use column heading defaults
  Use arithmetic operators
  Operator precedence
  DESCRIBE command to display the table structure
  3. Learn to Restrict and Sort Data
  Write queries that contain a WHERE clause to limit the output retrieved
  Comparison operators and logical operators that are used in a WHERE clause
  Rules of precedence for comparison and logical operators
  Use character string literals in the WHERE clause
  Write queries that contain an ORDER BY clause to sort the output of a SELECT statement
  Sort output in descending and ascending order
  4. Usage of Single-Row Functions to Customize Output
  Differences between single row and multiple row functions
  Manipulate strings with character function in the SELECT and WHERE clauses
  Manipulate numbers with the ROUND, TRUNC, and MOD functions
  Perform arithmetic with date data
  Manipulate dates with the DATE functions
  5. Invoke Conversion Functions and Conditional Expressions
  Implicit and explicit data type conversion
  Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  Nest multiple functions
  Apply the NVL, NULLIF, and COALESCE functions to data
  Use conditional IF THEN ELSE logic in a SELECT statement
  6. Aggregate Data Using the Group Functions
  Use the aggregation functions to produce meaningful reports
  Divide the retrieved data in groups by using the GROUP BY clause
  Exclude groups of data by using the HAVING clause
  7. Display Data from Multiple Tables Using Joins
  Write SELECT statements to access data from more than one table
  View data that generally does not meet a join condition by using outer joins
  Join a table to itself by using a self join
  8. Use Subqueries to Solve Queries
  Types of problems that subqueries can solve
  Subqueries
  Types of subqueries
  Write single-row and multiple-row subqueries
  9. The SET Operators
  SET operators