Wiley
Wiley.com
Print this page Share

Oracle Database Foundations: Technology Fundamentals for IT Success

ISBN: 978-0-7821-4372-0
349 pages
October 2004
Oracle Database Foundations: Technology Fundamentals for IT Success (0782143725) cover image
The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor.

Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Oracle 9i and 10g databases. What you learn here will benefit you in the short term, as you acquire and practice your skills, and in the long term, as you use them. Topics covered include:

  • Basic relational database concepts
  • Reporting and querying using SQL*Plus and iSQL*Plus
  • Creating and maintaining a database
  • Managing user access and security
  • Understanding Oracle database functions
  • Using multiple tables in a query
  • Restricting, sorting, and grouping data
  • Optimizing database performance
  • Creating backups
  • Troubleshooting database errors
See More
Introduction xiii

Chapter 1 Relational Database Concepts 1

Chapter 2 SQL*Plus and iSQL*Plus Basics 13

Chapter 3 Oracle Database Functions 43

Chapter 4 Restricting, Sorting, and Grouping Data 69

Chapter 5 Using Multiple Tables 93

Chapter 6 Advanced SQL Queries 117

Chapter 7 Logical Consistency 139

Chapter 8 Installing Oracle and Creating a Database 155

Chapter 9 Reporting Techniques 181

Chapter 10 Creating and Maintaining Database Objects 207

Chapter 11 Users and Security 229

Chapter 12 Making Things Run Fast (Enough) 245

Chapter 13 Saving Your Stuff (Backups) 273

Chapter 14 Troubleshooting 295

Appendix A Answers to Review Questions 313

Appendix B Common Database Platforms 327

Glossary 331

Index 339

See More
Bob Bryla, OCP, has worked with Oracle databases for over 10 years. He currently works as an Oracle DBA and Analyst for Lands' End in Dodgeville, Wisconsin.
See More
Back to Top