Cargando…
Oracle9i DBA JumpStart /
Get Up to Speed for Oracle9i Administration Training Courses--Fast!Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence:* Introduction to relational database concepts* Using basic SQL*Plus and iSQL*Plus commands* Understanding Oracle database...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
San Francisco, Calif. ; London :
SYBEX,
2003.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Oracle9i DBA JumpStart; Acknowledgments; Contents; Introduction; What You Need; What This Book Covers; Understanding Oracle Certification; Making the Most of This Book; About the Author; Chapter 1: Relational Database Concepts; Are Spreadsheets Like Databases?; Relational Databases; Object-Relational Databases; Chapter 2: SQL*Plus and iSQL*Plus Basics; Some SQL Formalities; Tools for Running SQL; The Ubiquitous SELECT Statement; DML for Making Changes; DDL for Handling Database Objects; DCL for Handling Privileges; Chapter 3: Oracle Database Functions; Query Basics
- Built-in Single-Row FunctionsUser-Defined Functions; Chapter 4: Restricting, Sorting, and Grouping Data; The WHERE Clause; The ORDER BY Clause; Group Functions and the GROUP BY Clause; Chapter 5: Using Multiple Tables; Join Syntax: Out with the Old and In with the New (SQL:1999); Equijoins; Non-equijoins; Outer Joins; Self-Joins; Cartesian Products: The Black Sheep of the Family; Chapter 6: Advanced SQL Queries; Subqueries; Set Operators; ROLLUP and CUBE; Chapter 7: Logical Consistency; Constraints; Transaction Processing; Chapter 8: Installing Oracle and Creating a Database
- Oracle Components OverviewInstalling Oracle Software; Creating an Oracle Database; Chapter 9: Reporting Techniques; iSQL*Plus Configuration; Report Formatting; Substitution Variables; Saving and Running Scripts; Chapter 10: Creating and Maintaining Database Objects; Creating Tables; Creating Indexes; Creating and Using Views; Creating Sequences and Synonyms; Chapter 11: Users and Security; Creating User Accounts; Granting and Revoking Privileges; Auditing; Chapter 12: Making Things Run Fast (Enough); Oracle's Tuning Methodology; Indexes; Data Design Tuning; SQL Application Tuning
- Memory TuningChapter 13: Saving Your Stuff (Backups); Database Failures; User Backup and Recovery Methods; DBA Backup and Recovery Methods; Chapter 14: Troubleshooting; The Alert Log File; OEM's Event Manager; System Trace Files; User Trace Files; Appendix A: Answers to Review Questions; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12; Chapter 13; Chapter 14; Appendix B: Glossary; Appendix C: Common Database Platforms; Enterprise Databases; Personal and Freeware Databases; Index