Realational Database Terminology

Oracle 11g SQL Fundamentals Training Introduction-02_oracle

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.)

Oracle 11g SQL Fundamentals Training Introduction-02_外键_02

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 11g SQL Fundamentals Training Introduction-02_sql_03

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.