Oracle Database 10g: A Beginner's Guide / Edition 1
by Ian Abramson, Michael Abbey, Michael Corey, Michael S. AbbeyView All Available Formats & Editions
ISBN-10: 0072230789
ISBN-13: 9780072230789
Pub. Date: 03/31/2004
Publisher: McGraw-Hill Professional Publishing
Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.
Overview
Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.
Product Details
- ISBN-13:
- 9780072230789
- Publisher:
- McGraw-Hill Professional Publishing
- Publication date:
- 03/31/2004
- Series:
- Oracle Press Series
- Pages:
- 416
- Product dimensions:
- 7.30(w) x 9.10(h) x 0.82(d)
Table of Contents
| Acknowledgments | xv | |
| Introduction | xvi | |
| 1 | Database Fundamentals | 1 |
| Critical Skill 1.1 | Define a Database | 2 |
| Critical Skill 1.2 | Learn the Oracle Database 10g Architecture | 3 |
| Critical Skill 1.3 | Learn the Basic Oracle Database 10g Data Types | 10 |
| Critical Skill 1.4 | Work with Tables | 12 |
| Critical Skill 1.5 | Work with Stored Objects | 14 |
| Critical Skill 1.6 | Become Familiar with Other Important Items in the Oracle Database 10g | 19 |
| Critical Skill 1.7 | Work with Object and System Privileges | 23 |
| Critical Skill 1.8 | Introduce Yourself to the Grid | 25 |
| Critical Skill 1.9 | Tie It All Together | 28 |
| Chapter 1 Mastery Check | 30 | |
| 2 | SQL: Structured Query Language | 33 |
| Critical Skill 2.1 | Learn the SQL Statement Components | 34 |
| Critical Skill 2.2 | Use Basic insert and select Statements | 36 |
| Critical Skill 2.3 | Use Simple where Clauses | 39 |
| Critical Skill 2.4 | Use Basic update and delete Statements | 46 |
| Critical Skill 2.5 | Order Data | 50 |
| Critical Skill 2.6 | Employ Functions: String, Numeric, Aggregate (No Grouping) | 51 |
| Critical Skill 2.7 | Use Dates and Data Functions (Formatting and Chronological) | 54 |
| Critical Skill 2.8 | Employ Joins (ANSI vs. Oracle): Inner, Outer, Self | 57 |
| Critical Skill 2.9 | Learn the group by and having Clauses | 67 |
| Critical Skill 2.10 | Learn Subqueries: Simple and Correlated Comparison with Joins | 72 |
| Critical Skill 2.11 | Use Set Operators: Union, Intersect, Minus | 74 |
| Critical Skill 2.12 | Use Views | 78 |
| Critical Skill 2.13 | Learn Sequences: Just Simple Stuff | 79 |
| Critical Skill 2.14 | Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering Exceptions | 80 |
| Critical Skill 2.15 | Format Your Output with SQL*Plus | 83 |
| Chapter 2 Mastery Check | 87 | |
| 3 | The Database Administrator | 89 |
| Critical Skill 3.1 | Learn the Job of the DBA | 90 |
| Critical Skill 3.2 | Understand the Oracle Database 10g DBA Skill Set | 90 |
| Critical Skill 3.3 | Perform Day-to-Day Operations | 91 |
| Critical Skill 3.4 | Understand the Oracle Database 10g Infrastructure | 93 |
| Critical Skill 3.5 | Operate Modes of an Oracle Database 10g | 97 |
| Critical Skill 3.6 | Get Started with Oracle Enterprise Manager | 101 |
| Critical Skill 3.7 | Manage Database Objects | 106 |
| Critical Skill 3.8 | Manage Space | 109 |
| Critical Skill 3.9 | Manage Users | 112 |
| Critical Skill 3.10 | Manage Privileges for Database Users | 115 |
| Chapter 3 Mastery Check | 120 | |
| 4 | Networking | 121 |
| Critical Skill 4.1 | Use Oracle Net Services | 122 |
| Critical Skill 4.2 | Learn the Difference Between Dedicated and Shared Server Architectures | 127 |
| Critical Skill 4.3 | Define Connections | 134 |
| Critical Skill 4.4 | Use the Oracle Net Listener | 137 |
| Critical Skill 4.5 | Learn Naming Methods | 140 |
| Critical Skill 4.6 | Use Oracle Configuration Files | 144 |
| Critical Skill 4.7 | Use Administration Tools | 146 |
| Critical Skill 4.8 | Use Profiles | 154 |
| Critical Skill 4.9 | Network in a Multitiered Environment | 155 |
| Chapter 4 Mastery Check | 156 | |
| 5 | Backup and Recovery | 157 |
| Critical Skill 5.1 | Oracle Backup and Recovery Fundamentals | 158 |
| Critical Skill 5.2 | Learn about Oracle User-Managed Backup and Recovery | 164 |
| Critical Skill 5.3 | Write a Database Backup | 170 |
| Critical Skill 5.4 | Back Up Archived Redo Logs | 172 |
| Critical Skill 5.5 | Get Started with Oracle Data Pump | 173 |
| Critical Skill 5.6 | Use Oracle Data Pump Export | 174 |
| Critical Skill 5.7 | Work with Oracle Data Pump Import | 178 |
| Critical Skill 5.8 | Use Traditional Export and Import | 183 |
| Critical Skill 5.9 | Get Started with Recovery Manager | 185 |
| Chapter 5 Mastery Check | 197 | |
| 6 | PL/SQL | 199 |
| Critical Skill 6.1 | Define PL/SQL and Why We Use It | 200 |
| Critical Skill 6.2 | Describe the Basic PL/SQL Program Structure | 202 |
| Critical Skill 6.3 | Define PL/SQL Data Types | 204 |
| Critical Skill 6.4 | Write PL/SQL Programs in SQL*Plus | 210 |
| Critical Skill 6.5 | Handle Error Conditions in PL/SQL | 217 |
| Critical Skill 6.6 | Include Conditions in Your Programs | 222 |
| Critical Skill 6.7 | Create Stored Procedures--How and Why | 232 |
| Critical Skill 6.8 | Create and Use Functions | 237 |
| Critical Skill 6.9 | Call PL/SQL Programs | 239 |
| Chapter 6 Mastery Check | 240 | |
| 7 | Java | 241 |
| Java Server Fundamentals | 242 | |
| Critical Skill 7.1 | What Does Java Mean to an Oracle DBA? | 242 |
| Critical Skill 7.2 | Overview of Java | 245 |
| Critical Skill 7.3 | Configure Java for Oracle | 254 |
| Critical Skill 7.4 | Java in Oracle | 256 |
| Critical Skill 7.5 | JDBC Drivers | 258 |
| Critical Skill 7.6 | Use JDBC | 259 |
| Critical Skill 7.7 | Use SQLJ | 261 |
| Critical Skill 7.8 | Java-Stored Procedures | 262 |
| Critical Skill 7.9 | Create Java Objects in Oracle | 266 |
| Critical Skill 7.10 | Understand Oracle Java Products | 267 |
| Chapter 7 Mastery Check | 269 | |
| 8 | XML | 271 |
| Critical Skill 8.1 | Understand XML | 272 |
| Critical Skill 8.2 | XML DB: Use XML in the Database | 273 |
| Critical Skill 8.3 | SQLX: Create XML from Data Stored in Oracle | 276 |
| Critical Skill 8.4 | Store XML in Oracle XML DB | 283 |
| Critical Skill 8.5 | Use Simple Queries | 291 |
| Critical Skill 8.6 | Create a Relational View from XML | 294 |
| Critical Skill 8.7 | Learn Programmatic Access Using XSLT | 296 |
| Chapter 8 Mastery Check | 297 | |
| 9 | Large Database Features | 299 |
| Critical Skill 9.1 | What Is a Large Database? | 300 |
| Critical Skill 9.2 | Why and How to Use Data Partitioning | 301 |
| Critical Skill 9.3 | Compress Your Data | 323 |
| Critical Skill 9.4 | Use Parallel Processing to Improve Performance | 327 |
| Critical Skill 9.5 | Use Materialized Views | 331 |
| Critical Skill 9.6 | Real Application Clusters: A Primer | 336 |
| Critical Skill 9.7 | Automatic Storage Management: Another Primer | 338 |
| Critical Skill 9.8 | Grid Computing: The "g" in Oracle Database 10g | 340 |
| Critical Skill 9.9 | Use SQL Aggregate and Analysis Functions | 343 |
| Critical Skill 9.10 | Create SQL Models | 355 |
| Chapter 9 Mastery Check | 360 | |
| A | Mastery Check Answers | 363 |
| Index | 381 |
Customer Reviews
Average Review:
Most Helpful Customer Reviews
Oracle Database 10g: A Beginner's Guide
2.5 out of 5
based on
0 ratings.
4 reviews.
 |
This book is a great place for inexperienced Oracle developers to begin learning about the new 10g architecture. Designed as a crash-course in everything one would need to know to effectively maintain and develop for an Oracle database, this book does a good job to quickly get the reader in control of this potentially complex data system. After a brief introduction to Oracle data types and the basic environment (like tables, views, and indexes), the authors present a fairly detailed section on writing data queries. While much in this section can be applied to some of the more recent versions of Oracle, it is targeted to the 10g platform. The reader interested in this section will also likely want to read Chapter 6, which focuses on writing PL/SQL. For the aspiring database administrator, there are some very good sections on what an Oracle DBA should do. While simply reading these sections won¿t make you a DBA, they contain a lot of good information including discussions on networking issues and disaster recovery. The rest of the book contains a lot of information on Oracle features, which can be used by both database developers and DBAs. Examples include Oracle¿s use of XML and Java, as well as database maintenance issues for supporting large datasets. This is a great beginner¿s book to Oracle 10g, as it includes just enough information to be useful, but not so much that it becomes overwhelming. This is definitely a good book to pick up if you are new to Oracle or the 10g platform.
|
|
I was using this book as my "gateway" book into Oracle 10g. What a mistake. It is for beginner's in that it covers a wide range of topics with little depth however to the point of inaccuracy. This book is riddled with errors in its examples and the writing style is not very clear at all. It seems like 1/3 of the book contains sentences stating "oh this part is very important to learn" instead of getting to the meat and potatoes. I would definitely fire whoever proofread the book. It almost seems like English is not the first language of the author(s) or they are horrible at getting their thoughts across on paper. Skip this one!!!
|
|
|
|
|