000			04769nam a2200493u 4500
001			ocm12732628
003			AE-DuAU
005			20241127165433.0
008			050916b ||||||||||||||||||||eng|u
010			_a2002277745
020			_a0072195371
020			_a007219538X (bk.)
020			_a0072195398 (CD)
035			_a(OCoLC)ocm48690676
040			_aCVU _cCVU _dOCLCQ _dDLC
042			_alccopycat
050	0	0	_aQA76.3 _b.C675 2001
090			_aQA 76.3 .C675 2001
100	1		_aCouchman, Jason S. _971376
245	1	0	_aOCP introduction to Oracle9i : _bSQL exam guide / _cJason Couchman.
246	1	4	_aOracle OCP introduction to Oracle9i
246	3	0	_aSQL exam guide
260			_aNew York : _bOsborne/McGraw-Hill, _c2001.
300			_axx, 485 p. : _bill. ; _c24 cm. + _e1 CD-ROM (4 3/4 in.)
336			_2rdacontent _atext _btxt
337			_2rdamedia _aunmediated _bn
338			_2rdacarrier _avolume _bnc
500			_a"Exam 1Z0-007"--Cover.
500			_aIncludes index.
505	0		_aPreparing 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	_aPrepare 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	0	0	_aOracle (Computer file) _971319
650		0	_aElectronic data processing personnel _xCertification. _9161342
650		0	_aDatabase management _xExaminations _vStudy guides. _9161343
650		0	_aSQL (Computer program language) _91922
852			_y09-22-2004
907			_a17956 _b08-12-10 _c08-06-10
942			_cBOOK _00
998			_aaudmc _b09-22-04 _cm _da _e- _feng _gxxu _h0
906			_a7 _bcbc _ccopycat _d2 _encip _f20 _gy-gencatlg
925	0		_aacquire _b2 shelf copy _xpolicy default
955			_djf09 2002-04-11 to sl _ejf12 2002-04-12 to Dewey; copy 2 added jf16 to BCCD 04-18-02
945			_g0 _i46358 _j0 _laudmc _nCopy Type:01 - Books _o- _p0.00 _q- _r- _s- _t1 _u0 _v0 _w0 _x0 _yi10243549 _z08-06-10
999			_c17956 _d17956