Friday, June 5, 2009

Documenting Oracle Databases Complete Oracle database schema auditing

Authors:Mike Ault
Pages:102
Publisher:Unknow
ISBN13:9780974071664
Description:
Many times the Oracle DBA is hired once the database becomes to much to handle without one, inherits the position or is appointed to it “since they are so good with computers”. In any case, they usually get an undocumented system that follows no conventions and holds many traps for the unwary DBA.
In other situations the DBA may find they have the task of recreating the database for which they are responsible. If export and import can be used, this task is fairly easy to accomplish, however, sometimes the DBA will be required to provide DDL (Data Definition Language) for this purpose. The DBA may also wish to document existing procedures, views, constraints and such other structures as they see fit, with human readable output and a minimum of re-editing.
Download

Read more...

DB2 Universal Database v8 Handbook for Windows, UNIX, and Linux

Authors:Philip K. Gunning
Pages:496
Publisher:Unknow
ISBN13:9780130661111
Description:
Preface I wrote this book to provide you with the necessary knowledge with which to accomplish business objectives with DB2 UDB v8.1 for Windows, UNIX, and Linux. After all, as a developer or DBA, your primary mission is to accomplish business objectives by providing a database environment that provides the requisite performance, availability, and scalability required in today's demanding 24 7 highly competitive business environment. To that end, I have focused this book on key areas of DB2 UDB v8.1 that will enable you to meet those objectives. Some of the features covered are: the new Development Center, multidimensional clustering, online reorganization and online load, Type-2 indexes, tablespace enhancements, block-based bufferpools, tuning bufferpools, new commands and utility options, dynamic configuration parameters, autonomic computing features, write-to-table event monitors, SQL snapshot functions, QUIESCE command, and the database partitioning feature with new partitioning terminology updates. And, almost all new DB2 UDB v8.1 features and enhancements are covered in this book.
Download

Read more...

DB2 Universal Database V8 for Linux, UNIX, and Windows

Authors:George Baklarz, Bill Wong
Pages:912
Publisher:Unknow
ISBN13:9780130463883
Description:
Definitive preparation for Exam 704: DB2 UDB V8.1 Advanced Database Administration for Linux, UNIX, and Windows, which leads to an IBM Certified Advanced Database Administrator certification. Database design, performance monitoring and tuning, scaling for terabytes of data, high availability, enterprise-level security, and more. The appendices contain sample certification exam questions and answers. Whether you're a long-time DB2 UDB professional or an experienced DBA who's migrated from another database platform, there's one sure way to demonstrate the highest level of skills in DB2 Universal Database administration: pass the challenging IBM DB2 Universal Database Advanced Database Administration Exam 704.
Download

Read more...

DB2 Universal Database v8 Application Development

Authors:David Martineau, Steve Sanyal Kevin Gashyna Mich
Pages:432
Publisher:Unknow
ISBN13:9780130463913
Description:
You will find every skill and technique you need to build enterprise, Web, and eBusiness applications with DB2 UDB v8. This book is IBM's official guide to becoming an IBM Certified Application Developer for the DB2 Universal Database v8 Family.

New to the second edition is the inclusion of the information that you will need to prepare for the Fundamentals exam, a prerequisite to the Application Development exam. This section covers information about the DB2 products, tools, connectivity, data objects, manipulation, security, and concurrency.


Download

Read more...

Wednesday, June 3, 2009

Date on Database Writings 2000–2006

Authors:C. J. Date

Pages:568
Publisher:Apress
ISBN13:9781590597460
Description:
Date on Database: Writings 2000--2006 captures some of the freshest thinking from widely known and respected relational database pioneer C. J. Date. Known for his tenacious defense of relational theory in its purest form, Date tackles many topics that are important to database professionals, including the difference between model and implementation, data integrity, data redundancy, deviations in SQL from the relational model, and much more.

Read more...

Database Programming with JDBC and Java, Second Edition

Authors:George Reese
Pages:328
Publisher:O'Reilly
ISBN13:9781565926165
Description:
This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and includes a set of patterns that separate the functions of the Java application and facilitate the growth and maintenance of an application. Database Programming with JDBC and Java recently won a Reader's Choice Special Mention Award from Visual Basic Programmers Journal. It was the only winner in the category of Java publications.
Download

Read more...

Database Design Manual

Authors:Norman, Matthew
Pages:224
Publisher:Springer
ISBN13:9781852337162
Description:
MySQL is one of the most commonly used open source relational database management systems (RDBMS). Fully updated to include information on latest versions, this Springer book is becoming one of the most easily understandable texts on MySQL available. Norman does a good job . The text is liberally interspersed with examples of SQL . Windows users who need to set up MySQL will greatly appreciate this Database Design Manual book. The book is a thorough, yet easy to understand resource for beginners.

Read more...

Database Design for Smarties

Authors:Robert J. Muller

Pages:442
Publisher:Unknow
ISBN13:9781558605152
Description:
Whether building a relational, object-relational, or object-oriented database, database developers are increasingly relying on an object-oriented design approach as the best way to meet user needs and performance criteria. This book teaches you how to use the Unified Modeling Language-the official standard of the Object Management Group-to develop and implement the best possible design for your database.

Read more...

Database Design for Mere Mortals

Authors:Hernandez, Michael J.

Pages:611
Publisher:Addison Wesley
ISBN13:9780201752847
Description:
Topics covered: How to design databases that fit business requirements and make software construction easier. In addition to explaining relational database concepts, the author explains data integrity, null values, keys, table relationships (one-to-one, one-to-many, and many-to-many), and data types. He emphasizes processes designers should follow in building a new database or improving an existing one.

Read more...

Thursday, May 21, 2009

Creating your MySQL Database: Practical Design Tips and Techniques

Authors:Marc DeLisle
Pages:108
Publisher:Packt Publishing
ISBN13:9781904811305
Description:
This book is an innovative and essential short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily. If you're creating a dynamic web application using open-source tools, then you're probably going to be setting up a MySQL database. Getting the design of this database right for your application and its data is vital, but it's often an intimidating and little-known process for non-developers and developers alike. Written by the creator of the popular phpMyAdmin tool, this book is a short but complete guide on how to design good data structures for MySQL. For most of us, setting up the database for an application is often an afterthought. While you don't need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective.
Download

Read more...

Build Your Own Database-Driven Website Using PHP & MySQL

Authors:Peter Wright
Pages:207
Publisher:SitePoint
ISBN13:9780957921818
Description:

This book is a hands-on guide to learning all the tools, principles, and techniques needed to build a fully functional database-driven Web site using PHP and MySQL from scratch.

PHP & MySQL are the most widely used open source database and scripting technologies on the Web today. As a Web developer you can demand a lot more $$$ for your time if you can master PHP & MySQL.

Build Your Own Database Driven Website Using PHP & MySQL is a practical hands-on guide to learning all the tools, principles and techniques needed to build a fully functional database driven Website using PHP & MySQL.

This book covers everything from installing PHP & MySQL under Windows, Linux, and Mac through to building a live Web-based content management system. While this is essentially a beginners book, it also covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP.
Download

Read more...

Beginning Visual Basic 2005 Express Edition From Novice to Professional

Authors:Peter Wright
Pages:544
Publisher:Apress
ISBN13:9781590596227
Description:
Beginning Visual Basic 2005 Express Edition is the affordable, accessible route to learning the .NET programming languages. Author Peter Wright proved his ability to teach Visual Basic to over 100,000 aspiring programmers during the 1990s with his line of best-sellers. Now that Microsoft is launching its new Express products, Wright is repeating his mission to teach you how to program, providing a friendly, clear message along the way.

Wright helps you explore Visual Basic 2005 Express. You'll learn about core programming principles that will enable you to move towards more complex and rewarding programming tasks. This book guides you through every major aspect of Visual Basic 2005 Express, and guarantees that you'll learn how everything fits together--from the first programming principles to Express Start Kits that advance you in your own programming. By the end of the book, you'll be able to write your own programs.
Download

Read more...

ASP.NET Database Programming Weekend Crash Course

Authors:Jason Butler, Tony Caudill
Pages:409
Publisher:Unknow
ISBN13:9780764548307
Description:

Written by expert web developers from Price Waterhouse-Coopers, ASP.NET Database Programming Weekend Crash Course will quickly enable you to create dynamic data-driven web applications using Microsoft's exciting new .NET technologies.

Open the book on Friday evening and by Sunday afternoon -- after completing 30 fast, focused lessons -- you will have mastered the skills necessary to begin creating robust, dynamic, data-driven web applications with ASP.NET. Starting with ASP.NET basics, expert authors Jason and Tony teach you what they need to know to begin creating ASP.NET applications quickly, and then dive into building database applications with ADO.NET, Web Services, SOAP, XML and more. This book is a must have for any developer building web applications on Microsoft's new .NET Framework.

Download

Read more...

An Introduction to Programming Using Visual Basic 2005, Sixth Edition

Authors:David I. Schneider
Pages:752
Publisher:Prentice Hall PTR
ISBN-13:9780130306548
Description:
Based on the newest version of Microsoft's VB. NET, this revision of Schneider's best-selling text is designed for students with no prior computer programming experience. The author uses Visual Basic .NET to explore the fundamentals of programming, building a strong foundation that will give students a sustainable understanding of programming. A broad range of examples, case studies, exercises, and programming projects give students significant hands-on experience. A "tried and true" text, this book has been consistently praised by both students and instructors.
Download

Read more...

Tuesday, April 14, 2009

Advanced DBA Certification Guide and Reference for DB2

Authors:Dwaine R. Snow, Thomas Xuan Phan Dwaine Snow

Pages:600
Publisher:Unknow
ISBN-13:9780130463883
Description:
Definitive preparation for Exam 704: DB2 UDB V8.1 Advanced Database Administration for Linux, UNIX, and Windows, which leads to an IBM Certified Advanced Database Administrator certification. Database design, performance monitoring and tuning, scaling for terabytes of data, high availability, enterprise-level security, and more. The appendices contain sample certification exam questions and answers. Whether you're a long-time DB2 UDB professional or an experienced DBA who's migrated from another database platform, there's one sure way to demonstrate the highest level of skills in DB2 Universal Database administration: pass the challenging IBM DB2 Universal Database Advanced Database Administration Exam 704.

Read more...

Monday, April 13, 2009

Access Database Design and Programming, Second Edition

Authors:Steven Roman

Pages:429
Publisher:O'Reilly
ISBN-13:9781565926264
Description:
This second edition of the best-selling Access Database Design & Programming covers Access' new VBA Integrated Development Environment used by Word, Excel, and Powerpoint; the VBA language itself; Microsoft's latest data access technology, Active Data Objects (ADO); plus Open Database Connectivity (ODBC).

Read more...

Access Database Design and Programming, 3rd Edition

Authors:Roman, Steven

Pages:425
Publisher:O'Reilly
ISBN-13:9780596002732
Description:
Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively.

Read more...

Saturday, April 11, 2009

Visual Basic .Net Power Tools

Authors:Petroutsos, Evangelos Mansfield, Richard
Pages:800
Publisher:John Wiley & Sons Inc
ISBN-13:9780782142426
Description:

Step-by-Step Instruction on Complex Topics Leads You to the Expert Level

Do you scour VB.NET books seeking solutions for esoteric database programming, debugging, security, or printing challenges, but can't ever find them? Are you wrestling with VB.NET's newer topics, such as asynchronous programming, Web services, employing Office objects, using reflection, and the .NET Compact Framework? Could you use some assistance making the transition from VB6 to VB.NET? If so, peer inside.

Visual Basic .NET Power Tools is intended for professional programmers geared up to tackle the complex, cutting-edge, and sophisticated aspects of VB.NET. In this rare book, two world-renowned VB authors thoroughly describe a broad range of fascinating and important aspects of VB that aren't addressed elsewhere.


Download

Read more...

Visual Basic 2005: In a Nutshell, 3rd Edition

Authors:Lomax, Paul Petrusha, Ron Patrick, Tim (EDT) Roman
Pages:746
Publisher:O'Reilly
ISBN-13:9780596101527
Description:

When Microsoft made Visual Basic into an object-oriented programming language, millions of VB developers resisted the change to the .NET platform. Now, after integrating feedback from their customers and creating Visual Basic 2005, Microsoft finally has the right carrot. Visual Basic 2005 offers the power of the .NET platform, yet restores the speed and convenience of Visual Basic. Accordingly, we've revised the classic in a Nutshell guide to the Visual Basic language to cover the Visual Basic 2005 version and all of its new features.

Unlike other books on the subject, Visual Basic 2005 in a Nutshell, 3rd Edition doesn't assume you're a novice. It's a detailed, professional reference to the Visual Basic language-a reference that you can use to jog your memory about a particular language element or parameter. It'll also come in handy when you want to make sure that there isn't some "gotcha" you've overlooked with a particular language feature.

Download

Read more...

Security for Microsoft Visual Basic .NET

Authors:Ed Robinson and Michael James Bond
Pages:396
Publisher:Microsoft Press
ISBN-13:9780735619197
Description:
This is the first book every Visual Basic .NET programmer should read on security. This is an end-to-end guide, with clear prescriptive guidance for best practices, application design, and coding techniques for Windows and Web-based applications. This book makes writing secure applications easier than ever before. It features plain-language explanations of security terms illustrated with step-by-step code walk-throughs and sample files for both Visual Basic .NET 2002 and Visual Basic .NET 2003. Programmers will learn how to use encryption, role-based security, code access security, authentication, authorization along with techniques to help protect against common exploits. Also covered in this end-to-end guide are techniques for locking down Microsoft Windows, Internet Information Services and Microsoft SQL server. Readers will learn how to perform a security audit, how to test for security, how to design with security in mind, and security techniques for deploying Windows and Web-based applications.
Download

Read more...

Programming Microsoft Visual Basic 2005: The Language

Authors:Francesco Balena
Pages:1104
Publisher:Microsoft Press
ISBN-13:9780735621831
Description:
Get the expert insights, indispensable reference, and practical instruction needed to exploit the core language features and capabilities in Visual Basic 2005. Well-known Visual Basic programming author Francesco Balena expertly guides you through the fundamentals, including modules, keywords, and inheritance, and builds your mastery of more-advanced topics such as delegates, assemblies, and My Namespace. Combining in-depth reference with extensive, hands-on code examples and best-practices advice, this CORE REFERENCE delivers the key resources you need to develop professional-level programming skills for smart clients and the Web.
Download

Read more...

Microsoft Visual Basic 2005 Step by Step

Authors:Michael Halvorson
Pages:523
Publisher:Microsoft Press
ISBN-13:9780735621312
Description:
Visual Basic 2005 focuses on enabling developers to rapidly build applications, with enhancements across its visual designers, code editor, language, and debugger that help accelerate the development and deployment of robust, elegant applications across the Web, a business group, or an enterprise. Now you can teach yourself the essentials of working with Microsoft Visual Studio® 2005 and the new features of the Visual Basic language—one step at a time. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you're a beginning programmer or new to this specific language, you'll understand the core capabilities and fundamental techniques for Visual Basic 2005. Each chapter puts you to work, showing you how, when, and why to use specific features of Visual Basic and guiding as you create actual components and working applications for Microsoft Windows®. You'll also explore data management and Web-based development topics.
Download

Read more...

Windows Forms Programming in Visual Basic .NET

Authors:Chris Sells, Justin Gehtland
Pages:736
Publisher:Unknow
ISBN-13:9780321125194
Description:

"If you are just beginning to use WinForms, or even if you are already an experienced hand, you will find this book an antidote for confusion and a friendly companion on the road to writing modern applications."

—Alan Cooper, Father of Visual Basic

Windows Forms Programming in Visual Basic .NET is the ultimate guide to using the Microsoft .NET forms package. Readers will learn how to build applications that take full advantage of both the rich user interface features of the Microsoft Windows operating system and the deployment features traditionally associated with HTML-based applications.


Download

Read more...

Visual Basic 2005 Jumpstart

Authors:Wei-Meng Lee
Pages:197
Publisher:O'Reilly
ISBN-13:9780596100711
Description:

Okay, all you VB6 developers--time's up. As of March 2005, Microsoft no longer supports this version of Visual Basic. And you can't blame them. Three years ago, they introduced the .NET Framework--an elegant, powerful platform--along with the new component-based VB.NET language. But roughly five million of you decided to stick with VB6, mostly to maintain legacy Windows and COM projects.

Now, with the upcoming release of VB 2005, Microsoft has several attractive reasons to upgrade that you'll find hard to resist, including the return of some VB6 features. And we have the perfect book to help you make the conversion: Visual Basic 2005 Jumpstart. Now, you can test-drive the beta version of VB 2005 with three hands-on projects that enable you to learn the syntax of this new language quickly.
Download

Read more...

Visual Basic Shell Programming

Authors:J.P. Hamilton
Pages:392
Publisher:O'Reilly
ISBN-13:9781565926707
Description:
Visual Basic's outstanding set of resources for rapidly developing stand-alone applications doesn't include shell extensions for integrating those applications or their data files with the Windows shell. Typically, such extensions as customized context menu handlers, per instance icons (such as a data file icon that's based on the contents of the file), and customized property sheets are written in C++, and all of the available documentation focuses on using C++ for shell extensions. But even C++ programmers find the task rough going, given the woefully inadequate state of the documentation. Very few programmers know that writing shell extensions is not tied to a single language or development environment, and that Visual Basic is an excellent tool for creating shell extensions that more closely tie an application to the Windows shell. That, however, is precisely the focus of Visual Basic Shell Programming. It shows how to take advantage of shell services to develop shell extensions and it provides the basic documentation needed for accomplishing this. Each major type of shell extension gets attention,
Download

Read more...

BEGINNING VISUAL BASIC 2005

Authors:Thearon, Willis
Pages:799
Publisher:John Wiley & Sons Inc
ISBN-13:9780764574016
Description:

After a brief introduction to Visual Studio 2005 and the .Net Framework, the expert authors introduce readers to the fundamentals of the Visual Basic 2005 language

End-of-chapter exercises help readers to quickly learn to build rich and professional-looking applications for Microsoft Windows, intranets and the Internet, and mobile devices

Download

Read more...

Visual Basic 2005 Cookbook

Authors:Tim Patrick, John Craig
Pages:713
Publisher:O'Reilly
ISBN-13:9780596101770
Description:
This book will help you solve more than 300 of the most common and not-so-common tasks that working Visual Basic 2005 programmers face every day. If you're a seasoned .NET developer, beginning Visual Basic programmer, or a developer seeking a simple and clear migration path from VB6 to Visual Basic 2005, the Visual Basic 2005 Cookbook delivers a practical collection of problem-solving recipes for a broad range of Visual Basic programming tasks.
Download

Read more...

MySQL: Essential Skills

Authors:John W. Horn and Michael Grey
Pages:364
Publisher:Unknow
ISBN-13:9780072255133
Description:
An introductory look into the most popular open source database. Get step-by-step instruction from installing MySQL, manipulating it, and basic reporting, to advanced reporting, interfacing programs, and backups. An accessible introduction to a powerful database, featuring progress checks, exercises, and Ask the Experts sections in each chapter.
Download

Read more...

MySQL, Second Edition

Authors:Paul DuBois
Pages:1248
Publisher:Sams
ISBN-13:9780735712126
Description:
n the second edition of MySQL Paul DuBois provides an updated, comprehensive guide to one of the most popular relational database systems.

MySQL is the most popular open source database server in the world, with more than 2 million installations and customers including Yahoo!, MP3.com, Motorola, and NASA.

MySQL 4.0, now generally available, is a long-awaited update to the database management system that has many new features, including a new table definition file format, enhanced replication, and more functions for a full text search.

Instead of giving readers merely an overview of MySQL 4.0, DuBois continues to include the most sought-after answers to the questions he hears most often from the community.

Download

Read more...

MySQL and PHP from Scratch

Authors:Wade Maxfield
Pages:384
Publisher:Que
ISBN-13:9780789724403
Description:
Apache, MySQL, PHP3, and IMP the pieces exist. Each piece has been described ad nauseam. What does not exist is a guide to the marriage of these software technologies into a useful book, until now. This book puts together information on installing, setting up, and troubleshooting each of these technologies into one complete volume. You also learn how each piece is part of a whole by learning, step-by-step, how to create a web-based e-mail system. Learn to run the Linux equivalent of Active Server Pages (ASP) using PHP3, set up an e-commerce site using a database and the Apache web server, and create a data entry system (such as sales, product quality tracking, customer preferences, etc) that requires no installation in the PC.
Download

Read more...

MySQL Crash Course

Authors:Forta, Ben
Pages:320
Publisher:Unknow
ISBN-13:9780672327124
Description:
If you are a MySQL user who wants to find out more about the program, but is not interested in becoming a database administrator just to be able to read books on MySQL, then MySQL Crash Course is for you. This tutorial-based book is organized into a series of short, easy-to-follow lessons that take a very hands-on approach to meeting the needs of the average MySQL user. The essentials of MySQL are taught through a series of self-paced lessons in which you will complete exercises that illustrate the most important aspects of MySQL.
Download

Read more...

Practical C Programming, 3rd Edition

Authors:Steve Oualline
Pages:428
Publisher:O'Reilly
ISBN-13:9781565923065
Description:
There are lots of introductory C books, but this is the first one that has the no-nonsense, practical approach that has made Nutshell Handbooks(R) famous. C programming is more than just getting the syntax right. Style and debugging also play a tremendous part in creating programs that run well and are easy to maintain. This book teaches you not only the mechanics of programming, but also describes how to create programs that are easy to read, debug, and update. Practical rules are stressed. For example, there are fifteen precedence rules in C (comes before).
Download

Read more...

MySQL Pocket Reference

Authors:George Reese
Pages:96
Publisher:
O'Reilly
ISBN-13:9780596004460
Description:

If you use MySQL, you know why it's the world's most popular open source database: small, fast, and powerful, and so rich in features that no administrator or programmer can stay familiar with all of them.

There are always some little-known commands and clauses that could help you become more efficient in your work if you could just keep them in mind. The problem is, you don't always have time to stop and thumb through an exhaustive reference when you're hard at work. If you need a quick reminder, the MySQL Pocket Reference can lead you straight to the answer you need to know to get the job done.


Download

Read more...

Mastering MySQL 4

Authors:Ian Gilfillan
Pages:729
Publisher:Sybex
ISBN-13:9780782141627
Description:
MySQL has proved it can compete with the big names in database management, such as SQL Server and Oracle, and with MySQL 4 this is truer than ever. Mastering MySQL 4 is your one-stop resource for all the information you need to create, maintain, use, and extend a MySQL database. It's also essential reading for anyone developing database applications in a MySQL environment. If you're new to MySQL, this is a great way to get up and running--fast. If you're upgrading, it will help you get all you can out of new features and support.
Download

Read more...