Book Details
Paperback: 504 pages
Publisher: Wrox (December 5, 2005)
Language: English
ISBN-10: 0764574906
ISBN-13: 978-0764574900

Book Description

The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently
Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle
Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance
Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements


From the Back Cover
Database design involves how to best structure the tables and queries that are used with databases in order to provide optimum performance, storage, manageability, and flexibility. With relational databases, you can use those tables to organize your data and retrieve information from your database. This book provides you with an easy-to-understand explanation of designing and building relational database models to do just that.
The numerous step-by-step examples and a helpful case study simplify a potentially complex subject and present it to you in an organized, understandable manner. You'll find out why relational database models became necessary in the first place, and how the relational database model was devised. Ultimately, you'll discover how to make much better use of your database by applying what you've learned about building the database model.


For more free books download visit this blog daily



Download




.

Book Details

Paperback: 604 pages
Publisher: Sams; 1st edition (December 1997)
Language: English
ISBN-10: 0672311593
ISBN-13: 978-0672311598


Book Description
Understanding, using, and administrating an RDBMS (Relational Database Management System) can be a daunting task, even with Oracle8, Oracle's new object-oriented RDBMS. This fact-filled book provides step-by-step coverage of Oracle8 architecture, managing database storage, security, backup, recovery and tuning, and optimization.

From the Publisher
Teach Yourself Oracle8 in 21 Days is a tutorial that will teach the reader the basics of using and administrating an Oracle database. This book focuses on using concrete examples to explain why things should be done in a certain way. The key topics are broken out by week below:Week One Overview of the Oracle8 Architecture; Network Computing Architecture (NCA); Installing Oracle; Planning the Database; How to Administer Users, and How to Manage Processes.Week Two Administering Logs, Control Files, Datafiles, and Tablespaces; Controlling Rolback Segments; Building Tables and Views; Using Indexes and Clusters; and Security.Week Three Effective Backup Techniques; Recovering the Database; Administering Oracle Replication; Tuning and Optimizing the Database; Administering the Oracle Web Server; and Advanced Oracle Options. - This hands-on tutorial teaches the basics of Oracle8 in a short period of time
- The book provides a step-by-step walk through of the Oracle8 architecture, managing database storage and database schema, security, backup and recovery and tuning and optimization.

- Oracle8 is Oracle's new object-oriented RDBMS to be released during the Summer of 1997.


For more free books download visit this blog daily



Download



.

Steven Feuerstein's first book, Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language -- the package. The use of packages can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology. In this book, Feuerstein explains how to construct packages -- and how to build them the right way. His "best practices" for building packages will transform the way you write packages and help you get the most out of the powerful, but often poorly understood, PL/SQL language.

Much more than a book, Advanced Oracle PL/SQL Programming with Packages comes with a PC diskette containing a full-use software companion. Developed by Feuerstein, RevealNet's PL/Vision Lite is the first of its kind for PL/SQL developers: a library of thirty-plus PL/SQL packages. The packages solve a myriad of common programming problems and vastly accelerate the development of modular and maintainable applications.

The packages provided in PL/Vision Lite fall into three categories:


* Building block packages: low-level development enhancers, including string parsers, a list manager, and an interface to PL/SQL tables.
* Developer utilities: programs that improve your PL/SQL development environment, including a code generator, a powerful substitute for SHOW ERRORS, and an online help delivery mechanism.
* Plug-and-play components: pieces of code that can be used as is in your own applications, including a high-level exception handler mechanism and a generic, reusable logging mechanism.



In addition to describing the details of these packages, this book explores why and how they were built the way they were. You'll come away with an increased appreciation of the PL/SQL language and the power of packages. Most importantly, you'll be ready and eager to put that power to use immediately in your own applications.




Download




.

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales' extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.

Author Don Bales takes his 20 years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule -- cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

* Discover the 20% of PL/SQL that gives you 80% of the bang--key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
* Learn how to write production-level, object-oriented PL/SQL--you'll explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQL's object-oriented features as well.
* Work through real examples of using of PL/SQL--you'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.

What you'll learn

* How important SQL is in PL/SQL
* How to use PL/SQL in both a relational and object-relational setting
* How to create maintainable, modular, and reusable PL/SQL program units
* The importance of testing as you go, and of building a permanent test plan for each module
* The importance of building debugging capabilities into your code and building a permanent debug facility for each module
* The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
* How to apply modular PL/SQL to solve real-world problems

Who is this book for?

Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.
About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." You'll start your journey by seeing what you need to know--but without needless theory and filler. You'll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there--it is your trusted guide through unfamiliar territory!
Related Titles

* Mastering Oracle SQL and SQL*Plus
* Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions




Download

Download




.

Start developing applications with Oracle PL/SQL-fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle 10G and all the fundamentals: Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions, packages and Oracle-supplied packages-plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates!

Totally integrated with a FREE, state-of-the-art Oracle 10G learning Web site! Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more:

"Test Your Thinking" project solutions and detailed explanations Additional self-review exercises with instant feedback and explanations An exclusive Virtual Study Lounge where you can interact with other students!

Just the facts! No endless, boring discussions here! You'll learn hands on, through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" projects guarantee you'll go beyond rote knowledge to really master the subject! It's an integrated learning system that's proven to work!


Download




.