Oracle is the leading database on the market, putting Oracle database administrators in high demand. The certification programme for Oracle8i has jumpstarted the OCP (Oracle Certified Professional) program, and the new exams for the latest version of the database, 9i, are expected to continue the program's growth. This title covers the first exam in the DBA track, 1Z1-007, which is also a core requirement for the application developer track. The exam is expected to go live by the end of 2001. SQL is a programming language used to manipulate data in a database.
Table of Contents
Contents at a Glance. Introduction. Assessment Test. Chapter1 Basic SQL SELECT Statements. Chapter2 SQLPlus Overview. Chapter3 Single--Row Functions. Chapter4 Aggregating Data And Group Functions. Chapter5 Joins and Subqueries. Chapter6 Modifying Data. Chapter7 Managing Tables and Constraints. Chapter8 Managing Views. Chapter9 Other Database Objects. Chapter10 User Access and Security. Glossary. Index.
Author Biography
Chip Dawes is an OCP and has worked with Oracle databases since 1990. He is a consultant with D&D Technologies and frequently presents at various Oracle User Group conferences. Biju Thomas, OCP, has over 7 years of Oracle database management and application development experience. He currently works as a Database Administrator Consultant for Burlington Resources in Fort Worth, TX. Both authors contributed to OCP: Oracle8i DBA SQL Study Guide.
