OCA/OCP [[electronic resource] ] : introduction to Oracle9i SQL : study guide / / Chip Dawes, Biju Thomas

• Record Nr.: UNINA9910455215803321
• Autore: Dawes Chip
• Pubbl/distr/stampa: San Francisco, CA, : Sybex, 2002
• ISBN: 1-280-65252-7; 9786610652525; 0-585-47721-3; 0-7821-5250-3
• Edizione: [1st ed.]
• Descrizione fisica: 1 online resource (611 p.)
• Altri autori (Persone): ThomasBiju
• Disciplina: 005.75/85
• Soggetti: Electronic data processing personnel - Certification; Database management - Examinations; SQL (Computer program language); Electronic books.
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: "Exam 1Z0-007"--Cover.
• Nota di contenuto: OCA/OCP: Introduction to Oracle9i SQL; Acknowledgments; Contents at a Glance; Contents; Introduction; Why Become an Oracle Certified Professional?; What Does This Book Cover?; How to Contact the Authors; Assessment Test; Answers to Assessment Test; Chapter 1: Basic SQL SELECT Statements; SQL Fundamentals; Writing Simple Queries; Other Operators; Sorting Rows; Using Expressions; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 2: SQL*Plus Overview; SQL*Plus Fundamentals; Producing More Readable Output; Accepting Values at RuntimeUsing iSQL*Plus; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 3: Single-Row Functions; Single-Row Function Fundamentals; NULLs and Single-Row Functions; Using Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to ; Review Questions; Chapter 4: Aggregating Data And Group Functions; Group Function Fundamentals; Using Group FunctionsNesting Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 5: Joins and Subqueries; Multiple-Table Queries; Subqueries; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 6: Modifying Data; Using DML Statements; Inserting into Multiple Tables; Updating Rows in a Table; Merging Rows into a Table; Deleting Rows from a Table; Truncating a Table; Selecting Rows; Locking a Table; Understanding Transaction Control; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review QuestionsChapter 7: Managing Tables and Constraints; Database Objects Review; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Creating Constraints; Dropping Constraints; Enabling and Disabling Constraints; Deferring Constraint Checks; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 8: Managing Views; Creating and Modifying Views; Using Views; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 9: Other Database Objects; Creating and Managing Sequences; Creating and Managing SynonymsCreating and Managing Indexes; Calling Stored Programs; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 10: User Access and Security; Creating and Modifying User Accounts; Creating and Using Roles; Granting and Revoking Privileges; Managing User Groups with Profiles; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Index
• Sommario/riassunto: 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