oracle10g英文原厂培训intro

1、Introduction Lesson ObjectivesAfter completing this lesson, you should be able to do the following: List the features of Oracle10gDiscuss the theoretical and physical aspects of a relational databaseDescribe the Oracle implementation of the RDBMS and ORDBMSUnderstand the goals of the courseGoals of

2、the CourseAfter completing this course, you should be able to do the following: Identify the major structural components ofOracle Database 10g Retrieve row and column data from tables with the SELECT statement Create reports of sorted and restricted dataEmploy SQL functions to generate and retrieve

3、customized data Run data manipulation language (DML) statements to update data in Oracle Database 10g Obtain metadata by querying the dictionary viewsOracle10gSingle developmentmodelCommonskill setsReliabilityUnified managementScalabilityOnevendorOracle10gOracle Database 10gMultimediaObject relation

4、al dataMessagesDocumentsOracle Application Server 10gApplication development frameworkApplication serverBusiness intelligencePortalsIntegrationTransactional applicationsOracle Enterprise Manager 10g Grid ControlSoftware provisioningApplication service level monitoringRelational and Object Relational

5、Database Management SystemsRelational model and object relational modelUser-defined data types and objectsFully compatible with relational databaseSupport of multimedia and large objectsHigh-quality database server featuresOracle Internet PlatformSystem managementNetwork servicesDatabasesApplication

6、serversInternet applicationsAnybrowserAnyFTP clientAnymail clientSQLPL/SQLJavaClientsPresentation andbusiness logicBusiness logicand dataDevelopment toolsSystem Development Life CycleStrategy and analysis DesignBuildanddocumentTransitionProductionSystem Development Life CycleStrategy and analysis De

7、signBuildanddocumentTransitionProductionData Storage on Different MediaElectronic spreadsheetFiling cabinetDatabaseRelational Database ConceptDr. E. F. Codd proposed the relational model for database systems in 1970.It is the basis for the relational database management system (RDBMS).The relational

8、 model consists of the following:Collection of objects or relationsSet of operators to act on the relationsData integrity for accuracy and consistencyDefinition of a Relational DatabaseA relational database is a collection of relations or two-dimensional tables.OracleserverTable name: EMPLOYEESTable

9、 name: DEPARTMENTSData ModelsModel ofsystemin clientsmindEntity model ofclients modelTables on diskOracleserverTable modelof entity modelCreate an entity relationship diagram from business specifications or narratives:Scenario“. . . Assign one or more employees to a department . . .”“. . . Some depa

10、rtments do not yet have assigned employees . . .”Entity Relationship ModelEMPLOYEE#* number*nameojob titleDEPARTMENT#* number*nameolocationassigned tocomposed ofEntity Relationship Modeling ConventionsEntitySingular, unique nameUppercaseSoft boxSynonym in parenthesesUnique identifier (UID)Primary ma

11、rked with “#”Secondary marked with “(#)”EMPLOYEE#* number*nameojob titleDEPARTMENT#* number*nameolocationAttributeSingular nameLowercaseMandatory marked with *Optional marked with “o”assigned tocomposed ofEntity Relationship Modeling ConventionsUnique Identifier (UID)Primary marked with #Secondary m

12、arked with (#)EntitySingular, unique nameUppercaseSoft boxSynonym in parenthesesAttributeSingular nameLowercaseMandatory marked with *Optional marked with “o”EMPLOYEE#* number*nameojob titleDEPARTMENT#* number*nameolocationassigned tocomposed ofRelating Multiple TablesEach row of data in a table is

13、uniquely identified by a primary key (PK).You can logically relate data from multiple tables using foreign keys (FK).Table name: EMPLOYEESTable name: DEPARTMENTSPrimary keyPrimary keyForeign keyRelational Database Terminology123465Relational Database PropertiesA relational database:Can be accessed a

14、nd modified by executing structured query language (SQL) statementsContains a collection of tables with no physical pointersUses a set of operatorsCommunicating with an RDBMSUsing SQLSQL statement is entered.Statement is sent to Oracle server.OracleserverSELECT department_name FROM departments;Oracl

15、es Relational Database Management SystemUser tablesData dictionaryOracleserverSQL Statements SELECT INSERTUPDATEDELETEMERGECREATEALTERDROPRENAMETRUNCATECOMMENTGRANTREVOKECOMMITROLLBACKSAVEPOINTData manipulation language (DML)Data definition language (DDL)Transaction controlData control language (DCL)Tables Used in the CourseEMPLOYEESDEPARTMENTSJOB_GRADESSummaryOracle Database 10g is the database for grid computing.The database is based on the object relational database ma