Guerrilla Oracle®
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Database software > Guerrilla Oracle®: The Succinct Windows Perspective
Guerrilla Oracle®: The Succinct Windows Perspective

Guerrilla Oracle®: The Succinct Windows Perspective


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Are you frustrated by your attempts to learn Oracle or improve your Oracle skills because of the sheer amount of technical documentation you have to wade through? This concise tutorial walks you step-by-step through the process, showing you exactly what you need to know to install, create, and support a successful Oracle 8i or 9i environment with Web capabilities.Guerrilla Oracle: The Succinct Windows Perspective presents clear explanations of database, SQL, and Oracle fundamentals. Using a real-world, large-scale example to demonstrate essential tasks, the book follows the Oracle DBMS life cycle from business idea to functioning database.Guerrilla Oracle gives you the foundation you need to build a functioning system and to begin exploring more complex technical topics. Along with a deeper understanding of the Oracle DBMS, you will learn the concrete skills, strategies, and techniques you need to make your database a reality.You will learn how to:Install and configure the Oracle Database server on a Windows serverConfigure client PCsInstall and define the Oracle Database softwareCreate basic database security schemas and formalize backup plansDesign a database and normalize the dataIntegrate a legacy system into the Oracle relational database model using SQL LoaderCreate the tablesDevelop and modify Oracle Forms and ReportsProgram in SQL, SQL Plus, and PL/SQLPerform major DBA responsibilitiesEnable remote accessPrepare your database for Web access and e-commerceThe accompanying CD-ROM includes a complete set of the book's code samples, scripts, and examples. 0201750775B01162003

Table of Contents:
Preface. Acknowledgments. 1. Introduction. Welcome! Oracle8i and 9i the Guerrilla Way. 2. The Three Most Important Dates. Dr Edgar F Codd, Radical Thinker. Storage Technology Becomes System R. Beep Beep! Here Comes Oracle Passing IBM on the Information Highway. 3. Concepts. Relational Databases. RDBMS. Relationships. Constraints. The Server Environment. SQL Programming Languages. SQL. SQL*Plus. PL/SQL. Development Tools. Oracle Forms. Oracle Reports. Oracle Web. Other Oracle Modules. Data Warehousing. Wireless. Thin and Thick Clients. 4. Business Opportunity. 5. Finalizing the Tables for the Waiver Exam. Refining the Tables. Data and Relationships. Data. Relationships. 6. The Major Parts of an Oracle Windows Installation. Concepts. An Oracle Instance. Tablespaces. Schemas. Synonyms. Oracle Home. Transaction Processing. System Identifier. Major Parts of the Installation. Installing the Server. Creating the Database. Creating Tables. Adding Users. Installing Clients and Net8. DBA Tasks and Programming. Web Enabling. Interfacing. 7. Installing the Oracle 8i and 9i Database Server. The Installation. 8. Security. System Security. Data Security. User Security. Password Management Policy. Password Aging. Account Locking. Password Complexity. Password History. Auditing. Building Your Security Schema. Profiles. Roles. Users. Privileges. Waiver Database Security. Tablespaces. Profiles. Roles. Users. Help from the Data Dictionary. The Entire Waiver Database Security Script. 9. Creating the Tables. Overview. Table Creation Syntax. Syntax Rules. Tablespaces. Creating the Tables. Getting Started. Creating the Tablespace. Creating Tables. The Entire Table Creation Script The Output Spool File. Loading the Tables. Method 1: SQL*Loader. Housekeeping. The Data File. The Control File. Running SQL*Loader. The Last Step. Some Advanced SQL*Loader. Method 2: Using a Script. Variation on Using a Script. Method 3: Using a GUI Form. 10. The Data Dictionary. What Is the Data Dictionary? How Does the Data Dictionary Work?. The Data Dictionary Views. 1. Tables. 2. Constraints 3. Primary Keys. 4. Profiles. 5. Roles. 6. Users. 7. Limits. 8. Tablespaces. 9. Auditing. 10. V$ Tables. 11. Installing the Oracle 8i and 9i Client. The Installation. Adding Another Service. In Case of Failure. 12. DBA Tasks. System Upgrades. Oracle Licensing. Startup and Shutdown. Backup and Recovery. Import and Export. The Export Step. The Import Step. Database Instances. Modification and Tuning. 13. Forms 6i. Installing Forms 6i. Creating a Simple Form. Running the Form. Creating Real GUI Forms. Preparation. Components of Forms 6i. Object Navigator. Property Palette. Canvas. PL/SQL Editor. Steps in Creating GUI Forms. Splash Screen. Canvas. Buttons. Images. Tools. The Splash Screen. Adding Image and Text to the Canvas. Displaying the Graphic. Building a Timer. The Main Screen. Calling Forms from Forms. Using the Forms. Building a Control Form. Building Screen Items. Message Box. Data. Lists of Values. Triggers. Handling Errors. Creating the Test Form. The Master Block. The Detail Block. Buttons. Tracking IDs. Linking the Forms. Menus. Creating a Menu Module. Creating Menu Items. Activating the Menu Items. Adding Menus to a Form. 14. Guerrilla Toolbox. Simple Report Writing. Calculations. Queries. Date Handling. Sequences. Manipulating Letters and Numbers. Strings. More Functions for Working with Strings. TRANSLATE. DECODE. Number Functions. NULL. Some Interesting Verbs and Adverbs You Should Know. GROUP BY. ORDER BY. WHERE. Triggers. Feeding Other Systems. Linking to Access. iSQL*Plus. 15. The Web! Appendix A. Forms 6i Security. Bibliography. Index. 0201750775T01022003

About the Author :
Richard J. Staron is manager of IS applications at Eastern Connecticut State University. He has more than twenty years of experience in the data processing field, including hierarchical and relational database design. Richard has extensive experience managing Oracle database installations, supervising Oracle programmers, and teaching Oracle programming. 0201750775AB11012002


Best Sellers


Product Details
  • ISBN-13: 9780201750775
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison Wesley
  • Height: 228 mm
  • No of Pages: 496
  • Sub Title: The Succinct Windows Perspective
  • Width: 184 mm
  • ISBN-10: 0201750775
  • Publisher Date: 26 Feb 2003
  • Binding: SA
  • Language: English
  • Spine Width: 23 mm
  • Weight: 743 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Guerrilla Oracle®: The Succinct Windows Perspective
Pearson Education (US) -
Guerrilla Oracle®: The Succinct Windows Perspective
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Guerrilla Oracle®: The Succinct Windows Perspective

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!