欧美色欧美亚洲另类七区,惠美惠精品网,五月婷婷一区,国产亚洲午夜

        1、培訓(xùn)過程中，如有部分內(nèi)容理解不透或消化不好，可免費(fèi)在以后培訓(xùn)班中重聽；
        2、培訓(xùn)結(jié)束后,授課老師留給學(xué)員聯(lián)系方式,保障培訓(xùn)效果,免費(fèi)提供課后技術(shù)支持。
        3、培訓(xùn)合格學(xué)員可享受免費(fèi)推薦就業(yè)機(jī)會(huì)。

• 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