Oracle11gSQLFundamentalsTrainingIntroduction02

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

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.