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:
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
Overview
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,...