OCA/OCP: Introduction to Oracle9i SQL Study Guide
Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i:\ * In-depth coverage of official exam objectives\ * Practical information on using SQL in a real-world Oracle9i environment\ * Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including:\ * Writing basic SQL SELECT statements\ * Restricting and sorting data\ * Displaying data from multiple tables\ * Aggregating data using group functions\ *...
Search in google:
Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i:* In-depth coverage of official exam objectives* Practical information on using SQL in a real-world Oracle9i environment* Hundreds of challenging review questions, in the book and on the CDAuthoritative coverage of all exam objectives, including:* Writing basic SQL SELECT statements* Restricting and sorting data* Displaying data from multiple tables* Aggregating data using group functions* Producing readable output with iSQL*Plus* Creating and managing tables* Controlling user access
IntroductionAssessment TestCh. 1Basic SQL SELECT Statements1Ch. 2SQL[superscript *]Plus Overview53Ch. 3Single-Row Functions111Ch. 4Aggregating Data And Group Functions189Ch. 5Joins and Subqueries241Ch. 6Modifying Data289Ch. 7Managing Tables and Constraints333Ch. 8Managing Views389Ch. 9Other Database Objects421Ch. 10User Access and Security455Glossary503Index513
