Amazon.com
This is the rare case of a book that can take you from a beginner to an advanced-intermediate level. Like many of the books in IDG's Dummies series, this volume begins with a definition ("What is SQL?") and ends with "The Part of Tens," a collection of tips in a top ten list form. Taylor writes in a breezy, entertaining style that SQL novices will find inviting. One caveat: The examples are given in Borland's Delphi, a rapid application development (RAD) tool. Some sections show several screen shots from Delphi and it may be difficult to follow along in these sections if you don't have the program in front of you. As with other Dummies books, SQL for Dummies is entertaining to read although the nonstop jokes may distract some readers from the technical content.
Book Description
See how SQL interfaces with today's environments
Start building and using relational databases with SQL's newest features
The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more!
Discover how to
* Use SQL in a client/server system
* Build a multitable relational database
* Construct nested and recursive queries
* Set up database security
* Use SQL within applications
* Map SQL to XML
Customer Reviews:
We love it!.......2006-12-20
Hardcore DBAs have knocked this book, but I have coworkers who reference it daily and they are now very experienced and knowledgable of SQL.
SQL for Dummies.......2006-11-05
If you know absolutely nothing about SQL, this book is for you!
A proper start in SQL, nothing more .......2006-03-23
About a year ago, I was writing up a series of lessons for a course in Java DataBase Connectivity (JDBC) that I was preparing for a local business. As is always the case, they needed the course right away, so I had little time to prepare the lessons. To illustrate what can be done using JDBC, I used the executeQuery() method of the Statement object. The executeQuery() method accepts an SQL command as input, so it was necessary for me to quickly brush up on SQL commands. This is the book I reached for to get myself back to speed on SQL commands. Like all ""For Dummies" books, it can be used to quickly learn the basics of the topic, although it has little use beyond the beginning. I found it adequate for my needs at the time, although when I needed to delve deeper into SQL for a later course, I went elsewhere.
All of the basics are covered at the level one expects from the series, and at the level of the beginner. Of course, some people will struggle with the book, as there is no precise definition of "beginner", or "dummy" for that matter. Nevertheless, if you need to learn the fundamentals of SQL in a hurry, then this book is the one for you. It is simple, direct and just thorough enough to put you on the right track.
Absolutely terrible.......2005-11-22
I have read several books in the Dummies series and found them all excellent, so when it was time to learn SQL for a programming project I got this one immediately.
Unfortunately, SQL for Dummies, turned out to be that absolute worst technical book I have ever laid eyes on.
It jumps from topic to topic without ever really explaining anything. It uses examples that are unecessarily complex -- I get the feeling his examples just come from years of working with databases, rather than a desire to illustrate any particular thing -- and the examples are never explained. Over and over, there will be a snippet of SQL code used as an example, and I will wonder, "what does this or that part of the statement do?" But he never explains anything. He just throws it out there and then moves on.
Dummies books always have a conversational tone, but the tone in this book is overly hokey and just reads like meaningless filler; all the more frustrating because there isn't really any content that it's filling in between.
All I wanted was the basics of database design and interaction, an enumeration of the commands used for creating and interacting with databases and why some actions are useful and for what, and examples throughout of how one would do typical things. Instead I got an intolerable and incoherent ramble.
Shipped in a very short time.......2005-08-31
This book was shipped to us in a very short period of time. We were very pleased with this purchase.
Book Description
Build an online catalog and a members-only site
Everything you need to know to create a dynamic PHP and MySQL Web site!
Been thinking of creating a high-quality interactive Web site? This book is just what you need to get started! Here's the fun and easy way(r) to develop a Web application in PHP 4, 5, or 6 and MySQL 5, test your software, enable your Web pages to display, change, and move database information, and much more.
Discover how to
* Plan and implement a Web database application
* Design and build a MySQL 5 database
* Build dynamic HTML forms
* Create scripts that store, retrieve, and update database information
* Display database information in a Web page
Customer Reviews:
Disappointing.......2007-09-18
I normally like the "for Dummies" series because I know that it'll start me out at "zero" knowledge and get me through to an understandable/workable level of the subject. PHP & MySQL for Dummies seems to think I'm a programmer who doesn't know html instead of the reverse, which I am. The author spends pages, pages and chapters telling the reader how to format syntax and characters without running through examples for the reader to replicate. I'm about halfway through the book now and hope to eventually run into those examples.
Great Resource for Beginners.......2007-08-07
I recommend this book for anyone that doesn't already have some printed material on PHP and MySQL. It's great for beginners and paves the road of programming. It's pretty easy to read and I find myself constantly looking back through this book when addressing certain concepts or functions.
Would recommend.......2007-07-05
I just finished PHP and MySQL for Dummies last night. I took C++ about 7 years ago in highschool and I think that helped with following the PHP part. Here are the pros and cons I found.
Cons
1.Not enough info on PHP and Mysql setup. One of the reasons I picked up this book was for help in getting everything configured. I had tried numerous how-tos on the web that weren't working, this did not offer much help either, although you can email the author for additional support. Solution: save the headache and download WAMP5, everything is configured for u with php, mysql, and apache server.
2. I found it annoying that the author would throw in lots of functions that were not included in the chapter into her example programs. Sure, they're there (some of them) in the last chapter, but they are not referenced so some of the examples are hard to proof unless you change them or read ahead.
3. Read the chapter "PHP Gotchas" at the beginning of the php chapters intead of at the end. If you follow along in order you will already know everything in that chapter, with much frustration, by the time u get there.
Pros:
I now know how to design a fully functional web program and have already figured out in my head how to do 2 others, plus modifications to the sample programs.
This is not the last PHP/MySQL book you will buy but it's good to get your feet wet.
A Very Good Beginning.......2007-06-14
If you're looking to learn the basics of PHP and how it connects the web with databases, this is a very good starting point. The author takes the time to teach all of the basics of MySQL and PHP (even referencing differences between versions) and provides clear examples of two common uses of PHP - online catalogs and member-only sites.
One note though - you most definitely want to have a decent grasp of HTML and at least the basics of SQL before you start into this.
Overall it was well worth reading.
Good beginner book -- useful for reference -- quickly digested.......2007-01-10
Very practical material that can also be used for reference while working on projects.
I found that the mateials are consummed very quickly and the developer may have to research further deeper into some areas.
Beware of differences in function names and uses in different PHP versions. (v. 4 vs. v. 5), which is described by the author.
Hope it helps.
Book Description
- Delivers the know-how that novice database developers, enthusiasts, and independent software vendors need in order to use the SSE database
- Written in the typical nonintimidating For Dummies style, the book's emphasis is on installing SSE and using it to create simple database applications with other tools in Microsoft's Express product line
- Covers how to use SQL Server Express Manager, an easy-to-use management tool that comes with SSE, and the Application XCopy feature, which provides SSE with the ability to treat databases like files
- Addresses topics unique to SSE and not covered in standard SQL Server books, including network and security features, migrating and connecting from Access and MSDE to SSE, and migrating from SSE to the full-blown SQL Server database
- The CD-ROM contains SQL Server Express trial version and the Web site has the code from applications featured in the book
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Customer Reviews:
We're Dummies, Not Stupid.......2007-07-09
The first 100 pages were read before starting to learn anything of real value. Please don't write for the sake of increasing the page volume of a book. Our time is valuable too.
Trying to be funny and telling us SQL Server 2005 Express is Free over and over again, chapter after chaper, is ... well ... simply not funny. We're dummies, not stupid.
You covered T-SQL relatively well. However, the heart and soul of SQL Server 2005 Express is Stored Procedures, Triggers and SQLCLR - but you barely even scratched the surface. A few pages here and there is not simply enough. So I still feel like a dummy.
A Lot of Good Points about this Book.......2006-08-27
There's a whole bunch to like, in my opinion, about this book and only one point that I think is pretty weak.
First off, what's there to like. Probably most important is that SQL Server Express is available and it's an extremely powerful software system and it's FREE, a very good price. Second is the book which is written in the typical 'For Dummies' style, with an occasional joke thrown in, that makes it pretty easy to read and yet is doing its job of educating you about the subject. And third, there's a CD-ROM supplied with the book that contains SQL Server Express as well as a lot of ancillary but useful programs to go with it. Yes, you can download SQL Server from the Microsoft web site, but having a CD is a lot easier and faster.
The weak point. There's a chapter on migrating from Microsoft Access to SQL Server that primarily talks about upgrading the tables from Access format to SQL Server format using one of the utilities provided. What's missing is a discussion on the differences in Access SQL (based on the 1989 standard) and SQL Server SQL (based on the 1992 standard). If you've used SQL to talk to Access on your previous system, you're in for a bit of a challenge to get it to talk to SQL Server.
Really helped me understand this product!!.......2006-07-30
I downloaded SQL Server for free from microsoft but needed some guidance to help me use the product to its full potential. In searching amazon I came across this book and decided to take a chance. Wow! It gave me a great broad overview of the product without bogging me down in too many details -- great simple writing style, really easy to follow.
In a few days, I was up and running with the software. I'm planning on writing an application using Visual Basic and this book has a great tutorial on using it this way. I would highly recommond this book to anyone who needs to learn how to use SQL Server.
Average customer rating:
- Excellent Text For PL/SQL Beginners
- Excellent Book For Learning PL/SQL
- Good reference, not for beginners
- First Rate Book
- An excellent text on PL/SQL
|
Oracle PL/SQL For Dummies
Michael Rosenblum , and
Paul Dorsey
Manufacturer: For Dummies
ProductGroup: Book
Binding: Paperback
 General
| SQL
| Databases
| Computers & Internet
| Subjects
| Books
Database Management Systems
| Databases
| Computers & Internet
| Subjects
| Books
General
| Oracle
| Databases
| Computers & Internet
| Subjects
| Books
PL & SQL
| Oracle
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Software Development
| Software Design, Testing & Engineering
| Programming
| Computers & Internet
| Subjects
| Books
General
| Languages & Tools
| Programming
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
All Amazon Upgrade
| Amazon Upgrade
| Stores
| Books
Computers & Internet
| Amazon Upgrade
| Stores
| Books
For Dummies
| Amazon Upgrade
| Stores
| Books
Similar Items:
-
Oracle9i for Dummies
-
Toad Pocket Reference for Oracle (Pocket Reference (O'Reilly))
-
TOAD Handbook
-
Oracle Database 10g: A Beginner's Guide (Osborne ORACLE Press Series)
-
Oracle Database 10g PL/SQL Programming
ASIN: 0764599577 |
Book Description
Find tips for creating efficient PL/SQL code
If you know a bit about SQL, this book will make PL/SQL programming painless!
The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.
Discover how to
- Write efficient, easy-to-maintain code
- Test and debug PL/SQL routines
- Integrate SQL and PL/SQL
- Apply PL/SQL best practices
- Use new features introduced in Oracle 9i and 10g
Customer Reviews:
Excellent Text For PL/SQL Beginners.......2007-06-26
Fantastic text for beginners in PL/SQL. Clearly laid out concepts and samples, and hints at naming conventions and other standards to be used. A very solid introduction to the language.
Excellent Book For Learning PL/SQL.......2007-03-09
I am very pleased w/ the purchase of the book. If your goal is to learn PL/SQL quickly and comprehensively, this is the book to buy. It covers all the fundamentals you need to know about PL/SQL and it is excellently written. I have been a developer for 20 years in many languages. Learning new languages from overly technical books and writters, I find, often times make your learning process slow and ineffective. I took this class at Oracle, but there were topics that the training manual and the instructor did not do a good job presenting. This book clarified many of the topics I that were presented in class in a simpler, clearer, and more effective manner. I highly recommend it.
Good reference, not for beginners.......2006-11-10
This book has a lot of good technical data, but it's not well organized for learning, more of a reference. Also, it assumes you are already an experienced SQL programmer.
First Rate Book.......2006-07-27
This book is an excellent introduction to both PL/SQL and general coding principles. It is a good book for beginners and old dogs alike. It provides simple, clear and useful introductions to advanced topics such a INSTEAD OF TRIGGERS, BULK COLLECTS etc. My team is now using it a our "best practice" document for PL/SQL coding. Well done Misha and Paul.
An excellent text on PL/SQL.......2006-07-26
As I began reading, the attribute which came foremost to my mind was "readable". It covers all of the basics in a fashion readily comprehensible to those with even modest exposure to programming. We can always do better, but for most of us, if we go only as far as this text takes us, we will do far better than many of our contemporaries in the industry today.
It certainly is also "A Reference for the Rest of Us". Those of us who have used PL/SQL for many years may not have noticed various handy new features as they have come along, and for those features we know of but use less frequently, this book is a handy reference.
Interspersed with the fundamentals of the language and all of the tips and examples, the authors continually (and gently) remind us that we have to keep checking the bigger picture - in short how to avoid project failure. Good advice in any language.
Book Description
PHP and MySQL Everyday Apps For Dummies is a one-stop reference providing all you need to build dynamic, real-world, ready-to-use apps with the popular PHP (a scripting language) and MySQL (a database system) software. The book is a hands-on, go-to-guide that
- Walks you through installing the applications files from the CD-ROM and setting up your programming environment
- Contains all the code needed to create seven applications:
- User authentication with HTTP
- User login
- On-line catalog
- Shopping cart
- Content management system
- Web forum
- Building and managing a mailing list (on the CD-ROM)
- Automates the programming process and walks you through building the application from start to finish
- Explains how to write secure code
- Features complete code—not just snippets, but neatly assembled packages with “instant” real-world functionality
- Shows how to build the applications in two forms -- procedural and object-oriented programming -- providing programmers who want to switch to the object-oriented method of coding (which is new in PHP 5!) with the essential know-how
- Includes a companion CD-ROM that contains every line of code in the applications from the book plus a bonus chapter that shows how to build a mailing list
Information on each application includes a discussion of issues, structure of the database, code listings, and an explanation of the code. You can use these applications as is, modify them for use on your Web site, or build your own application using techniques described. If you want real-world Web apps you can use right away, this is the book for you.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Download Description
Provides Web developers using the popular combination of PHP (a scripting language) and MySQL (a database system) with practical applications that they can adapt and put to work right away A 2002 survey found that PHP was running on over 9 million Web sites, and there have been over 1.8 million PHP downloads since May 2002; MySQL reports 2 million users Applications include a user login, an online catalog, a shopping cart, a content management system, a Web forum, and a mailing list management system The author walks readers through the creation of each application, offering two different versions-procedural (the traditional PHP coding method) and object-oriented (new in PHP 5)
Customer Reviews:
This is a practical book, not for beginers.......2007-09-15
This is a very good book to get practical skills in PHP development with MySQL appliances.But before buying it, it is important to understand that this book is not for beginers, this book assumes that the reader have a least basic knowledge of both tools.
For very dummies.......2007-03-16
if you need a first impression, just found out that computers exist, if you think PHP stands for a new boygroup, then this is the book for you.
NO CD.......2006-03-29
I downloaded it, but not could not find the accompanying cd. can anyone post a link to it!
Recommended for Advanced - Beginners.......2005-10-16
This book is challenging and informative. Some basic knowledge of PHP MySQL is required before beginning this book.
Several Common Apps Working and Described.......2005-08-19
There are a handfull of applications that every web designer sooner or later has to implement. Of course a skilled web programmer can do any of these applications. All it takes is time, thinking about the problem, writing, debugging, checking out, and making the customer (who may be the programmer him/her self) happy.
Today there are several scritping languages that can be used to tie the web site together with a database for storing the data. One set of software that you can use is PHP and MySQL. Both of these are highly advanced products (often combined with Linux and the Apache web server for a high performance web server with no software cost). You might use these to write the applications you need.
But when we are talking about common applications, these have been done over and over. In this book, six applications are included, working and ready for you to install. Once you get them operational, you can easily modify them to suit your particular needs. The code for the application is given, both printed in the book and included on the CD that comes with the book. The code is then carefully explained both conceptually as to what the app does, and line by line so you know what's going on and modify it as needed.
The application included are:
two login apps
shopping cart
content management system (allows users to publish documents on your system)
Online bulletin board.
The book is intended to be self standing, but if you know nothing about PHP or MySQL you might look for the same authors book PHP & MySQL for Dummies.
Book Description
- Now updated to reflect the much-anticipated "Yukon" release of SQL Server, this friendly guide shows database developers and administrators as well as those who use database application how to get up to speed fast
- Offers a gentle introduction to relational database design and shows how to build databases, create database applications, and maintain and optimize database performance
- Covers the major new features of the "Yukon" release-including analysis services, reporting services, and notification services
Download Description
Now updated to reflect the much-anticipated ""Yukon"" release of SQL Server, this friendly guide shows database developers and administrators as well as those who use database application how to get up to speed fast Offers a gentle introduction to relational database design and shows how to build databases, create database applications, and maintain and optimize database performance Covers the major new features of the ""Yukon"" release-including analysis services, reporting services, and notification services
Customer Reviews:
Hard to follow.......2006-10-02
I agree with the previous reviewer. This book is not focused and not targeted to an audience. Most of the features are not covered with enough depth and background to make the information useful. The chapter on replication, which is an advanced feature, was pretty good, but the chapters on backup and recovery where poorly explained.
Confusing.......2006-09-15
This author often forgets who he is talking to. At one point he describes in painful detail on how to join tables and yet in other places he introduces terminology with no explanation. One chapter is devoted to creating a windows application in VS 2005 to display data and the description is incorrect. Is this a book about SQL Server or Visual Studio? I think the publishers of this book would do well to recall this book and rewrite with a particular audience in mind. Is the book an introduction for newbies or a reference for those coming from some other platform or for programmers looking to familiarize themselves with SQL Server? The fact that this is a dummies book would seem to indicate to me that it should be for newbies. I have always been a fan of the Dummies series of books but this one falls flat on its face.
Amazon.com
Microsoft SQL Server 2000 has become standard equipment in lots of organizations, largely owing to its relatively friendly user interface on top of its solid infrastructure. That user interface, however, can intimidate users who are new to the environment and lack the experience to interpret what they see. Microsoft SQL Server 2000 for Dummies decodes this top-of-the-line relational database management system (RDBMS) for the benefit of such novices, as well as for people coming to SQL Server 2000 from one of its competitors. Anthony Mann does a fine job of explaining not only administrative matters, but also issues of database design, Structured Query Language (SQL), and integration of SQL Server databases into larger information systems.
The instructional style in this book varies depending on the subject at hand. When explaining subjects that are mostly conceptual in nature, such as relational database structure, Mann relies mainly on text and bulleted lists (and perhaps not enough on diagrams, which can really clarify these topics). When covering areas that have more to do with the specifics of SQL Server 2000--running Data Transformation Services (DTS) imports and exports, for instance--he employs steps (with options and alternate paths explained) and screen shots of the user interface. --David Wall
Topics covered: How to set up and maintain databases under SQL Server 2000, with some instruction in relational database design and Structured Query Language (SQL) thrown in. Databases, tables, keys, foreign keys, basic Transact-SQL, stored procedures, triggers, and administrative subjects like backup, restoration, and distributed databases are all covered.
Book Description
Network administrators challenged with the task of building and deploying a network database can look to Microsoft SQL Server 2000 For Dummies for simple answers about a complex tool. Microsoft bills its SQL server as the best and fastest network database for NT-based networks and the Internet. Microsoft SQL Server 2000 For Dummies explores the processes and tasks involved with installing, configuring, and using the latest release of Microsoft SQL Server. This book explores designing SQL databases, scaling your server to handle the tasks you need, creating a database system to handle your business, and SQL's tight integration with other Microsoft networking and Internet management products including BackOffice and the rest of the Windows DNA 2000 suite. This book includes a CD that contains such software as IE 5.5, Vision Builder, Vision JADE and sp_Assist.
Customer Reviews:
Muzzled author produces mediocre book.......2004-03-08
The only perceived value of this book could be the enclosed CD, a 120 day Evaluation version of the SQL 2K Server, Enterprise Edition, a couple thousand retail, which will need a updater to SP3a on the MS support website. This will bring the app to the latest version, since "Yukon" is currently in beta, will not be released until Late 04. You probably can get an Eval CD directly from MS for small shipping, or free at a trade show, such as Comdex, at a local MS Sales office, or SQL Server Users Group (UG). No additional files are on the CD. You can install this on Server 2K, Server 2K3, Server NT4SP6, and Win98SE; but the installation chapter is a download from the publisher's website to save book space!
The heart of the book, Part II DataBase (DB) Design, has 4 chapters over 112 pages for describing relational DB, creating a Customer DB, indexing, triggers, programming, and procedures. He devotes 2+ pages to Locking. Then in Part III Interface Design, he has 3 chapters covering 80 pages for describing SQL, Query, and Import/Export. Slim pickings for a budding DBA, many tables; maybe one can use this book as an abridged reference.
Then there's more, Part IV Enterprise Issues, Chap 11 goes over making a DB backup / restore that I agree needs to be covered. And Chap 12 covering web serving your DB is OK, but I'd hold the line on Chap 13 where he covers Distributed Queries over multiple servers, to exploit the Enterprise version capability. Like most budding DBAs are going to have multiple, remote, networked DB servers at his disposal? Nonetheless, this chapter seems to be the author's pride and joy. I'd highly recommend the author use these 12 precious pages to beef up what he has already covered.
But most superfilous is his Appendix A, where he expends over 18 precious pages for Wizard flowcharts. What a waste! The Security chapter is a download from the publisher's website. The author is at tmann at vbasic dot com .
His book's most significant failing is not showing how to display or print out a result or report of a DB query. Perhaps the author hasn't found out that reports are the life-blood of business. He gives a half page mention of the Crystal Report Writer in the last chapter (p338), but neither integrates reports in his book, nor indicates that an older v4.5 (96) version is bundled with the SQL Server 2K. SQL Server Help for reports is useless as Crystal has its own separate Help. As demoed in our local UG, MS has just released its own Reporting Services module (free download) to supplant the highly regarded Crystal Reports.
Not bad, but could be better.......2003-07-31
This is a good book if you are a "rank beginner" and you don't need to do anything complex with SQL. It's missing a lot of information that could be considered more advanced.
I bought it to help me with my SQL queries in Active Server Pages and I just haven't found it to be that useful. One of my employees, who knows nothing about SQL has found it to be very useful, however.
At least it includes an eval copy of SQL Server..........2003-07-27
Let's just say this is not a very good dummies book. There are very very few "real world" examples of the topics presented. The technical accuracy is pretty decent, but this book will not enlighten any beginners to the world of SQL Server. Advanced topics are rarely explained in layman terms and the depth of coverage is, shall we say, not very deep at all! Stick to the SQL Server Online Books (which this book just seems to re-hash, albeit in much less detail) and you'll learn alot more about SQL Server.
Not much smarter now.......2001-06-28
Although the book covers the major features it offers little over the online help. What is missing is the overall context or a complete example that might help understanding of how to put everything together into a working application. When it presents triggers and stored procedures the examples are so basic as to not explore the potential power. The chapter on relational database design was particularly lacking in ideas or references. Some of the more powerful features such as metadata and analysis services are barely mentioned. The book did introduce the major administrative functions well. If you do buy the book, do go the authors web site described in the book, to get the "bonus" chapters on installation and security, which should also help a new administrator.
Book Description
Find the right information and present it the right way
Take full advantage of all SQL Server Reporting Services can do for you
Without a way to interpret it, the data in your database just sits there doing nothing. Now you have help! This handy guide shows you how to retrieve data and create reports with the newest version of SQL Server Reporting Services, so you can deliver both hard copy and interactive, Web-based reports that tell your story.
Discover how to
- Access information from different databases
- Build the right queries
- Choose the best report type
- Move from other reporting tools
- Deliver reports on demand
- Produce drill-down and drill-through reports
Download Description
Find the right information and present it the right way Take full advantage of all SQL Server Reporting Services can do for you Without a way to interpret it, the data in your database just sits there doing nothing. Now you have help! This handy guide shows you how to retrieve data and create reports with the newest version of SQL Server Reporting Services, so you can deliver both hard copy and interactive, Web-based reports that tell your story. Discover how to Access information from different databases Build the right queries Choose the best report type Move from other reporting tools Deliver reports on demand Produce drill-down and drill-through reports
Customer Reviews:
The worst Dummies book ever written........2007-07-02
This has got to be one of the worst dummies books ever written. The writer of the books skips over too many steps, assumes that you know everything there is to know about the AdventureworksDW data warehouse database or the AdventureWorks database with all of their complicated entity relationships and he doesn't even provide the SQL queries necessary to do the examples that he has in the book in chapters 5, 6 and 7. You have to take best guess at how to write the query for the AdventureWorksDW data warehouse database that he constantly uses in chapters 5, 6 and 7 and other chapters after that before you can follow through and do any of the examples listed in the book. Then when you have taken best guess and and have pieced together the SQL query for the AdventureworksDW data warehouse database for chapters 5 and 6, a few pages later he tells you to do an example that use datafields that have nothing to do with the AdventureWorksDW data warehouse database. The examples just jump around at you and make no sense and you can't follow what the author is trying to get you to do in order to learn how to use SQL Server Reporting services. All in all this book is not worth the paper it is printed on. My advice is to avoid this book like the plague. A far superior book is Microsoft SQL Server 2005 Reporting Services by Brian Larson,McGraw Hill/Osborne press.
Very Bad Purchase.......2007-01-24
This book has a lot of problems. It skips many intermediate steps that even a mid-level developer would probably need. I looked at these comments prior to purchasing the book, but thought these people are probably really good programmers that already *know it all* and are being way too critical. I can say that wasn't the case at all, and they were right on. I believe this book was put together very poorly and Mark Robinson could have done a much better job in explaining these intermediate steps that can make all the difference in the world. (VERY LAZY INSTRUCTIONS) As many of you may know, when you miss just 1 step, it can make all the difference in the world. (START WANTING TO PULL YOUR HAIR OUT) If you want a book that shows you step by step instructions and actually explains essential functionality, I wouldn't recommend this particular book.
Complete garbage.......2006-01-22
This book skips so many intermediate steps that it is not suitable for beginners. It also assumes that the reader is already familiar with the adventure works data warehouse schema. It fails to give beginners enough background to be a useful learning tool.
Book Description
Create and modify databases and keep them secure
Get up to speed on using T-SQL to store and manipulate data
SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You'll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more.
* Create queries to retrieve data
*
Ensure SQL Server security
*
Use Visual Studio(r) 2005 with SQL Server
*
Create tables, views, and indexes
*
Work with Common Language Runtime
*
Query XML data
Customer Reviews:
Excellent-exactly what I had hoped for!.......2007-05-21
This book is excellent. I have not worked actively with databases in many years and was trying to learn more about SQL 2005 commands. The book is written in a very logical step-by-step way so you don't get lost or clobbered with a whole lot of lingo that makes you feel inept. Recommend this to anyone who is trying to get a good grip on the subject.
Book Description
- Shows Web developers how to use two popular open source technologies, the PHP scripting language and MySQL database, to build Web database applications
- This updated edition covers changes in PHP 5 and the latest version of MySQL, including programming techniques for the new PHP default setting, methods for handling MySQL security problems, and extended information about Apache Web Server and Mac OS X versions of PHP and MySQL
- Explains how to install Windows, Linux, and Mac OS X versions of PHP and MySQL
- Includes two complete sample applications: an online catalog and a members-only Web site
- Features a companion Web site with code examples from the book and links to the author's successful site
- Kevin Beaver has more than fifteen years of experience in security and information technology, specializing in security assessments and incident response
- Features a companion Web site with links to various utilities discussed throughout the book and practical security checklists
Download Description
- Shows Web developers how to use two popular open source technologies, the PHP scripting language and MySQL database, to build Web database applications
- This updated edition covers changes in PHP 5 and the latest version of MySQL, including programming techniques for the new PHP default setting, methods for handling MySQL security problems, and extended information about Apache Web Server and Mac OS X versions of PHP and MySQL
- Explains how to install Windows, Linux, and Mac OS X versions of PHP and MySQL
- Includes two complete sample applications: an online catalog and a members-only Web site
- Features a companion Web site with code examples from the book and links to the author's successful site
- Kevin Beaver has more than fifteen years of experience in security and information technology, specializing in security assessments and incident response
- Features a companion Web site with links to various utilities discussed throughout the book and practical security checklists
Customer Reviews:
Damn fine piece of work.......2007-09-04
If you skim the verbiage, scout the chapter titles, read the section headings and review the code, you will very quickly understand php and the interaction with mysql.
This book will not teach you html. Go read that book.
This book will not teach you sql. Go read that book.
This book gives you a sequential and an object method of programming against a database within HTML.
Each example builds to the following example, until you have the final piece of programming demonstrating the concept.
The index works.
The only addition the author could make is strip the book down into a php and mysql 10 minutes per chapter type of book.
Terrible.......2007-01-26
I would recommend for beginners not to use this book. Even for me (a somewhat intermediate programmer), I had difficulty understanding what was being done and what it did. The example syntax is messy making it hard for readers to understand. There are better approaches for teaching PHP & Mysql.
Just right.......2007-01-15
Perfect for the newbie who has no probgramming experience but an understanding of the concept of programming and also of the structure of SQL databases.
Excellent guide to PHP & MySQL but with few typos........2006-08-28
I picked up this book from my school library, but it was not easy to borrow this book from there because it was checked out everytime I was trying to look through the library catalog, despite there were about 2 ~ 4 books showed up as "checked out". And I have to say that, when I finally found this book from the shelf and checked it out, the included CD was checked out by someone else.
Let me start with the format of this book. I am pretty sure that quite a lot of people here mentioned this fact in their reviews, but I have to say that this book has one of most interesting types of format I have read from the computer learning books. The author, who appears to have a plenty of experiences and background in the Web design and the programming, is able to express the material clearly without any kind of bragging or lossing herself in the middle of explanation. Her main application theme is "a pet store," which she was demonstrating extensively at the Chapters 11 and 12 as an actual application that is usable.
Before jumping into the "pet store application," it is necessary to mention her other teaching approaches in the previous chapters. At the first few chapters, she definitely put the emphasis on planning out and organizing the structure of your database and website before jumping into typing. In fact, she continues this trend further in the later chapters by suggesting to go back to the Chapter 3, a chapter which is entirely dedicated to the creating the database structure with a pen and a paper, and coming back again on Chapter 10, which I felt as a sort of short review for what a reader read so far. And I belive this format is one of best, if not the best, because this somehow closely resembles a school textbook that requires you to master and to think about the subject to proceed. She also does not skip the possible commands or queries by putting in a neat table that shows the script with their description next to it.
But most helpful and joyful part of this book is the application. Because the application here is rather long while needs the understanding, I strongly believe it is not a wise idea to jump into the application without understanding solidly on PHP or MySQL from the previous chapters. However, I have read the book almost throughly, and I right now have created an internet order system of my own with the shopping cart in addition to the catalog. Well, the "shopping cart" was not mentioned in the book, but this book was constructed in such a way that you can actually build your own applications or modify others. And because she used the "pet" as her main subject of the application, it will definitely not turn down the most of readers who just hate to be simply geeks and get bored reading such subject in the book. And because the book actually shows the screenshots of the application and the results after running the application, you cannot help trusting that the application is actually going to work and be an awesome one at that.
There are some problems with the book, however. One serious problem is that there are quite many typos in the book that can give you some headache. However, if you follow the book well or have some common experiences in debugging in the programming, this will actually become a mental exercise for you to understand better. At least that is what I think... The second problem is that the book does not extend beyond the advanced topic. Hence, if you are an advanced PHP or MySQL programmer and bought this book, it is very possible that you are going to be disappointed. Nevertheless, this book was meant for beginning programmer and it does the job so well at least for that purpose. And I think some experienced programmers will find this as an interesting book to scan over.
Coming back to my story... I did not have the CD when I checked out this book, but I think you can find the list of some applications in the website of the author. And while I had experienced some headache in trying out to figure out what was wrong with my application while there were typos, if you got a CD or if you visit her website, which I did not yet, I think you are going to be far better ahead with this book. Yes, I have to admit that I had some experiences with the programming, but I think this will definitely be easy to read for the completely new comers as well. This, in fact, is a much better book that other Dummy book that was published with 5 topics in one(I am not saying which one). And I have finished with this book during the Summer, which was enough time to be more experienced with so called PHP and MySql and to develop my own shopping page application. Hope this helped you.
Review of mySQL for Dummies.......2006-07-14
This very readable text does what it sets out to do - gives the reader a full appreciation of the power and initial usage of mySQL and PHP.
Books:
- SQL Server 2005 Bible
- SQL Tuning
- Squid: The Definitive Guide
- Switching to VoIP
- The Accelerated Learning Handbook: A Creative Guide to Designing and Delivering Faster, More Effective Training Programs
- The First Year: Type 2 Diabetes: An Essential Guide for the Newly Diagnosed (First Year, The)
- The Internet Book: Everything You Need to Know About Computer Networking and How the Internet Works (4th Edition)
- The Long Tail: Why the Future of Business is Selling Less of More
- The Mastering Engineer's Handbook (Mix Pro Audio Series)
- The Official Guide for GMAT Review, 11th Edition
Books Index
Books Home
Recommended Books
- Federal Resume Guidebook: Write a Winning Federal Resume to Get in, Get Promoted, and Survive in a G
- An Unmentionable Murder
- Retire Rich: The Baby Boomer's Guide to a Secure Future
- The Ufa Story: A History of Germany's Greatest Film Company, 1918-1945
- Trend Following: How Great Traders Make Millions in Up or Down Markets, New Expanded Edition,
- A Story Like the Wind
- Whoosh Boom Splat: The Garage Warrior's Guide to Building Projectile Shooters
- Bottom Line: Practical Financial Management in Business
- The Great Game: The Emergence of Wall Street as a World Power: 1653-2000
- Tirano Banderas: Novela De Tierra Caliente
Sams Teach Yourself SQL in 10 Minutes, Third Edition
Crystal Reports 10 For Dummies
SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition) (For Mere Mortals)
Database Development for Dummies
