Overview

Oracle 9i SQL Exam Cram2 I have decided that the Que Certification books will be my first choice for any other cert exams I take. I just think they are a cut above. --John CalcagniIn This Book You ll Learn How To:Retrieve data using the SELECT statement Filter rows with the WHERE clauseSort data with the ORDER BY clause Use operators, conditions, pseudocolumns expressions, and single row functionsGroup and summarize rows with the GROUP BY clause Construct subqueries and other specialized queriesFormat with SQL*Plus Change data using DML INSERT, UPDATE, and DELETE commandsUse DDL commands for creating and maintaining tables, their datatypes, and constraintsUse DDL commands for creating and maintaining views, indexes, sequences, and synonymsImplement Oracle database securityThe Exam Cram Method of study focuses on exactly what you need to get certified now.Organized according to the exam objectives so you can quickly and easily assess your understanding of the key material covered on the Oracle 9i SQL exam.Edited by Ed Tittel, two-time finalist for Favorite Study Guide Author in a poll of CertCities readers and original creator of the Exam Cram series.Features dozens of test-taking strategies and time-saving tips! Use our popular Cram Sheet tearcard--which includes exam tips, acronyms, and memory joggers--for a last-minute review before you take your exam.Register for The Crammers Club (www examcram2.com) for access to additional practice questions, industry news, our Question of the Day program, and an online community where you can ask questions and participate in open forums with others who are studying for their Oracle 9i SQL exam.

Full Product Details

9780789732484

Table of Contents

Reviews

Author Information

Gavin Powell BSc. Comp. Sci., OCP DBA (Oracle Certified Professional) has 15 years of diverse experience in database administration and database development, both relational and object databases. His applications development experience is procedural and object-oriented. Consulting experience includes software vendors, Internet dotcoms, accounting, banking and financial services, the travel industry, construction, retail, mining, shipping, education and in a general advisory capacity. Gavin is the author of five other Oracle titles, including three Oracle certification titles.

Tab Content 6

Customer Reviews

Recent Reviews

Countries Available