Table of Contents

Acknowledgments
Introduction
Chapter 1. Database Fundamentals
Chapter 2. Installing Oracle
Chapter 3. Connecting to Oracle
Chapter 4. SQL: Structured Query Language
Chapter 5. PL/SQL
Chapter 6. The Database Administrator
Chapter 7. Backup & Recovery
Chapter 8. High Availability: RAC, ASM, and Data Guard
Chapter 9. Large Database Features
Appendix A: Mastery Check Answers
Index

About the Author

Ian Abramson (Toronto, CN) is CTO of Data Warehousing for Data Visions Incorporated, in Toronto, Canada. Ian has 14 years of experience as an Oracle architect, designer, developer, and DBA; he has focused on data warehousing for the past five. As the director of educational programming for the IOUGA, he has created top-notch educational programs for the Oracle user community. Ian presents at Oracle conferences worldwide and is a faculty member of the IOUGA University Master Class program.



Michael S. Abbey (Ottawa, CN) has been using Oracle for 15 years, has co-authored seven books for Oracle Press, and has given presentations on Oracle throughout North America and Europe. Michael leads the Pythian Groups dbaSource team in Ottawa, Canada, which provides Internet-based Oracle DBA support. He has also been a volunteer in Oracle user groups, facilitating delivery of IOUGAs IOUG-A Live! from 1997 to 2000.



Michael Corey is the Founder and Chief Executive Officer of Ntirety L.L.C. (www.ntirety.com) located in Newton, Massachusetts, Ntirety specializes in Remote Database Administration. Prior to founding Ntirety Mike co-founded Database Technologies, the first consulting company on the East Coast to specialize in Oracle and other relational databases. Under Mike's direction, Database Technologies experienced triple-digit growth. In 1997 Deloitte & Touche, and Hale and Dorr recognized Database Technologies as the fastest growing Technology Company in New England and the 51st fastest growing hi-tech company in the United States. Mr. Corey is a recognized expert on Relational Databases and Data Warehousing.  He has written a number of articles and books. Mike is a frequent guest speaker at technology conferences throughout the world.In addition to being an entrepreneur and writer, Mr. Corey is a founding member of a number of Oracle groups, including Oracle User Resource, Oracle World Wide Affinity Program and the Oracle Presidents Council.  He is a past president of the International Oracle User Group, Northeast Oracle Users Group,.  He is also a past member of the Board of Directors for the International Oracle User Group Americas and a member of the Microsoft Corporation Data Warehousing Advisory Group.Mr. Corey has a B.S. in Management Information Systems from Bentley College, in Waltham, Massachusetts.  He has also attended the Entrepreneurial Management program at Babson College in 1995, 1996, 1997 and 1998.Feel free to contact Mike at michael.corey@ntirety.com.