| 000 -LEADER | |
|---|---|
| fixed length control field | 04769nam a2200493u 4500 |
| 001 - CONTROL NUMBER | |
| control field | ocm12732628 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | AE-DuAU |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20241127165433.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 050916b ||||||||||||||||||||eng|u |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER | |
| LC control number | 2002277745 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0072195371 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 007219538X (bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0072195398 (CD) |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)ocm48690676 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | CVU |
| Transcribing agency | CVU |
| Modifying agency | OCLCQ |
| -- | DLC |
| 042 ## - AUTHENTICATION CODE | |
| Authentication code | lccopycat |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.3 |
| Item number | .C675 2001 |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC) | |
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) | QA 76.3 .C675 2001 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Couchman, Jason S. |
| 9 (RLIN) | 71376 |
| 245 10 - TITLE STATEMENT | |
| Title | OCP introduction to Oracle9i : |
| Remainder of title | SQL exam guide / |
| Statement of responsibility, etc | Jason Couchman. |
| 246 14 - VARYING FORM OF TITLE | |
| Title proper/short title | Oracle OCP introduction to Oracle9i |
| 246 30 - VARYING FORM OF TITLE | |
| Title proper/short title | SQL exam guide |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc | New York : |
| Name of publisher, distributor, etc | Osborne/McGraw-Hill, |
| Date of publication, distribution, etc | 2001. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xx, 485 p. : |
| Other physical details | ill. ; |
| Dimensions | 24 cm. + |
| Accompanying material | 1 CD-ROM (4 3/4 in.) |
| 336 ## - CONTENT TYPE | |
| Source | rdacontent |
| Content Type Term | text |
| Content Type Code | txt |
| 337 ## - MEDIA TYPE | |
| Source | rdamedia |
| Media Type Term | unmediated |
| Media Type Code | n |
| 338 ## - CARRIER TYPE | |
| Source | rdacarrier |
| Carrier Type Term | volume |
| Carrier Type Code | nc |
| 500 ## - GENERAL NOTE | |
| General note | "Exam 1Z0-007"--Cover. |
| 500 ## - GENERAL NOTE | |
| General note | Includes index. |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Preparing for OCP DBA Exam I: Introduction to SQL -- Overview of Oracle Databases -- Theoretical and Physical Aspects of Relational Databases -- Oracle's RDBMS and ORDBMS Implementations -- Usage and Benefits of PL/SQL -- Writing Basic SQL Statements -- Capabilities of SQL select Statements -- Executing select Statements -- Differentiating Between SQL and SQL *Plus Commands -- Limiting, Sorting, and Manipulating Return Data -- Restricting and Sorting Row Data -- Sorting Return Data with the order by Clause -- Limiting Return Data with the where Clause -- Using Single-Row Functions -- Various Single-Row Functions Explained -- Using Functions in select Statements -- Date Functions -- Conversion Functions -- Advanced Data Selection in Oracle -- Displaying Data from Multiple Tables -- The Keys to Table Joins -- Select Statements That Join Data from More Than One Table -- Creating Outer Joins -- Joining a Table to Itself -- Group Functions and Their Uses -- Identifying and Using Group Functions -- Using the group by Clause -- Excluding group Data with having -- Subqueries -- Understanding and Defining Subqueries -- Listing and Writing Different Types of Subqueries -- Writing Multiple-Column Subqueries -- NULL Values and Subqueries -- Subqueries in a from Clause -- Producing Readable Output with SQL *Plus -- Entering Variables -- Customizing SQL *Plus Environments -- Producing Readable Output -- Creating and Executing Scripts -- Saving Customizations -- Creating Oracle Database Objects -- Creating the Tables of an Oracle Database -- Describing Tables -- Creating Tables -- Datatypes and Column Definitions -- Altering Table Definitions -- Dropping, Renaming, and Truncating Tables -- Including Constraints -- Describing Constraints -- Creating and Maintaining Constraints -- Manipulating Oracle Data -- Adding New Rows to a Table -- Making Changes to Existing Row Data -- Deleting Data from the Oracle Database -- Merging Data in Oracle Tables -- The Importance of Transaction Control -- Creating Other Database Objects in Oracle -- Creating Views -- Creating Simple Views -- Creating Views That Enforce Constraints -- Creating Complex Views -- Modifying and Removing Views -- Other Database Objects -- Overview of Other Database Objects -- Using Sequences -- Using Indexes -- Using Public and Private Synonyms -- User Access Control in Oracle -- Creating Users -- Granting and Revoking Object Privileges -- Using Roles to Manage Database Access -- OCP Oracle9i DBA Practice Exams. |
| 520 #0 - SUMMARY, ETC. | |
| Summary, etc | Prepare to pass the Oracle Certified Professional Introduction to Oracle9i: SQL exam--a required exam for OCP DBA certification--using this Oracle Press study guide. Throughout each chapter, users will find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what they've learned. |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | Oracle (Computer file) |
| 9 (RLIN) | 71319 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Electronic data processing personnel |
| General subdivision | Certification. |
| 9 (RLIN) | 161342 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Database management |
| General subdivision | Examinations |
| Form subdivision | Study guides. |
| 9 (RLIN) | 161343 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | SQL (Computer program language) |
| 9 (RLIN) | 1922 |
| 852 ## - LOCATION/CALL NUMBER | |
| -- | 09-22-2004 |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | |
| b | 08-12-10 |
| c | 08-06-10 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | Books |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| -- | audmc |
| Operator's initials, OID (RLIN) | 09-22-04 |
| Cataloger's initials, CIN (RLIN) | m |
| First Date, FD (RLIN) | a |
| -- | - |
| -- | eng |
| -- | xxu |
| -- | 0 |
| 906 ## - LOCAL DATA ELEMENT F, LDF (RLIN) | |
| a | 7 |
| b | cbc |
| c | copycat |
| d | 2 |
| e | ncip |
| f | 20 |
| g | y-gencatlg |
| 925 0# - | |
| -- | acquire |
| -- | 2 shelf copy |
| -- | policy default |
| 955 ## - COPY-LEVEL INFORMATION (RLIN) | |
| -- | jf09 2002-04-11 to sl |
| -- | jf12 2002-04-12 to Dewey; copy 2 added jf16 to BCCD 04-18-02 |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| g | 0 |
| i | 46358 |
| j | 0 |
| l | audmc |
| n | Copy Type:01 - Books |
| o | - |
| p | 0.00 |
| q | - |
| r | - |
| s | - |
| t | 1 |
| u | 0 |
| v | 0 |
| w | 0 |
| x | 0 |
| y | i10243549 |
| z | 08-06-10 |
| Lost status | Source of classification or shelving scheme | Materials specified (bound volume or other part) | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Cost, normal purchase price | Total Checkouts | Full call number | Barcode | Date last seen | Cost, replacement price | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Library of Congress Classification | Copy Type:01 - Books | American University in Dubai | American University in Dubai | Main Collection | 2010-08-06 | 0.00 | QA 76.3 .C675 2001 | 46358 | 2023-12-01 | 0.00 | 2015-07-25 | Books |