Synopses & Reviews
Get Full Details on the Latest Release from Oracle
Prepare for the future of e-business with Oracle9i and the comprehensive information contained in this volume. Packed with insider tips and real-world examples, Oracle9i: A Beginner's Guide starts with an overview of Oracle's history and product strategy, moves on to beginner-level PL/SQL and DBA concepts, and concludes with in-depth coverage of more advanced data management and manipulation techniques. It's all here--from setting up, querying, and managing your database to creating forms, reports, and tables, securing users and objects, and partitioning data. Plus, you'll get unique, all-new coverage of SQL*Plus, Oracle Enterprise Manager, and the Oracle Summary Machine.
- Get a detailed look at the Oracle9i Database and an overview of Oracle9i Application Server
- Exploit Oracle Support Services and resources--TARs, MetaLink, iTARs, Oracle Technology Network, and AppsNet
- Create tables, generate reports, and develop applications with SQL, SQL*Plus, and PL/SQL
- Understand the part played by data files, redo logs, and control files
- Interconnect vast numbers of computers using distributed processing, Oracle Net, and database links
- Manage larger tables using data warehousing and the Oracle Summary Machine
- Build database objects using DDL and DML statements
Synopsis
Your introductory resource to all the powerful new features of Oracle9i--only from the authorized Oracle Press. This beginner's guide starts with an introduction to Oracle Corporation and where it is going with its product strategy, and then moves on to an overview of the RDBMS and the roll of a DBA, and progresses to slightly more advanced topics.
About the Author
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 IOUG–As IOUG-A Live! from 1997 to 2000.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
[email protected] Abramson (Toronto, CN) is CTO of Data Ware-housing for Data Visions Incorporated. He has 14 years experience as an Oracle architect, designer, developer, and DBA. Ian has focused on data ware-housing for the past five years. As the director of educational programming for the IOUG–A, he has created top-notch educational programs for the Oracle user community. He presents at Oracle conferences worldwide and is a faculty member of the IOUG–A University Master Class program.
Table of Contents
Getting up to Speed Oracle the Company – Oracle the Software Roadmap to Services The Oracle Server So You’ve Just Started Working with the Software Database Objects SQL*Plus 101 PL/SQL 101 DBA 101 Beyond the Basics SQL* Plus 201 PL/SQL 201 DBA 201 Oracle Enterprise Manager and DBA Studio Distributed Databases I Is for Internet, E Is for Electronic The “i” in Oracle9i All Things that Are WWW All the Stuff that Starts with “E” Who Said You Were a Beginner? Tool Overview Partitioning Data Data Warehousing and the Oracle Summary Machine