书籍详情

OCP-Oracle8i DBA SQL与PL/SQL学习指南(英文原版)

OCP-Oracle8i DBA SQL与PL/SQL学习指南(英文原版)

作者:(美)Chip Dawes,(美)Biju Thomas 著

出版社:电子工业出版社

出版时间:2001-03-01

ISBN:9787505365483

定价:¥46.00

购买这本书可以去
内容简介
  This book is intended to help you on your exciting path toward obtaining the Oracle8i Certified Database Administrator and Oracle8i Certified Application Developer certifications. Basic knowledge of Oracle sQL and PL/sQL Is an advantage when reading this book but is not mandatory. using this book and a practice database, you can start learning Oracle and pass the IZO-001 test: Introduction to Oracle: sQL and PL/SQL.
作者简介
暂缺《OCP-Oracle8i DBA SQL与PL/SQL学习指南(英文原版)》作者简介
目录
Introduetion                  
      Assessment Test                  
 Chapter l  Relational Technology and Simple                  
      SQL SELECT Statements                  
      Relatlonal Database Systems                  
      Characterlstics of a Relatlonal Database                  
      Application Development Cycle                  
      Oracle's Implementation of RDBMS and ORDBMS                  
      Oracle Datatypes                  
      Character Datatypes                  
      Numerlc Datatypes                  
      The Date Datatype                  
      LOB Datatypes                  
      Other Datatypes                  
      Llterals                  
      SQL Fundamentals.                  
      Operators and Expressions                  
      Wrltlng Slmple guerles                  
      SELECT Statement                  
      Limiting Rows                  
      Sorting Rows                  
      SQL*Plus: Oracle's Natlve Interface                  
      SQL*Plus: Basics                  
      Producing More Readable Output                  
      Accepting Values at Runtime                  
      Summary                  
      Key Terms                  
      Revlew guestions                  
      ATlswers to Review guestlons                  
 Chapter 2  Single-Row and Group Functions                  
      Single-Row Functions in sgL                  
      NULLs and Single-Row Functlons                  
      Single-Row Character Functlons                  
      Single-Row Numeric Functions                  
      Single-Row Date Functions                  
      Slngle-Row Converslon Punctions                  
      Programmer-Written Slngle-Row Functions                  
      Other Single-Row Functlons                  
      Group Functions in sgL                  
      Group (Multi-row) Functlons                  
      Grouping Data with GROUP BY                  
      Llmlting Grouped Data with HAVING                  
      Nesting Functions                  
      Summary                  
      Key Terms                  
      Review Questions                  
      Answers to Review Questions                  
 Chapter 3 Joins and Subqueries                  
      Multiple Table Queries                  
      Equality and Non-Equallty Jolns                  
      Caresian Joins                  
      Outer Joins                  
      Self-Join                  
      using Set Operators                  
      Subqueries                  
      Single-Row and Multiple-Row Subqueries                  
      NULL Values in Subqueries                  
      Multiple-Column Subqueries                  
      Subqueries in the FROM Clause                  
      Summary                  
      Key Terms                   
      Review guestions                  
      Answers to Review guestions                  
 Chapter 4 Modffying Data and Security                  
      DML Statements                  
      Inserting Rows into a Table                  
      Updating Rows in a Table                  
      Deleting Rows from a Table                  
      Selecting Rows FOR UPDATE                  
      Locking a Table                  
      DML Locks in Oracle                  
      Transaction Control                  
      Transactions                  
      Savepoints and Partial Rollbacks                  
      Consistency and Transactions                  
      Enabling Transaction-Level Consistency                  
      Creating and Modifying Users                  
      Database-Authenticated User Accounts                  
      Externally Authenticated User Accounts                  
      Globally Authentlcated User Accounts                  
      Creatlng and Alterlng User Accounts                  
      Privileges and Roles                  
      Creating and Using Roles                  
      Object Privileges                   
      System Privileges                  
      Roles and Role Prlvlleges                  
      Asslgning and Rescinding Privileges                  
      Privileges and the Data Dictionary                  
      Summary                  
      Key Terms                  
      Review guestions                  
      Answers to Review guestions                  
 Chapter 5 Creating and Managing Tables and Views                  
      Managing Tables                  
      Naming Conventions                  
      Creating from Another Table                  
      Modifying Table Definitions                  
      Dropping/ Renaming Tables                  
      Managing Views                  
      Creating a View                  
      Retrieving Data                  
      Inserting, Updating, and Deleting Data                  
      Dropping a View                  
      Summary                  
      Key Terms                  
      Review guestions                  
      Answers to Review guestions                  
 Chapter 6 Other Database Objects and the Data Dictionary                  
      Other Database Objects                  
      Constraints                  
      Sequences                  
      Indexes                  
      Synonyms                  
      Procedures and Functions                  
      Packages                  
      Triggers                  
      A guick 'n' Dirty Review of the Data Dictionary                  
      Querying the Data Dictionary                  
      Summary                  
      Key Terms                  
      Review guestions                  
      Answers to Review guestions                  
 Chapter 7 PL/sQL Basics                  
      Benefits of PL/sQL                  
      The PL/sQL Block Structure                  
      Named and Anonymous Blocks                  
      Variables and Constants                  
      Declaring Variables                  
      Assigning Values to Variables                  
      Constants                  
      Scalar Datatypes                  
      LOB Datatypes                  
      Operators                  
      The Executable Section                  
      Executing a Block                  
      Control Stuctures                  
      Syntax and Usage                  
      Labels                  
      Labeled Blocks                  
      Labeled Loops                  
      The GOTO Statement                  
      Nested Blocks                  
      Summary                  
      Key Terms                  
      Review guestions                  
      Answers to Review guestions                  
 Chapter 8 Interacting with the Database                  
      Accessing the Database                  
      gueries                  
      Other DML Statements                  
      Transaction Control Statements                  
      E3CpliCit Cursors                  
      Using Cursors                  
      Cursors with Parameters                   
      Cursor FOR Loops                  
      Subqueries in a Cursor                  
      Updating and Deleting in a Cursor                  
      Summary                  
      Key Terms                  
      Review guestions                  
      Answers to Review guestions                  
 Chapter 9 Working with Composite Datatypes and Collections                  
      PL/sQL Records                  
      Creating Records                  
      Using Records                  
      PL/sQL Collections                  
      types of Collections                  
      Using Collections                  
      Summary                  
      Key Terms                  
      Review guestions                  
      Answers to Review guestions                  
 Chapter IO Exception Handling                  
      Exceptions, Errors, and PL/sQL                  
      Raising and Handling Exceptions                  
      Raising Exceptions                  
      Handling Exceptiorls                  
      Exception Propagation                  
      Named Exceptions                  
      Customizing Exception Handling                  
      Declaring Your Own Exceptions                  
      Giving Names to Database Errors                  
      Numbering Programmer-Defined Errors                  
      Summary                  
      Key Terms                  
      Review guestions                  
      Answers to Review guestions                  
 Appendix A Practice Exam                  
      Answers to Practice Exam                  
 Glossary                  

猜您喜欢

读书导航