没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
试读
593页
• Describe the relational database approach, concepts, terminology, and operators. • Create database structures such as tables and views using Structured Query Language (SQL). • Store, retrieve, and update data in the database. • Develop PL/SQL blocks of application code using Procedure Builder to manipulate data.
资源详情
资源评论
资源推荐
1
1
-
-
1
1
Copyright © Oracle Corporation, 1996. All rights reserved.
Introduction
Introduction
1
1
-
-
2
2
Copyright © Oracle Corporation, 1996. All rights reserved.
Course Objectives
Course Objectives
•
•
Describe the relational database approach,
Describe the relational database approach,
concepts, terminology, and operators.
concepts, terminology, and operators.
•
•
Create database structures such as tables and
Create database structures such as tables and
views using Structured Query Language (SQL).
views using Structured Query Language (SQL).
•
•
Store, retrieve, and update data in the database.
Store, retrieve, and update data in the database.
•
•
Develop PL/SQL blocks of application code using
Develop PL/SQL blocks of application code using
Procedure Builder to manipulate data.
Procedure Builder to manipulate data.
1
1
-
-
3
3
Copyright © Oracle Corporation, 1996. All rights reserved.
Course Outline: Day 1
Course Outline: Day 1
Course Overview
Course Overview
Lesson 1
Lesson 1
Selecting Rows
Selecting Rows
Lesson 2
Lesson 2
Limiting Selected Rows
Limiting Selected Rows
Lesson 3
Lesson 3
Single row Functions
Single row Functions
Lesson 4
Lesson 4
Displaying Data from Multiple Tables
Displaying Data from Multiple Tables
1
1
-
-
4
4
Copyright © Oracle Corporation, 1996. All rights reserved.
Course Outline: Day 2
Course Outline: Day 2
Lesson 5
Lesson 5
Group Functions
Group Functions
Lesson 6
Lesson 6
Subqueries
Subqueries
Lesson 7
Lesson 7
Specifying Variables at Runtime
Specifying Variables at Runtime
Lesson 8
Lesson 8
Introduction to Data Models and
Introduction to Data Models and
Database Design
Database Design
Lesson 9
Lesson 9
Creating Tables
Creating Tables
Lesson 10
Lesson 10
Oracle Data Dictionary
Oracle Data Dictionary
1
1
-
-
5
5
Copyright © Oracle Corporation, 1996. All rights reserved.
Course Outline: Day 3
Course Outline: Day 3
Lesson 11
Lesson 11
Manipulating Data
Manipulating Data
Lesson 12
Lesson 12
Altering Tables and Constraints
Altering Tables and Constraints
Lesson 13
Lesson 13
Creating Sequences
Creating Sequences
Lesson 14
Lesson 14
Creating Views
Creating Views
Lesson 15
Lesson 15
Creating Indexes
Creating Indexes
Lesson 16
Lesson 16
Controlling User Access
Controlling User Access
Lesson 17
Lesson 17
Summary of SQL and SQL*Plus
Summary of SQL and SQL*Plus
(optional)
(optional)
剩余592页未读,继续阅读
imya77
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0