Oracle 11g Foundations: SQL & SQL Plus (OR103)培训课程
培训大纲：
1. In the Beginning.Database Management System Overview
What is a Database?
Types of DBMSs
2. Introduction to Entity Relationship Modeling
What is a Data Model?
Why Use an Entity Relationship Model?
Input and Components of an Entity Relationship Model
Reading the Entity Relationship Model
Guidelines for a Model Review
3. Fundamentals of Relational Database Management Systems
What is an RDBMS?
History of SQL
Physical Data Storage
Relationships between Tables
Domains - Data Integrity Constraint
4. SQL Basics and SQL*Plus
Difference Between SQL, SQL*Plus, and PL/SQL
Invoking and Leaving SQL*Plus
Entering and Executing Commands
The SQL Buffer, SQL*Plus Default Output
LOGIN.SQL
The SELECT Command and Mandatory Clauses
5. Using SQL Developer
SQL Developer Environment and Commands
6. The WHERE and ORDER BY Clause
WHERE, ORDER BY Clause
Using the Data Dictionary
Hierarchical Queries
7. Single Row Functions
Single Row vs. Group Functions
Date and Numeric Format Models
Data Conversion
Control Statements
Regular Expressions
8. Joining Data from Multiple Tables in Queries
The JOIN Condition/The Cartesian Product
Outer JOINs
SET Operators
ANSI SQL99 Joins
9. Group Functions and the GROUP BY Clause
Group Functions
Distinct Operator in Group Functions
GROUP BY, WITH Clause, ROLLUP, CUBE
GROUPING SETS
10. Using Subqueries and CASE Clauses
Single-Row, Multi-Row, and Multi-Column Subqueries
Subqueries in a WHERE Clause
Subqueries in the FROM Clause - In-Line Views
Subqueries in the SELECT Clause - Scalar Subqueries
Correlated Subqueries
CASE Clause
11. Analytic Functions (Optional)
Single-Row Analytic Functions
Aggregating Analytic Functions
PIVOT/UNPIVOT
12. SQL*Plus Reporting
SQL*Plus Report Writing Commands
COLUMN Command/Titles, System Variables
Master-Detail Report with TITLE and COLUMN Commands
Control Breaks, Computing Aggregate Amounts
Using SET Variables in SQL*Plus, SQL to Generate SQL
13. Data Manipulation Language (DML) Commands
INSERT, UPDATE, DELETE, MERGE Command
Use of Subqueries
Transaction Control Commands/Read Consistency/Locking
The MERGE Command
Flashback Queries
14. Data Definition Language (DDL) Commands
DDL Commands, Object Naming, Dropping Objects
TRUNCATE, COMMENT, RENAME Command
Creating Tables/Integrity Constraints
CREATE TABLE, ALTER TABLE Command
Datatypes, Types of Declarative Constraints
Default Values
Creating, Deferrable, Dropping, Disabling/Enabling Constraints/Displaying Constraint Information
Handling Exceptions
Views, Synonyms, Sequences, Indexes, Virtual Columns
Temporary Tables, External Tables
15. Security
Users, Privileges, Roles, Changing Passwords
16. Getting Data In And Out Of Oracle
SQL*Loader Basics
Importing Oracle Data Into Excel
Direct Database Queries Using ODBC
如果您想学习本课程，请
预约报名
如果没找到合适的课程或有特殊培训需求，请
订制培训
除培训外，同时提供相关技术咨询与技术支持服务，有需求请发需求表到邮箱soft@info-soft.cn,或致电4007991916
技术服务需求表点击在线申请
服务特点：
海量专家资源，精准匹配相关行业，相关项目专家，针对实际需求，顾问式咨询，互动式授课，案例教学，小班授课，实际项目演示，快捷高效，省时省力省钱。
专家力量：
中国科学院软件研究所，计算研究所高级研究人员
oracle,微软，vmware，MSC,Ansys，candence,Altium,达索等大型公司高级工程师，项目经理，技术支持专家
中科信软培训中心，资深专家或讲师
大多名牌大学，硕士以上学历，相关技术专业，理论素养丰富
多年实际项目经历，大型项目实战案例，热情，乐于技术分享
针对客户实际需求，案例教学，互动式沟通，学有所获
