Oracle Database Foundations

Oracle Database Foundations : Technology Fundamentals for IT Success

By (author) 

List price: US$26.50

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

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.It covers topics including: basic relational database concepts; reporting and querying using SQLPlus and iSQLPlus; 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; and, troubleshooting database errors.
show more

Product details

  • Paperback | 349 pages
  • 188 x 228 x 20mm | 611g
  • Sybex Inc.,U.S.
  • New York, United States
  • English
  • New.
  • 0782143725
  • 9780782143720

Back cover copy

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 9"i" and 10"g" 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
show more

Table of contents

Contents at a Glance. Introduction. Chapter 1: Relational Database Concepts. Chapter 2: SQLPlus and iSQLPlus Basics. Chapter 3: Oracle Database Functions. Chapter 4: Restricting, Sorting, and Grouping Data. Chapter 5: Using Multiple Tables. Chapter 6: Advanced SQL Queries. Chapter 7: Logical Consistency. Chapter 8: Installing Oracle and Creating a Database. Chapter 9: Reporting Techniques. Chapter 10: Creating and Maintaining Database Objects. Chapter 11: Users and Security. Chapter 12: Making Things Run Fast (Enough). Chapter 13: Saving Your Stuff (Backups). Chapter 14: Troubleshooting. Appendix A Answers to Review Questions. Appendix B Common Database Platforms. Glossary. Index.
show more

About Bob Bryla

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.
show more