Creating Database Web Applications with PHP and ASP (Internet Series)

Book Description

If you want to add more power and functionality to your Web sites, add some database applications like a powerful shopping cart or a fun quiz game. Such applications make your site more dynamic, allow you to gather information, and provide customized experiences for your visitors. Creating Database Web Applications with PHP and ASP teaches beginning and intermediate designers the fundamentals of creating complex Web applications. By covering both open source (PHP/MySQL) and proprietary tools (Microsoft ASP and Access), readers gain insight to the strengths and weaknesses of each. In addition, they learn how to work with both sets of tools and determine which works best for their projects. Practical examples, including a shopping cart and quiz show, are used to teach the basic concepts behind creating and testing database code. Every example is also provided in both PHP and ASP for easy comparison and use. With the knowledge and experience gained here, beginners will learn the fundamental concepts behind these two technologies, while more experienced developers will learn which technology works best for their specific needs. Exercises, questions, and projects are included with each chapter.

Customer Reviews:

VERY HELPFUL.......2004-02-16

Jeanine,

Just wanted to let you know how helpful your book is. Before I thought, it was impractical to have two scripting languages and two databases. I said this because from my experience I started learning database from Access then learn Visual Basic Codes and Scripts. Originally, my field of profession is Financial Accounting. In the early 90's I learn Lotus then migrated to Excel spreadsheet programs. I was not satisfied for what Macros can do so I studied Access database. I was so amazed by it but there are things I know and hope will be easier and faster. I wanted to learn SQL knowing how powerful it is, but because how expensive commerialize DBMS softwares were it made me stick with Access. The internet period has arrived at that time, so I learned ASP with Visual Basic Scripting. I was not totally satisfied with it because VBScript is always tied up to a giant corporation and at the time I was learning HTML, XML &
JavaScript. This made me confuse, what direction am I going. I decided to continue what I learned so far, apply it then to whatever will make it easier. So, I studied ASP with JavaScript Langauge. Consequently, from learning and experience, I read about MySQL and PHP and studied it as well. So far your book is the best and most helpful, in showing how to connect to a server and for sure will SAVE me and my clients alot. Currently, I am a financial administrator and partly the intranet designer of a
University in San Francisco. My goal is to have my own server
company.

Thank you again and more power to you.

John

Very helpful.......2004-02-16

Jeanine,

Just wanted to let you know how helpful your book is. Before I thought, it was impractical to have two scripting languages and two databases. I said this because from my experience I started learning database from Access then learn Visual Basic Codes and Scripts. Originally, my field of profession is Financial Accounting. In the early 1990's I learn Lotus then migrated to Excel spreadsheet programs. I was not satisfied for what macros can do so I studied Access database. I was so amazed by it but there are things I know and hope will make things easier and faster. I wanted to learn SQL knowing how powerful it is, but how expensive commerialize DBMS softwares were it made me stick with Access. The internet period has arrived at that time, so I learned ASP with Visual Basic Scripting. I was still not comfortable & not happy with it because VBScript is always tied up with a giant corporation and at the time I was learning HTML, XML & JavaScript.

This made me confuse what direction am I going but continue what I learned so far, apply it then and whatever will make it easier. So, I studied ASP with JavaScript langauge. Consequently, from learning and experience, I read about MySQL and PHP and studied it as well. So far your book is the best and most helpful, in showing how to connect to a server and for sure will SAVE me and my clients alot. Currently, I am a financial administrator and partly the intranet designer of a university in San Francisco. My goal is to be a free lance web designer and to own a Web design company using MySQL (OPEN SOURCE database), PHP (OPEN SOURCE scripting language), Access database, and Active Server Pages (ASP).

Thank you again and more power to you.

John

Not perfect, but a perfect mix!.......2004-02-16

I'm a seasoned (some would say salty) web developer, and I have been teaching web applications for two years both online and "on the ground." I've looked in vain for the right mixture of theory, practical application and humor (a needed ingredient for this type of instruction). I use this book for intermediate web developer students who have a solid grounding in HTML, CSS and Javascript, and some basic knowledge of either PHP or ASP (or other programming logic). I used to use Wrox's Beginning ASP, but at more than 1000 pages, and more errata than I could cover in a single class, I continued looking. With this book, I think I've found the right text for some of the classes I teach!

Dr. Meyer's work starts with a review of HTML and Javascript, with an emphasis on how to use the DOM in an application setting. Regarding databases, there are chapters explaining application concepts and E-R diagrams, as well as how to use the CLI client for MySQL. The CD-ROM even has SQL instructions for importing the material from the text; and for Access users, db files that mirror the work in the text.

But the real heart of the matter is the instruction in coding practices, from reading and writing to databases (using MySQL and DSN-less Access connections), to using cookies and session variables for data persistance. And this is where this book has no equal: it supports both the hugely popular open-source PHP/MySQL as equally as it shows ASP and Access. I've never seen such a universal attempt pulled off quite as well.

I recommend the book, but no work is perfect. I don't think that a book can equal the combination of education and experience (but as an instructor, I may be biased). The PHP code supplied in the accompanying CD-ROM utilizes global variables (which may be turned off in some production environments for security purposes)--but that underscores the use of the text as a textbook, and not a coding "cookbook" with samples that are "ready-to-eat." Also, the ASP uses the less-common, but more palatable ASP JavaScript (or JScript) instead of the more commonly utilized ASP VBScript (but even third-party ASP interpreters like that used in the SunOne Server handled the code).

I found that students should adapt and improve the code from the CD-ROM as part of their studies, so that they could fix some typos, and learn how code integration works. Also, they needed to create interfaces for the samples so we could stop staring at web forms and add some color to the examples! Students have created portfolio pieces using the concepts in this text like psychological profile tests, e-commerce sites, calendar applications and marketing surveys.

Terrific, concise book on learning atabase Web applications.......2004-02-16

I am very new to computing, having just learned the basics of HTML. I found this book very helpful. First of all, it does start out with basic HTML which was reassuring for me. It then adds JavaScript. It builds up gradually, with many examples in the text. There is also a complete set of code on the CD. The PHP with MySql and the ASP with Access are always compared with general previews. The book has many screen shots.

The book also has some examples of what the screen would look like if you did something wrong which beginners tend to do. I have not seen this pedagogical technique in other texts. I found it very helpful. The chapters on database design and SQL were also very good. I strongly recommend this book. It is an excellent book for anyone new to Web applications or someone with some experience, who wants to know more. In particular, if someone knows one of the technologies featured (PHP, ASP, MySql, Access, SQL) and wants to know how this one technology relates to others, this is a good source. The examples of the book are well-chosen, without any extraneous material, and are explained in a table, with code in one column and explanation in another. I liked the fact that that it is clear and concise since I like most people don't have a lot of time to expend on a lot of unnecessary verbiage.

This book is very hard to follow........2004-01-09

I have created a couple of websites and know HTML pretty well. This book assumes you know ASP inside and out, and if you don't, this is not the right book for you. Even if you do, the book does not explain enough for you to actually create a database. I would recommend the Active Server Pages 3.0 book published by Wrox. I haven't tried their ASP.Net 1.0, but they are good about explaining everything to Newbies and being detailed orientated for programmers with more skill and knowledge. The Active Server Pages 3.0 book has three chapters dedicated to getting your database up and running, in addition to having a sample application that can be run on your own web server using windows 2000.

Access Database Design & Programming (3rd Edition)

Average customer rating:

Just What I Needed
this book got me started on databases...
If you own 2 Access books, this should be one of them
Note to Shannon - DAO is not a problem.
I'M A COLDFUSION GUY...KEEP THAT IN MIND:

Access Database Design & Programming (3rd Edition)
Steven Roman
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback

Database Design | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

Databases | Microsoft | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

Modeling & Simulation | Computer Science | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

ASIN: 0596002734

Amazon.com

Access Database Design and Programming covers a lot of ground quickly but lucidly. Steven Roman begins with a description of general principles of database design, then describes the "relational algebra" that defines the meaning of such operations as unions and joins, introduces SQL syntax, and finally dives into the details of using VBA (Visual Basic for Applications) to write Access code. The result is a single book that can teach you all the basics of building database applications in Access. Portions of the book are heavy with logical equations whose effects can be hard to visualize, but Roman's judicious use of sample data makes it much easier to follow the operations being described.

Book 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. In particular, this book focuses on three areas:

Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data.
Queries. The book examines multi-table queries (i.e.,various types of joins) and shows how to implement them indirectly by using the Access interface or directly by using Access SQL.
Programming. The book examines the VBA integrated development environment (IDE). It then goes on to provide an excellent introduction to Data Access Objects (DAO), ActiveX Data Objects (ADO), and ADO Extensions for Data Definition and Security (ADOX). These sections serve as a handy introduction and primer for basic database operations,such as modifying a table under program control, dynamically adding and deleting a record, and repositioning a record pointer. The concluding chapter focuses on common programming problems, such as computing running sums and comparing two sets.

Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, Access Database Design &Programming instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This book also serves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to develop successfully in the Microsoft Access environment. Anyone interested in learning Access in depth, rather than just scraping the surface, will enjoy and benefit immensely from reading this book.

Customer Reviews:

Just What I Needed.......2006-02-02

In seeking out materials to train myself on Access 2003, I have found several books that have done adequate or good jobs of teaching the program. Most of them, however, did not do so well on teaching database theory or on instructing in how to use the native programming environment. This book helped to fill in the gaps. It is not perfect but it certainly was a good place to start.

The treatment of database theory is just that. It is a treatment of theory. It explains the concepts in a semi-rigorous manner which is dry but still informative. The notation is sometimes a trial to follow but that is the nature of the beast. When things are put in terms of equations, they just do not read as interestingly as a prose novel. Although this information is presented with Access in mind, it would be applicable to anyone who wants to learn about databases.

The treatment of the programming elements is no less dry but it too is informative. Again, reading lines of code does not strike me as an exciting way to pass the afternoon but it got the job done. The examples are as clear as the syntax allows and make the points well.

I should point out that I did not actually try the code presented in this book. I read the examples to learn the concepts. I cannot testify as to how well the code worked in a "real" environment.

While I will certainly be looking for other references and learning materials, this was a good choice for my first foray past just learning the basics of the application itself.

this book got me started on databases..........2005-11-17

Years ago, I've picked this book up to learn Access... I haven't used Access for quite a while now (mostly an Oracle person now), but I still have fond memories of this book. Not only does this book teach you Access, and it does that very well, it also go through the database fundamentals. An overall great book, imho.

If you own 2 Access books, this should be one of them.......2005-06-07

I first read Steven Roman's book on Access a few years ago when it was written for Access 97. I recently bought a copy of the current version as a reference.

What I liked about Steven's books was that he took seriously his coverage of normalization, which is rare amongst books on Access. If you're new to database programming, you need to learn the basics of normalization. In my experiences, I've come across a lot of databases designed by beginners that exhibit a "spreadsheet" type of understanding towards Access tables. The beauty of the relational model is that once you have your database set up, ongoing maintenance is minimal. If you learn how to program Access, but don't learn the basics of normalization and the relational model, you may as well just keep your data in Excel spreadsheets.

My complaint with this book is his coverage of ADO. The author clearly prefers DAO for MS Access, and he states as much, and his coverage suffers. He covers the material, but he makes using ADO appear to be very difficult. In an entire chapter on ADO, he fails to show the user the most basic thing: how to generate a recordset for a table in your Access database. Instead, he shows you how to use ADO to query other databases, such as SQL Server and even Excel, but not the Access Database that you're currently using.

In DAO one of the fundamental details that you need to know about is the CurrentDB object. Steven gets a gold star, because he not only covers the CurrentDB object, but he spends 6 pages on it. In ADO, an object that is used for a somewhat similar purpose is the CurrentProject object. You won't find coverage on it anywhere in this book - just check the index. Perhaps the author's surreptitious goal of the chapter is to frustrate you so much with ADO that you will return to DAO, his preferred choice. Tsk, tsk Steven.

After reading the books section on ADO over and over again, I cannot recommend this book if you plan on owning only one Access book. Instead, I would recommend Alison Balter's Mastering Access Databases. It is the best Access book on the market(as most Amazon reviewers will attest to) and covers nearly ever topic that you'd want to know about Access.

Even so, Steven's book covers normalization so much better than the other Access books out there that I would advise serious Access programmers to buy two books: Alison's and Steven's.

Note to Shannon - DAO is not a problem........2005-05-18

I haven't read this book, yet. But, reviewer, Shannon, complained about not being able to get it to work with DAO. The problem is in References. Her database is probably set with a reference only to ADODB.

In Module View, just select Tools | Reference and select DAO (Data Access Objects) as the reference. Then, you should be fine.

I'M A COLDFUSION GUY...KEEP THAT IN MIND:.......2004-11-12

For a ColdFusion developer, to graph where your interests would probably be, it would look like an inverted bell curve: the beginning is splendid, the middle just wouldn't apply, and the end is worth coming back for.

The beginning of the book talks about stuff that we need to make sure we get down well, regardless of our database platform: Access, SQL Server, Oracle, Sybase - doesn't matter. The first couple of chapters
talk about stuff that is universally applicable, and under-appreciated:
* Normalization of tables, including first, second, and third normal form. As most experienced database designers know, you may not be able to glance at a database and know second from third, but you
should take the time to learn the principles of normalization.
* Referential integrity between parent and child tables
* Relationship types: one-to-one, one-to-many, and many-to-many
* Join types: inner and outer

Up to about page 120, ColdFusion developers are all clear. About there, Chapter 7 gets into Access VBA specific problems about accessing and manipulating data, creating DAO connections, and how to
programmatically manipulate data using VBA. This is interesting stuff in and of itself, but probably not to a ColdFusion developer.

Picking up in Chapter 19, "Some Common Data Manipulation Problems," the party starts again, talking about complex select queries and joins.

From an Access standpoint, this book is chock full of goodies. From the point of view of a ColdFusion developer, I would say this much: if forced to choose between this book and the previous, the Cookbook, I would probably go Cookbook. But, as I mentioned in the previous review, if you work with both Access on the desktop and on the web, using ColdFusion, both of these are good, useful, handy references. Having a greater appreciation of what goes on behind the scenes in Access may help gain a greater appreciation for the larger picture.

Data Access Patterns: Database Interactions in Object-Oriented Applications

Average customer rating:

There is better one
Useful patterns and interesting concepts
Great book on persistence theory
Good design pattern book in data access !!
Excellent and Easy To Read

Data Access Patterns: Database Interactions in Object-Oriented Applications
Clifton Nock
Manufacturer: Addison-Wesley Professional
ProductGroup: Book
Binding: Hardcover

Object Databases | Databases | Computers & Internet | Subjects | Books

Database Design | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

Modeling & Simulation | Computer Science | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

ASIN: 0131401572

Customer Reviews:

There is better one.......2006-12-14

Try Martin Fowler's Patterns of Enterpise Application Architecture.
It has much better coverage in more useful context.
Also you can look at Hibernate or iBatis project for real application
of these patterns.

Useful patterns and interesting concepts.......2004-12-11

The book presented 25 patterns grouped in 5 areas, decoupling (conceptual and architectural level), resource, input/output, cache and concurrency.

The most interesting patterns are in resource and cache. Decoupling and concurrency patterns (e.g., data accessor, active domain object, layers, transactions, optimistic/pessimistic lock etc.) are well known and the contents are a bit too light to be very useful, yet the concepts are giving readers some directions.

In resource patterns, some interesting patterns are presented, particularly resource timer automatically releases inactive resource, retryer enables fault-tolerance for data access operations.

In cache patterns, cache collector purges entries whose presence in the cache no longer provides any performance benefits; cache replicator replicates operations across multiple caches.

There are some areas to be improved, first, author should consolidate pattern names with other pattern authors, e.g., data accessor is also known as data access object, active domain object is similar to active record, paging iterator is close to value list handler (though value list handler is more decoupled from underlying data store), the point is, one of the important benefits and purposes for documenting patterns is to build common vocabularies among designers, using different names for same or similar patterns is defeating this purpose. The same pattern name should be used and may be presented as a variation of the original pattern.

Secondly, the examples given in the book is a bit too simple, sometimes, the examples might not justify or validate the interface abstraction is generic enough to handle real world problems, so some tweaking and modification to the pattern would be expected.

Overall, the book is well organized, and contents are easy to follow, most patterns come with class diagrams and sequence diagrams. Good for designers who want to decouple data access from rest of the application, utilize cache to minimize data access and thus boost application performance, manage resources in an efficient and leaking-proof way.

Great book on persistence theory.......2004-05-11

I'm in the middle of developing yet another persistence framework for a client, having done it a couple of times before. Each time I refine my ideas about how to do it. I must say that this book has a thorough examination of issues and certainly food for thought as well as answers to a couple of questions I've had.

However, I wouldn't say it's a complete design (which it doesn't claim to be). I still found myself picking and choosing which patterns to use as is, which to modify to my liking, and which to discard.

Also, I was left with the impression that the book didn't give enough coverage to handling collections of objects. The material is mostly geared toward working with a single object, which is understandable. I just think it would have been helpful to have more discussion about handling collections. For example, what should happen when you request to load an object, but the criteria you passed to the loading mechanism results in data for more than one object being retrieved from the database? Hand back the first object? Raise an exception? If it's covered in the book, I missed it.

Further, I would like to see more discussion about WHEN to refresh an object from the underlying database and when to save to the database. I always struggle with that timing issue. Having studied EJB, I like how entity beans keep your bean in synch with the underlying database. But the EJB container intercepts calls and makes those things happen. When coding the persistence layer myself, that's not an option. So, again, this is something I'd like to see some light shed on.

Overall, though, a great book if you're interested in reading up on persistence layer patterns.

Good design pattern book in data access !!.......2004-02-29

I am in the process of writing a thesis proposal that utilizing JDBC and TableModeler to access various database platforms as a prototype.

While prototyping the model, I encountered a lot of consideration of what is the best approach for certain implementation (mainly on JDBC). While looking into a few of designing books, I found this Data Access Patterns book that fits into my research needs. I have read other book such as Designing Flexible Object Oriented System with UML and not able to apply the concept or see solution in it. It is simply a conceptual book. No practical examples at all.

Mr. Nock has explained the design patterns very clearly in each chapter by using JDBC as a media. The examples are very easy to understand as compared to Design Patterns Explained. I am not able to understand codes that implementing graphics in that book.

Mr. Nock addressed the pros and cons of the patterns. Many techie books do not even bother to talk about pros and cons.

The author has chosen the right title for the book, I realized that many times author received a poor rating because reader expect different contents based on the title of the book.

The feature I liked the most - the ¡§Applicability¡¨ section on each chapter. Unlike other patterns book, the author explains the concept and gives example of "what" and "when" to use certain design pattern. This section is pretty much the answer for my thesis obstacles. The answer is in this book!!

Minor typos do exist such as in page 390 roll back instead of rollback.

In concurrency chapter, author may have mis-used the term of updates locking. It should be Lost Updates instead of Missing updates. Concurrency chapter looks like UDB Lock Concurrency architecture.

Additional note - would like to see the quality aspect in each of the patterns.

Overall, the book is very well structured, explained and thoughtful.

Thank you Mr. Nock !! This is a perfect book for my thesis.

Looking forward to read your future publish.

Regards,

Excellent and Easy To Read.......2004-02-20

I have to disagree with the previous review. I will try to explain why I think 'b88zhou' review is inadequate after presenting my overview of this book.

After reading numerous pattern books, it is nice to see a pattern book with very good organization.

Each pattern is presented with the following subsections.

* Description
* Context
* Applicability
* Structure
* Iteractions
* Consequences
* Strategies
* Sample Code
* Related Patterns and Technology.

I specifically like 'Consequence' section because it outlines the 'bad' consequence of adopting the patter. This goes with the mantra of design patterns - there is no one good pattern. You trade off one design for another depending on the context of your domain.

Also each pattern is accompanied by UML class diagrams and UML sequence diagrams - this is a big plus in understanding pattern.

The sample code is written in Java/JDBC so you may need to understand Java but I believe this pattern is still relevant to ADO.NET and C++. [ ADO.Net does offer connected and disconnected database operation so some patterns may not be relevant - plus, event/delegate will aid in some patterns.]

Specific to what the previous reviewer say - here are my rebuttals.

>> Why do you want to make queries and database updates into factories? Looking at the sample code, does it really help decoupling?

The previous reviewer mentioned as 'factories' is the derivation of 'AbstractFactory'. If you do not understand why AbstractFactory aids in decoupling from the concrete implementation, I think you should re-read GoF book. The author uses AbstractFactory pattern extensively in context of "Input and Output Parameter" and "Cache Patterns". I do admit that sometimes "Input and Output Parameter patterns" may not need to use AbstractFactory but if you read 'Domain Assembler' pattern you will understand why. From Domain Assembler, you can see the benefit of having AbstractFactories for Selection, Domain Object, and Update -- assembling all these factories via interface not concrete implmentation - a basic idea of design to interface instead concrete implementation.

>> The "Cache Patterns" does not solve the problem of preventing stale entry or even attempt to describe how to invalidate cache entry, so no matter how efficient you get, the cache is not guaranteed to be up-to-date /correct.

Please re-read 'Cache Collector'. The pattern could have different name like 'Cache Garbage Collector'. He talks about how you can 'purge' old data. Also re-read 'Cache Replicator' for how to sync the cached data in distributed system.

>> I'm surprised "stored procedure" is not mentioned at all.

I guess you have not done too many DB oriented projects. The stored procedure is evil and add little value to OO programming. But if you want the stored procedure, just replace 'SELECT' or 'UPDATE' statements to whatever stored procedures you want to call. So I don't think you can add much with SP.

>> mature object/relational frameworks like EOF (Apple WebObjects) or TopLink

This book is not about Java Data Object or OR mapping. Object-Relational mapping tool is another beast.

Book Description

Getting data across platforms and formats is a cornerstone of present-day applications development. ADO: ActiveX Data Objects is both an introduction and a complete reference to ADO (ActiveX Data Objects), Microsoft's universal data access solution. You'll learn how to easily access data in multiple formats--such as email messages, Access databases, Word documents, and SQL databases--even on different platforms, without spending extra time learning every last detail about each format. Author Jason Roff shows by example how to use ADO with your programming language of choice to save programming time, so you can concentrate on the content and quality of your application rather than the nitty-gritty of specific data formats. ADO: ActiveX Data Objects includes:

Chapters dedicated to the Connection, Recordset, Field, and Command objects and the Properties collection
A complete, detailed reference listing every ADO object, method, property, and event, in convenient alphabetical order
Chapters on ADO architecture, data shaping, the ADO Event Model
An appendix containing enumeration tables used by ADO objects and collections, listed alphabetically
Brief introductions to RDS, ADO.NET, and SQL

ADO: ActiveX Data Objects is a versatile one-stop guide to both the theory and practice of programming with ADO through Version 2.6. The thorough reference section and topic-specific chapters will help you find quick answers about the details of objects, collections, methods, and properties of ADO. And the abundance of practical code examples will give you a good grasp of how to use ADO's strong points most effectively.

Customer Reviews:

My favorite ADO book.......2006-12-08

I have also read Programming ADO from David Sceppa and I prefer this one because it contains a lot examples with source code. My only complain is that there is only a small C++ program and the rest are all in Visual Basic. However, this is not a big issue as it is very easy to port the samples in C++.

A perfect book for ADO.......2004-02-28

this is a very good book, comparing to MSDN ADO note on the web, which covers only access to .mdb database, this book covers a variety of methods and databases. Thank for the great contribution.

Visual Basic ADO Book.......2002-09-24

This is a well written book for existing programmers who want to learn ADO. While the examples are in Visual Basic, the core concepts of ADO are very detailed and anyone with an understanding of a similar language, such as ASP or C++ should have no trouble applying the examples to the other language. It will not help you if you don't already know how to program.

It also serves as a good reference book.

Its all here........2002-08-12

You can't get a more complete ADO book.. ever gritty detail is in this book.. It's almost too much information. :- ) if you code ADO. This is a good book to have.

Cheers

Wayne lambright

GREAT - Data Shaping Chapter.......2001-09-20

I bought this book for one chapter - data shaping, and it turned out to be the only place that I found that was able to explain it in a way that I could understand. The author has a knack for thoroughly explaining the material. I also found the appendix on SQL helpful.

MCITP Developer: Microsoft SQL Server 2005 Data Access Design and Optimization Study Guide: Exam 70-442

Average customer rating:

MCITP Developer: Microsoft SQL Server 2005 Data Access Design and Optimization Study Guide: Exam 70-442
Marilyn Miller-White , and Cristian Andrei Lefter
Manufacturer: Sybex
ProductGroup: Book
Binding: Paperback

MS SQL Server | Certification Central | Computers & Internet | Subjects | Books

Office | Certification Central | Computers & Internet | Subjects | Books

General | Certification Central | Computers & Internet | Subjects | Books

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

ASIN: 0470108800

Book Description

As your essential guide to Microsoft’s new SQL Server 2005 certification (exam 70-442), this book offers you practical and in-depth coverage. Full coverage of all exam objectives is presented in a systematic approach so you can be confident you’re getting the instruction you need for the exam. Plus, practical hands-on exercises reinforce critical skills and real-world scenarios put what you’ve learned in the context of actual job roles. Finally, challenging review questions in each chapter prepare you for exam day.

Serious ADO: Universal Data Access with Visual Basic

Average customer rating:

Outstanding Book on ADO,
Nothing better and that is a fact
Give It Time and It Will Pay Off
Excellent for the Experienced VB Database Developer!
Good ADO Book for Visual Basic 6.0

Serious ADO: Universal Data Access with Visual Basic
Robert MacDonald
Manufacturer: Apress
ProductGroup: Book
Binding: Paperback

Database Design | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

Databases | Software | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

Accessories:

ASIN: 1893115194

Book Description

From seasoned developer and trainer Rob Macdonald comes Serious ADO: Universal Data Access with Visual Basic, which teaches experienced Visual Basic developers how to make the most of ADO, Microsoft's flagship product for database access. Serious ADO covers the full range of uses for ADO, from basic use of the ADO technology to specialized topics and advanced techniques that will benefit even the most experienced developers.

The first part of the book provides thorough coverage of ADO's components and what they can do. Along the way, Macdonald offers real-world code examples along with complete explanations of exactly what is occurring at each stage of the development process. This part also covers some of the key concepts upon which ADO programming is based, such as locking and transactions, connection pooling, marshalling, and Inter Process Communication, among others.

The second part of the book addresses the use of ADO in real-world development scenarios. Here, Macdonald demonstrates advanced user interface creation, including new ways to control the binding process. You'll also learn how to use Microsoft Transaction Server of COM+ applications to create transactional component-based systems.

Download Description

ADO is Microsoft's data access technology for application developers and Visual Basic is the programming language now at the heart of many application and Web servers. In this new book, Rob Macdonald offers developers comprehensive coverage of both ADO and VB and practical development wisdom to increase productivity. After examining ADO and key concepts in ADO programming, the author tackles use of ADO in real world development situations including Internet and data mining scenarios. Macdonald also covers the use of Microsoft Transaction Server (MTS) and COM+ to create transactional component based systems, and how to use ADO to write components that really benefit from MTS and COM+. - Helps developers gain firm control of Microsoft's premier data access technology with comprehensive explanations and real code examples - Provides detailed treatment of important topics including client cursors, disconnected Recordsets, Data Shaping, Recordset persistence and marshalling, and MTS/COM+ - Accompanying CD-ROM contains VB programs to compliment each chapter.

Customer Reviews:

Outstanding Book on ADO,.......2007-05-08

with one flaw - the index is consistently off by a page or three. (a corrected index is available at apress.com)

And, there is one caveat - this is NOT a book for the VB/database beginner. If you're just starting VB6 database programming, I would recommend Freeze's "Visual Basic 6 Database Programming Bible," instead.

If you can live with the fact that you need to subtract a couple of pages from the page number in the index, then this book provides outstanding technical coverage of ADO. Now, it appears that Rob used ADO v2.5 for the code used in the book, and there have been some improvements to ADO (it is now at v2.8) which make a few of the timing comparisons, within ado now a bit obsolete. (some recordset operations are now more efficient than they were with v2.5, for instance,) but it this book is still my first, and usually only reference that I need to pull off the bookshelf.

Nothing better and that is a fact.......2005-07-20

I have gone through this book time after time and there is no better ADO book. It covers it all.

Give It Time and It Will Pay Off.......2005-03-10

I attribute this book with solidifying my ADO skills.

It covers the standard topics I have found in other ADO texts as well as an introduction to more advanced concepts with a functional level of depth. So the information is not too cursory, nor too detailed.

There is a good introduction to connecting to and using data warehouses. The coverage of hierarchical recordsets was also good. The coverage of the basics (connection, recordset, command, et. al.) pivoted around the 'devil is in the details' type of information, which, with ADO, is appropriate.

Of all the ADO books I have read, I most highly recommend this one. It is not well suited for the absolute beginner (i.e., you don't know what a recordset is) or high-level expert, but it should be suited for anyone in between. It took me a while to get into this book, but I feel it paid off.

Excellent for the Experienced VB Database Developer!.......2002-10-17

"Serious ADO" is written by Rob Macdonald, an independent software expert specializing in enterprise system design using Windows, COM(+), ADO, and MTS. The book is based on the authors real world database development experience. It is designed for intermediate to advanced Visual Basic developers. The book teaches how to use ADO to build component-based systems and web applications as well as traditional client server systems.

The first part of the book is titled "ADO In Depth". It provides detailed coverage of ADO's components and how they work. Real world code examples are provided for better understanding of all concepts. Oracle and SQL Server are covered, including the major non-traditional data sources. Key concepts such as locking, transactions, connection pooling, and marshalling are covered.

Part two is titled "ADO at Large". It explains how ADO is used in real world scenarios. Topics include advanced user interface creation, binding processes, Data Environment, and Microsoft Transaction Server. It shows how to use ADO to build components that benefit from MTS and COM+.

If you are an intermediate to experienced Visual Basic database developer, then this book is a must.

Good ADO Book for Visual Basic 6.0.......2002-10-17

This is a good book that explains the intimate details of ADO but the format of book leaves a little to be desired. On most pages the 3/4 of the page has the text and the left 1/4 of each page is blank or contains subheadings. There is no clear-cut separation between 1 subject and the next. While reading this book, if you do not pay close attention, the subject will change. The author clearly knows ADO and how to apply it to Visual Basic 6.0 but it appears that he repeats the text in several parts of the book especially in chapter 3 - RecordSets with SQL Data Sources. Maybe it was my imagination but several times I had a sense of Deju-Vu. Didn't I read about this earlier in the book? Chapter 4, 5, and 7 (Explicit Connections, Explicit Commands, and Disconnected RecordSets) are very good and you will want to read these chapters religously. Installation of the files on the CD caused some problems on my PC, which has Windows XP Home Edition. If you like Shakespeare, you'll like the examples in this book. Beware the Index is not in synchronization with the actual page numbers.

Data and Applications Security XIX: 19th Annual IFIP WG 11.3 Working Conference on Data and Applications Security, Storrs, CT, USA, August 7-10, 2005, Proceedings (Lecture Notes in Computer Science)

Average customer rating:

Data and Applications Security XIX: 19th Annual IFIP WG 11.3 Working Conference on Data and Applications Security, Storrs, CT, USA, August 7-10, 2005, Proceedings (Lecture Notes in Computer Science)

Manufacturer: Springer
ProductGroup: Book
Binding: Paperback

Database Design | Databases | Computers & Internet | Subjects | Books

Systems Analysis & Design | Computer Science | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

Risks | Technology | Science | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

All Amazon Upgrade | Amazon Upgrade | Stores | Books

Computers & Internet | Amazon Upgrade | Stores | Books

Science | Amazon Upgrade | Stores | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books

Science | Qualifying Textbooks - Fall 2007 | Stores | Books
ASIN: 354028138X

Book Description

This book constitutes the refereed proceedings of the 19th Annual Working Conference on Data and Applications Security held in Storrs, CT, USA, in August 2005.

The 24 revised full papers presented together with an invited lecture were thoroughly reviewed and selected from 54 submissions. The papers present theory, technique, applications, and practical experience of data and application security with topics like cryptography, privacy, security planning and administration, secure information integration, secure semantic Web technologies and applications, access control, integrity maintenance, knowledge discovery and privacy, concurrency control, fault-tolerance and recovery methods.

Average customer rating:

Bad book
illustrations are too small
illustrations are too small
Horrible Book - Especially for Beginners
Beginners Beware!!!

Access 2002 Programming by Example
Bob Villareal
Manufacturer: Que
ProductGroup: Book
Binding: Paperback

Database Design | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books
ASIN: 0789725940

Book Description

This book addresses an unmet need in this topic area. It is a complete beginner's tutorial resource to tips, troubleshooting, techniques, and program development for Access 2002. The book covers fundamentals such as database normalization, query design, object manipulation, and optimization and custom programming for forms and reports. It makes the reader more efficient, productive, and knowledgeable in Access VBA. Speed techniques are mentioned. Shortcuts, tips, and techniques increase productivity. This book deals with getting data from outside sources and using VBA to ensure data integrity and consistency, which no other Access VBA book does. It also tackles problems in a variety of day-to-day situations that programmers often face.

Bob Villareal is a contributor and a resident expert for the "Inside Microsoft Access" Web journal and an Access instructor at a Tulsa Community College. He also does freelance programming and instruction. Bob has been developing databases in a large insurance firm for more than 15 years. He has more than seven years' experience of VBA programming in both Access and Excel and has written many tracking and management applications.

Customer Reviews:

Bad book.......2003-02-14

Example: "Every time you open or close a form and [sic] report, you activate [sic] the On Open [sic] and On Close [sic] events."
I've never heard of anyone "activating" an event before. There is no "On Open" event. There's an Open event, which can be associated with an OnOpen method.

The book is full of stuff like this. On the plus side, the writer's weird style is a refreshing change from the documentation regurgitation in other books.

illustrations are too small.......2002-12-12

This review is for the person who is almost making a decision to buy this book. Don't buy it.
I would have not bought this if I have seen this book in person. It is too small and there are a lot of examples which nobody could understand by looking at the pictures. Overall the book is JUNK.

illustrations are too small.......2002-12-12

Horrible Book - Especially for Beginners.......2002-11-26

I bought this book for a school project for a master's level software enginnering class. I have an undergraduate CS degree and have done my fair share of programming but since I do not have any experience with VBA or with Access I thought "Access 2002 Programming by Example" would be the perfect book. Was I wrong. This is a horrible book. Yes the book is splattered with numeours coding examples but I couldn't make heads or tails out of what the book was trying to explain or what feature or technique the author was trying to highlight. I learned more by just playing around with Access than I did from following the book. So now I'm on the hunt for another book to help me with my programming project. I hope that Bob Villareal's students at Tulsa Community College fair better with this book that I did.

Beginners Beware!!!.......2002-09-10

While this book may be a good REFERENCE, it should NOT be touted as a book for beginners. There are so many instances of unclear explanations (and sometimes incorrect explanations, such as on p64 when the "Add new record" button is labelled as being the "Filter by selection" button) in the FIRST PART OF THE BOOK that I don't know how a true beginner could suffer it.
Explanations like "and then click the Show Table button (a thick yellow plus sign)" (p 33) are rediculous when a picture of the icon could have easily been inserted. Another huge problem is how advanced concepts are casually mentioned in the introductory pages of the book - this may be fine for a more experienced user who knows that these terms will eventually be explained, but I'm sure it would be quite overwhelming for a beginning user.

Pragmatic ADO.NET: Data Access for the Internet World (Microsoft .NET Development Series)

Average customer rating:

Keep it in balance
Good, but could use more depth
Great KJob Shawn
Easily the most useful technical book I've read in years.
Excellent ADO.NET Book

Pragmatic ADO.NET: Data Access for the Internet World (Microsoft .NET Development Series)
Shawn Wildermuth
Manufacturer: Addison-Wesley Professional
ProductGroup: Book
Binding: Paperback

Database Design | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

E-Commerce | Business & Culture | Computers & Internet | Subjects | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Business & Investing | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books

Professional | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

ASIN: 0201745682

Customer Reviews:

Keep it in balance.......2005-09-05

This a good book but I think the author goes a little nuts with datasets. Datasets are not the best solution for every situtation.

Good, but could use more depth.......2004-12-15

While this is an excellently written book and a very easy read, I find that it doesn't really have the depth for the really sticky problems. It's a great overview, but not a reference work.

Great KJob Shawn.......2004-12-09

Shawn has given me a lot of good advise on different LISTSERVS. So, I figured it was time I purchased his book and read it.
I guess you could call me the ADO.NET guru at our shop. We all try to specialize in something and this is what I chose 3 years ago. I have read a lot of books and white papers on ADO.NET.
That said, Shawn's book was a quick read for me (about a week, 1-2 hours a night). The book's content is invaluable though if you are learning ADO.NET.
Shawn writes with personality and a little humor. It makes the book fun to read and it flows well. He does not regurgitate the SDK. He introduces a topic, explains it well with a sample or two and a small amount of code (C#) and then moves on. He does not throw volumes of code samples or flow chart\grids at you. One of my pet peeves with tech books is too much code and too many fluffy pictures. There is nothing worst than reading and coming to 10-15 pages of copied\pasted code or 2-3 pages of pretty\fluffy flow charts. Boring IMHO. Stick it on a cd or web site and refer me to it.
Shawn does a nice job covering the things you will need to know and most likely use everyday. He does not waste time covering some cool and neat, that, though it's cool and neat, has little daily value to you as a developer. He covers design techniques very well to.
I did not read the chapter 6, as I am not a fan of typed datasets.
I can honestly state I learned something from every chapter. Most was review, some was "oh yeah, I forgot about that". I especially like the Best Practices section in chapter 11.
My only complaint: he is obviously an Atlanta Braves fan ;-(
I would give the book at least a 4, maybe a 4.5 on a 5 scale. Nice job Shawn and thanks for all the tips.

Easily the most useful technical book I've read in years........2004-11-23

I have been a data application developer for over ten years. I've read, on average, two technical books per year on theory or practical application. This book has been my favorite for a number of reasons:

1) It covers the topics that are necessary to develop data applications in a .NET environment.
2) It gets to the point and doesn't waste your time needlessly.
3) It has concrete examples that are applicable to many situations with detailed descriptions.
4) It fully addresses the .NET focus on disconnected data centering around the Dataset. Making the paradigm switch from ADO to ADO.NET can be a daunting task. The sequence and examples of the book put all of the pieces of the puzzle together and allow you to start thinking in terms of disconnected data and not just DataReaders.

Data is the foundation of most every business application and it's essential to have a full understanding of the database/application interaction. Taking ADO.NET for granted is a common mistake, but spending time understanding to movement and manipulation of your data will result in a more stable and successful overall data application.

Mr. Wildermuth has done a great job. Highly recommended.

Excellent ADO.NET Book.......2004-06-24

Even though I am a VB/VB.NET developer and this book uses all C# examples, I found it to be extremely informative and packed with useful information. The concepts are explained in detail, but the author has written in such a clear and lucid style, that they are easy to grasp. If only all computer books were writen as well as this one! If you have been trying to get a firm understanding of ADO.NET, this is the book for you.

JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition)

Average customer rating:

A difficult balance achieved
A good, Concise guide
The best resource for JDBC users
Over All Good, But~~
The best on the market

JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition)
Seth White , Maydene Fisher , Rick Cattell , Graham Hamilton , and Mark Hapner
Manufacturer: Pearson Education
ProductGroup: Book
Binding: Paperback

General | Programming | Computers & Internet | Subjects | Books

Relational Databases | Databases | Computers & Internet | Subjects | Books

Database Design | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

Java & Databases | Databases | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books
Similar Items:

ASIN: 0201433281

Amazon.com

The second edition of the JDBC API Tutorial and Reference provides a worthwhile tour of the new features in Java Database Connectivity (JDBC) 2.0 and serves well as a reference to Sun's new standard for Java database programming.

Once you open this book, it becomes quickly obvious that it is more comprehensive than the first edition. The new edition begins with an overview of the JDBC API, including its architecture and overall design. Beginners will also be pleased with a short breakdown of the Java programming language and SQL basics.

Early sections of the book walk through an approachable tutorial of JDBC, concentrating on topics such as connecting to databases, retrieving result sets, manipulating records, and handling database transactions. There's also coverage of using stored procedures, including embedded SQL with SQLJ.

The book then turns to new JDBC 2.0 API features, like scrollable cursors, updateable record sets, and batch updates. Experienced readers will appreciate how the authors show off JDBC 1.0 code before presenting these new features. An explanation of SQL3 data types supported in JDBC 2.0 follow the discussion of the API features.

The book provides extensive support for finding and understanding recordsets and databases, including the use of the oddly named ResultSetMetaData and DatabaseMetaData classes, which have been greatly enhanced in JDBC 2.0. (You can now write Java code that customizes itself at runtime for almost any SQL platform.) Similar in spirit to the Microsoft OLE DB, the new JDBC 2.0 now supports rowsets, which let programmers work with any tabular data store from within their applications.

Most of the book (over 600 pages) functions as a reference containing every JDBC 2.0 class. Presented alphabetically, each class comes with an introductory definition and a complete listing of its constituent members and methods (including deprecated APIs). Final sections include a guide to "SQL to Java" mappings and tips for writing JDBC drivers.

Whether you are approaching JDBC for the very first time or are ramping up from JDBC 1.0, there is perhaps no better source for learning about the enhanced powers of the new JDBC than this "official" guide from Sun. --Richard Dragan

Book Description

This book provides the definitive description of the JDBC(tm) API, the technology that enables universal data access for the Java(tm) programming language. This new edition has been updated and expanded to cover all of the JDBC 2.0 API, including the JDBC 2.0 core API and the JDBC Standard Extension API, the package that facilitates building server-side applications.

Containing in-depth explanations that go beyond the specification, this complete resource pairs a step-by-step tutorial with a comprehensive reference to all of the classes and interfaces.

For those new to Java technology, the book includes an introduction to the Java programming language and to SQL. It builds on this basic knowledge to walk you through creating a JDBC application-from setting up a database and establishing a connection to retrieving values from result sets and using prepared statements. In addition, the authors provide many examples along the way that demonstrate how to execute common tasks. The book proceeds to more advanced topics, focusing on the new features of the JDBC 2.0 API, including scrollable and updatable result sets, batch updates, SQL3 data types, custom mapping, and more.

You will also find an introduction to working with the JDBC metadata API as well as information on rowsets, the technology that makes it possible to handle data sets from virtually any data source as JavaBeans(tm) components.

From array to XADataSource, a useful alphabetical reference provides concise but complete information on each class and interface in the JDBC API. Each entry includes an overview as well as a list and explanation of the methods and fields.

A chapter on mapping SQL types and types in the Java programming language, a summary of the new JDBC 2.0 features, and a glossary complete this indispensable resource for all database programmers.

Customer Reviews:

A difficult balance achieved.......2002-02-28

This is a comprehensive guide to all aspects of JDBC. It pretty much succeeds in being all things to all people. The chapters are verbose and well thought out - as befits a tutorial book - and each one is rounded off with a comprehensive guide to all the relevant JDBC API calls - as you would expect from a reference book.

The example's are a little lightweight but nevertheless they work and they do illustrate the points being made in the text.

I bought this book about a month ago to get me up to speed on Java's take on SQL and now find that, in addition to showing me the Java, I know twice as much about SQL as I did before.

Well recommended.

A good, Concise guide.......2001-12-31

At last, a Java book that cuts through the nonsense, gives sound advice and examples and delivers what it promises. This is my number one choice as a JDBC reference.

The best resource for JDBC users.......2001-09-24

This book contains everything you need to create either simple or very complex database applications written in Java - a short introduction to relational databases and SQL language, very nice and understandable JDBC tutorial, complete reference manual of all JDBC 2.0 classes and methods, and several good examples how to use JDBC features in your applications.

Actually, I would appreciate more detailed description of using distributed transactions, relation between JDBC and JTA and using EJB database components but the main purpose of this book is to cover the most common features of JDBC API - and this goal is definitely fulfilled.

Over All Good, But~~.......2001-08-22

Over all, the book is good. It explain the concept precisely and clearly. It is better than other related book available in the market. But there are some week point:
1. It is not for the very bignner. It assume you know something about ODBC setting. In the advanced part, it assume you know what distributed computing, EJB and JNDI is.
2. Some of the example can not be running through. such as the Applet example, and most of the example in server site connection(even though I know how to install EJB)
3. Part II is not worth the money, you can easily get these information in J2EE API online.

The best on the market.......2001-07-21

An excellent book. You should do the tutorials last, because the text will make more sense. I really enjoyed reading this book. It helped my jdbc skills really mature. The authors really know what their talking about. Everything in the book makes sense.

Books:

Books Index

Books Home

Recommended Books