007 Student Guide Introduction

  1.Oracle 9i 面向对象:

         User-defined data types and objects .

         Support of multimedia and large objects .

2.三层架构

         Browser-based client .

         Application server .

         Database .

3.System Development life cycle

         Strategy and analysis ( Study and analyze the business requirements , draw thebussiness process diagram and DFD = data flow diagram )

         Design ( Design the database , draw the ER diagram )

         Build and Document ( build the prototype system , for example : create tables , develop user documentation , help text  )

         Transition ( Refine the prototype , Somebody start to test the application , Make any modifications required . )

         Production ( Roll out the system to users , monitor its performance , and enhance and refine the system )

4.Entity Relationship model ( ER diagram ) ***

5.SQL statement

         Select Data ( retrieve ) .

         Insert , update , delete , merge (Data manipulation language DML )

         Create , alter , drop , rename , Truncate ( Data definition language DDL )

         Commit , rollback , Savepoint ( Transaction control )

         Grant , revoke ( Date control language DCL )