Oracle 11g SQL Fundamentals Training Introduction-02

Realational Database Terminology

1->row;2->主键列;3->普通列;4->外键列;5->普通字段值;6->普通字段null值;

Using SQL to Query Your Database

Structured  query language(SQL) is:

• The ANSI standard languagte for operating relational database
• Efficient,easy to learn,and use
• Functionally complete(With SQL,you can define,retrieve,and manipulate data in the tables.)

SQL Statements

Command	Describe
SELECT	Data manipulation language(DML)
INSERT
UPDATE
DELETE
MERGE
CREATE	Data definition language(DDL)
ALTER
DROP
RENAME
TRUNCATE
COMMENT
GRANT	Data control language(DCL)
REVOKE
COMMIT	Transaction control
ROLLBACK
SAVEPOINT

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Development Enviroments for SQL

In this course:

• Oracel SQL Developer(不推荐)
• Primarily use SQL*PLUS

The Human Resources(HR) Schema

Oracle Database 11g Documentatioin

• Oracle Database New Features Guide 11g,Release 2
• Oracle Database Reference 11g,Realease 2
• Oracle Database SQL Lanaguage 11g,Release 2
• Oracle Database Concepts 11g,Release 2

Summary

• Relational databases are composed of realtions,managed by relational operations,and governed by data integrity constraints.
• With the Oracle server,you can store and manage information by using SQL.