Oracle Database 10g: A Beginner's Guide / Edition 1

by Michael J. Corey, Ian Abramson, Michael Abbey, Michael S. Abbey

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

All New Content

Get a Solid Foundation in Oracle Database Technology

Learn the fundamental concepts of Oracle Database 10g administration and programming from this step-by-step beginner’s guide. Through self-paced tutorials, learn about database essentials, the role of the administrator, and large database features. You’ll also get an in-depth introduction to SQL, PL/SQL, Java, and XML programming. Get on your way to becoming an expert Oracle DBA, developer, or user by following the proven learning method of this Oracle Press guide:

• Core Concepts—Each concept is divided into logically organized chapters, ideal for self-paced learning
• Critical Skills—Every chapter opens with the specific skills covered in the chapter
• Projects—Practical exercises show how to apply the critical skills learned in each chapter
• Progress Checks—Quick self-assessment sections check your progress
• Ask the Experts—Q&A sections throughout are filled with bonus information and helpful tips
• Mastery Checks—End-of-chapter reviews test knowledge using short-answer, multiple-choice, and fill-in-the-blank questions

Product Details

ISBN-13:	9780072230789
Publisher:	McGraw Hill LLC
Publication date:	03/31/2004
Series:	Oracle Press
Pages:	416
Product dimensions:	7.30(w) x 9.10(h) x 0.82(d)

About the Author

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 [e-mail].

Michael S. Abbey (Ottawa, CN) has been using Oracle for 15 years, has coauthored seven books for Oracle Press, and has given presentations on Oracle throughout North America and Europe. Michael leads the Pythian Group’s dbaSource team in Ottawa, Canada, which provides Internet-based Oracle DBA support. Michael has been a volunteer in Oracle user groups, facilitating delivery of IOUG–A’s IOUG-A Live! from 1997 to 2000. Michael J. Corey (Newton, MA) is currently CTO with OneWarranty.com. Prior to this, he was the CEO of Database Technologies, Inc. which was the first consulting company in the eastern US to specialize in RDBMS’. Michael has been working with Oracle since Version 3 and is an active member of various Oracle user communities. In addition to his membership in the Northeast Oracle Users Group, he is a founding member of the ECO conference and has served as president of the International Oracle Users Group–Americas (IOUG–A).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 IOUG–A, 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 IOUG–A 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 Group’s 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–A’s IOUG-A Live! from 1997 to 2000.

Table of Contents

	Acknowledgments	xv
	Introduction	xvi
1	Database Fundamentals	1
Critical Skill 1.1	Define a Database	2
Critical Skill 1.2	Learn the Oracle Database 10g Architecture	3
Critical Skill 1.3	Learn the Basic Oracle Database 10g Data Types	10
Critical Skill 1.4	Work with Tables	12
Critical Skill 1.5	Work with Stored Objects	14
Critical Skill 1.6	Become Familiar with Other Important Items in the Oracle Database 10g	19
Critical Skill 1.7	Work with Object and System Privileges	23
Critical Skill 1.8	Introduce Yourself to the Grid	25
Critical Skill 1.9	Tie It All Together	28
	Chapter 1 Mastery Check	30
2	SQL: Structured Query Language	33
Critical Skill 2.1	Learn the SQL Statement Components	34
Critical Skill 2.2	Use Basic insert and select Statements	36
Critical Skill 2.3	Use Simple where Clauses	39
Critical Skill 2.4	Use Basic update and delete Statements	46
Critical Skill 2.5	Order Data	50
Critical Skill 2.6	Employ Functions: String, Numeric, Aggregate (No Grouping)	51
Critical Skill 2.7	Use Dates and Data Functions (Formatting and Chronological)	54
Critical Skill 2.8	Employ Joins (ANSI vs. Oracle): Inner, Outer, Self	57
Critical Skill 2.9	Learn the group by and having Clauses	67
Critical Skill 2.10	Learn Subqueries: Simple and Correlated Comparison with Joins	72
Critical Skill 2.11	Use Set Operators: Union, Intersect, Minus	74
Critical Skill 2.12	Use Views	78
Critical Skill 2.13	Learn Sequences: Just Simple Stuff	79
Critical Skill 2.14	Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering Exceptions	80
Critical Skill 2.15	Format Your Output with SQL*Plus	83
	Chapter 2 Mastery Check	87
3	The Database Administrator	89
Critical Skill 3.1	Learn the Job of the DBA	90
Critical Skill 3.2	Understand the Oracle Database 10g DBA Skill Set	90
Critical Skill 3.3	Perform Day-to-Day Operations	91
Critical Skill 3.4	Understand the Oracle Database 10g Infrastructure	93
Critical Skill 3.5	Operate Modes of an Oracle Database 10g	97
Critical Skill 3.6	Get Started with Oracle Enterprise Manager	101
Critical Skill 3.7	Manage Database Objects	106
Critical Skill 3.8	Manage Space	109
Critical Skill 3.9	Manage Users	112
Critical Skill 3.10	Manage Privileges for Database Users	115
	Chapter 3 Mastery Check	120
4	Networking	121
Critical Skill 4.1	Use Oracle Net Services	122
Critical Skill 4.2	Learn the Difference Between Dedicated and Shared Server Architectures	127
Critical Skill 4.3	Define Connections	134
Critical Skill 4.4	Use the Oracle Net Listener	137
Critical Skill 4.5	Learn Naming Methods	140
Critical Skill 4.6	Use Oracle Configuration Files	144
Critical Skill 4.7	Use Administration Tools	146
Critical Skill 4.8	Use Profiles	154
Critical Skill 4.9	Network in a Multitiered Environment	155
	Chapter 4 Mastery Check	156
5	Backup and Recovery	157
Critical Skill 5.1	Oracle Backup and Recovery Fundamentals	158
Critical Skill 5.2	Learn about Oracle User-Managed Backup and Recovery	164
Critical Skill 5.3	Write a Database Backup	170
Critical Skill 5.4	Back Up Archived Redo Logs	172
Critical Skill 5.5	Get Started with Oracle Data Pump	173
Critical Skill 5.6	Use Oracle Data Pump Export	174
Critical Skill 5.7	Work with Oracle Data Pump Import	178
Critical Skill 5.8	Use Traditional Export and Import	183
Critical Skill 5.9	Get Started with Recovery Manager	185
	Chapter 5 Mastery Check	197
6	PL/SQL	199
Critical Skill 6.1	Define PL/SQL and Why We Use It	200
Critical Skill 6.2	Describe the Basic PL/SQL Program Structure	202
Critical Skill 6.3	Define PL/SQL Data Types	204
Critical Skill 6.4	Write PL/SQL Programs in SQL*Plus	210
Critical Skill 6.5	Handle Error Conditions in PL/SQL	217
Critical Skill 6.6	Include Conditions in Your Programs	222
Critical Skill 6.7	Create Stored Procedures--How and Why	232
Critical Skill 6.8	Create and Use Functions	237
Critical Skill 6.9	Call PL/SQL Programs	239
	Chapter 6 Mastery Check	240
7	Java	241
	Java Server Fundamentals	242
Critical Skill 7.1	What Does Java Mean to an Oracle DBA?	242
Critical Skill 7.2	Overview of Java	245
Critical Skill 7.3	Configure Java for Oracle	254
Critical Skill 7.4	Java in Oracle	256
Critical Skill 7.5	JDBC Drivers	258
Critical Skill 7.6	Use JDBC	259
Critical Skill 7.7	Use SQLJ	261
Critical Skill 7.8	Java-Stored Procedures	262
Critical Skill 7.9	Create Java Objects in Oracle	266
Critical Skill 7.10	Understand Oracle Java Products	267
	Chapter 7 Mastery Check	269
8	XML	271
Critical Skill 8.1	Understand XML	272
Critical Skill 8.2	XML DB: Use XML in the Database	273
Critical Skill 8.3	SQLX: Create XML from Data Stored in Oracle	276
Critical Skill 8.4	Store XML in Oracle XML DB	283
Critical Skill 8.5	Use Simple Queries	291
Critical Skill 8.6	Create a Relational View from XML	294
Critical Skill 8.7	Learn Programmatic Access Using XSLT	296
	Chapter 8 Mastery Check	297
9	Large Database Features	299
Critical Skill 9.1	What Is a Large Database?	300
Critical Skill 9.2	Why and How to Use Data Partitioning	301
Critical Skill 9.3	Compress Your Data	323
Critical Skill 9.4	Use Parallel Processing to Improve Performance	327
Critical Skill 9.5	Use Materialized Views	331
Critical Skill 9.6	Real Application Clusters: A Primer	336
Critical Skill 9.7	Automatic Storage Management: Another Primer	338
Critical Skill 9.8	Grid Computing: The "g" in Oracle Database 10g	340
Critical Skill 9.9	Use SQL Aggregate and Analysis Functions	343
Critical Skill 9.10	Create SQL Models	355
	Chapter 9 Mastery Check	360
A	Mastery Check Answers	363
	Index	381

Editorial Reviews

Two new Oracle instruction and resource titles from Osborne/McGraw-Hill are indispensable additions to personal and professional reference collections. Oracle Database 10g: A Beginner's Guide (0072230789; 416 pages; $39.99) is the collective effort of Oracle experts Ian Abramson, Michael Abbey and Michael Corey. Oracle Database 10g provides neophytes with the fundamental concepts of Oracle Database 10g administration and programming. Through self-paced tutorials, readers will learn about database essentials, the role of the administrator, and large database features. Oracle Database 10g includes an in-depth introduction to SQL, PL/SQL, Java, and XML programming.

Bookwatch

These two guides distill the essential features of the newest version of the complex and weighty Oracle database. For absolute beginners, Beginner's Guide aims in straightforward language to reduce the intimidation factor by covering basic concepts, from architecture to using XML with Oracle databases. Step-by-step projects, chapter mastery checks, and test-yourself progress checks aid in self-study; "Ask the Expert" sidebars and notes add extra information without interrupting the flow. Highly recommended for public libraries. Essentials serves more as a basic reference for existing Oracle users, with chapters organized largely into lengthy definitions and explanations of features. It will also be of use to ambitious beginners and will particularly help upgraders. The authors highlight 10g features that differ from those in the older 8i and 9i versions, while tips, tables, and notes throughout add useful information. An appendix includes a chapter-by-chapter summary of new 10g features, and the title ends with a nice overview of grid computing (the "g" in 10g). For medium and larger libraries. Copyright 2004 Reed Business Information.

Library Journal