Great little book, 12 Jun 2008
I bought this book because I am a programmer and need to interact with SQL on a daily basis. However...I do not want to know the fine grain details about database management systems. This is a great little book. It is very easy to read and met my needs perfectly. The samples are all easily achievable in 10 minutes, just like it says on the cover. This makes them very easy to scan over for a refresher when you are trying to work out a solution to a problem. It does not go into great details on the more advanced topics, however it does offer a primer on some of them such as transactions and cursors. Overall I would have no hesitation in recommending this book. It won't make you a SQL pro...but it will definitely make you more comfortable in common situations using this query language.

Perfect for beginners, 19 Apr 2008
This is the best book I have seen for people learning SQL from scratch. It takes you through the basics very quickly without assuming prior knowledge. Recommended for anyone with little or no prior SQL experience. You may want a basic SQL reference book to complement it.

You are better off with online tutorials, 27 Jan 2008
I recently wrote a simple database application for a hobby use. I have previous experience with SQL, but I wanted a handy reference to remind me of the basics. Time and time again I found this book useless, and resorted to an online search. I found the organisation of the book odd. If you want to create a simple application to learn with, you have to start from the back, as he tells you how to create a database and tables at the end.

Good Basic Introduction, 10 Dec 2007
This book is a great place to start for SQL. It tells you pretty much everything you are going to need to know for basic database usage. The later chapters on more advanced features such as triggers and stored procedures aren't massively useful as they don't go into enough depth but the author does say that they are only really intended to give you an idea of what you can do, not how to do it.

This book isn't going to teach you everything you need to know about SQL but it will give you the basics quickly and painlessly.


A great (if not simplistic) reference, 19 Jun 2007
This is a great reference for those starting out with SQL, or those just looking for a quick reference book to keep on their desks.

Don't be mistaken tho, it's by no means a complete reference, and doesn't cover any of the advanced SQL, but it's explanation of triggers, stored procedures, and transactions is a great reference to get around those mental syntax blocks

Ace your preparation for the skills measured by MCTS Exam 70-431 and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you've learned by applying your knowledge to real-wor

Great little book, 12 Jun 2008
I bought this book because I am a programmer and need to interact with SQL on a daily basis. However...I do not want to know the fine grain details about database management systems. This is a great little book. It is very easy to read and met my needs perfectly. The samples are all easily achievable in 10 minutes, just like it says on the cover. This makes them very easy to scan over for a refresher when you are trying to work out a solution to a problem. It does not go into great details on the more advanced topics, however it does offer a primer on some of them such as transactions and cursors. Overall I would have no hesitation in recommending this book. It won't make you a SQL pro...but it will definitely make you more comfortable in common situations using this query language.

Perfect for beginners, 19 Apr 2008
This is the best book I have seen for people learning SQL from scratch. It takes you through the basics very quickly without assuming prior knowledge. Recommended for anyone with little or no prior SQL experience. You may want a basic SQL reference book to complement it.

You are better off with online tutorials, 27 Jan 2008
I recently wrote a simple database application for a hobby use. I have previous experience with SQL, but I wanted a handy reference to remind me of the basics. Time and time again I found this book useless, and resorted to an online search. I found the organisation of the book odd. If you want to create a simple application to learn with, you have to start from the back, as he tells you how to create a database and tables at the end.

Good Basic Introduction, 10 Dec 2007
This book is a great place to start for SQL. It tells you pretty much everything you are going to need to know for basic database usage. The later chapters on more advanced features such as triggers and stored procedures aren't massively useful as they don't go into enough depth but the author does say that they are only really intended to give you an idea of what you can do, not how to do it.

This book isn't going to teach you everything you need to know about SQL but it will give you the basics quickly and painlessly.


A great (if not simplistic) reference, 19 Jun 2007
This is a great reference for those starting out with SQL, or those just looking for a quick reference book to keep on their desks.

Don't be mistaken tho, it's by no means a complete reference, and doesn't cover any of the advanced SQL, but it's explanation of triggers, stored procedures, and transactions is a great reference to get around those mental syntax blocks

Not so easy to follow, 17 Sep 2008
I found this book is quite hard to follow. This is my very first SQL server book, and I was lost just in the first couple of the lessons. The author probably expected the readers to have a good knowledge about the system already, so there are not enough screen shots to guide you.

Plain English (not), 21 Aug 2008
This book is very dry and hard to read, some of the text is pure gobbledygook. It also assumes you have knowledge of some of the subjects it teaches. This is supposed to be a training course!

Is summary I wish I had spent my money on something else.


Not Impressed!!, 03 Mar 2008
Honestly - utter rubbish!!
There is several times ive read chapters and not known what the hell they are talking about. They do alot of 'Then all you have to do is close this' without actually telling you what the hell THIS is or wher to find it!!!!I'm already a dba on SQL Server 2000 so i though this would be a good top up!!! Ive gone back to googling the chapeters and reading up somewhere(anywhere) else....

It's an IT textbook, 29 Jan 2008
This is my first Microsoft Press textbook/training kit for an exam - and this is exactly what is focuses on - getting you through the exam.

It's very dry (and rather boring), and I much preferred reading the Wrox books Beginning SQL Server 2005 Administration, and then Professional SQL Server 2005 Administration (which appear to be comprehensive as well as being more readable).

Still, this book comes with a CD for 180 trial licence for SQL Server 2005 - and a Measure Up CD with exam simulation software.



Good training guide, poor as a reference book, 11 Sep 2006
These books have a tough expectation list as people want them to provide all they need to know to get through the associated examination and be a first class refernce book. The five-star rating applies to the former of these requirements as this is the market the book is aimed at. Having sat the examination I can say that all of the questions were answered in the book - and from previous exposure to these books that is not normally the case.

As a reference book it fails, simply because it is not intended as such and more obviously because to cover all the topics adequately it would have to be five times as long. That said, the section on Service Broker is way too vague - the knowledge it imparts will get you through the examination but will leave you floundering in the real world.

Use the book to pass the exam and to introduce you to the new technologies - look elsewhere for more in-depth practical (i.e real world) material.

[...]

Great little book, 12 Jun 2008
I bought this book because I am a programmer and need to interact with SQL on a daily basis. However...I do not want to know the fine grain details about database management systems. This is a great little book. It is very easy to read and met my needs perfectly. The samples are all easily achievable in 10 minutes, just like it says on the cover. This makes them very easy to scan over for a refresher when you are trying to work out a solution to a problem. It does not go into great details on the more advanced topics, however it does offer a primer on some of them such as transactions and cursors. Overall I would have no hesitation in recommending this book. It won't make you a SQL pro...but it will definitely make you more comfortable in common situations using this query language.

Perfect for beginners, 19 Apr 2008
This is the best book I have seen for people learning SQL from scratch. It takes you through the basics very quickly without assuming prior knowledge. Recommended for anyone with little or no prior SQL experience. You may want a basic SQL reference book to complement it.

You are better off with online tutorials, 27 Jan 2008
I recently wrote a simple database application for a hobby use. I have previous experience with SQL, but I wanted a handy reference to remind me of the basics. Time and time again I found this book useless, and resorted to an online search. I found the organisation of the book odd. If you want to create a simple application to learn with, you have to start from the back, as he tells you how to create a database and tables at the end.

Good Basic Introduction, 10 Dec 2007
This book is a great place to start for SQL. It tells you pretty much everything you are going to need to know for basic database usage. The later chapters on more advanced features such as triggers and stored procedures aren't massively useful as they don't go into enough depth but the author does say that they are only really intended to give you an idea of what you can do, not how to do it.

This book isn't going to teach you everything you need to know about SQL but it will give you the basics quickly and painlessly.


A great (if not simplistic) reference, 19 Jun 2007
This is a great reference for those starting out with SQL, or those just looking for a quick reference book to keep on their desks.

Don't be mistaken tho, it's by no means a complete reference, and doesn't cover any of the advanced SQL, but it's explanation of triggers, stored procedures, and transactions is a great reference to get around those mental syntax blocks

Not so easy to follow, 17 Sep 2008
I found this book is quite hard to follow. This is my very first SQL server book, and I was lost just in the first couple of the lessons. The author probably expected the readers to have a good knowledge about the system already, so there are not enough screen shots to guide you.

Plain English (not), 21 Aug 2008
This book is very dry and hard to read, some of the text is pure gobbledygook. It also assumes you have knowledge of some of the subjects it teaches. This is supposed to be a training course!

Is summary I wish I had spent my money on something else.


Not Impressed!!, 03 Mar 2008
Honestly - utter rubbish!!
There is several times ive read chapters and not known what the hell they are talking about. They do alot of 'Then all you have to do is close this' without actually telling you what the hell THIS is or wher to find it!!!!I'm already a dba on SQL Server 2000 so i though this would be a good top up!!! Ive gone back to googling the chapeters and reading up somewhere(anywhere) else....

It's an IT textbook, 29 Jan 2008
This is my first Microsoft Press textbook/training kit for an exam - and this is exactly what is focuses on - getting you through the exam.

It's very dry (and rather boring), and I much preferred reading the Wrox books Beginning SQL Server 2005 Administration, and then Professional SQL Server 2005 Administration (which appear to be comprehensive as well as being more readable).

Still, this book comes with a CD for 180 trial licence for SQL Server 2005 - and a Measure Up CD with exam simulation software.



Good training guide, poor as a reference book, 11 Sep 2006
These books have a tough expectation list as people want them to provide all they need to know to get through the associated examination and be a first class refernce book. The five-star rating applies to the former of these requirements as this is the market the book is aimed at. Having sat the examination I can say that all of the questions were answered in the book - and from previous exposure to these books that is not normally the case.

As a reference book it fails, simply because it is not intended as such and more obviously because to cover all the topics adequately it would have to be five times as long. That said, the section on Service Broker is way too vague - the knowledge it imparts will get you through the examination but will leave you floundering in the real world.

Use the book to pass the exam and to introduce you to the new technologies - look elsewhere for more in-depth practical (i.e real world) material.

[...]

Best text book for a first course in database, 02 Oct 2008
I first used this book alot (second edition) when I had to teach a course to HNC and HND students at South East Essex college in 1999. It it the main book I used to put together my notes

Generally an excellent text-book. It doesn't quite carry the clout or precision of C. J Dates book on database systems, but it is far more practical. Not only are the explanations simpler, but there are more practical examples. Also because it is a newer book it is a little more up-to date. The fact that it includes examples in ACCESS as well is an added bonus for teachers and students who have no choice but to use ACCESS.

Certainly the best text for students at the HNC/HND level.


Good student textbook maybe..., 18 Dec 2005
I'll keep this short and sweet: while this may be a good textbook to use when on a database course (and I mean one for full-time students who have yet to enter the world of work) this is definitively no use to those requiring a practical manual that will help you to solve a real-world problem or implement a real-world database solution. I don't think it strives to be the latter and doesn't stake a claim to be such a work but the point needs to be made to ensure people do not purchase it under the assumption that it is something that it certainly is not.
If you want a hands-on, useful SQL primer, go for Ben Forta's "SQL in 10 minutes", or for a practical how-to book on starting out in database creation, try out George Hepworth's "Grover Park George On Access": what they lack in terms of relational calculus (find this in "Database Systems"!) they make up for in teaching you stuff you can actually use. You'll also save yourself a lot of cash.

Very good course book, 08 Feb 2005
This book is well written and aimed at those with little or no prior knowledge of databases (e.g. undergraduates). It goes from conceptual design right down to low level topics. I think the main strength of this book lies in its excellent examples. There are several case studies which are used very well to show practical examples of concepts described. Would recommend it to anyone looking for a text book on databases.

Database Systems - a student's view, 10 Mar 2004
For the most part, I found this book excellent. The text explanations are clear, thorough and easy to follow, and I would thoroughly recommend it on this basis.

The exercises for the chapters, however, are very poorly written. One or two questions in each of the exercises we have encountered so far in my class have been essentially meaningless, so if you are a teacher looking to set this text for a course, beware! Make sure that you read through and correct any ambiguous questions before you set them for your students.

To give an example, one question asks the student to write a SQL query to calculate "the average number of bookings for each hotel in August." Not the average number of bookings per night for each hotel in August, or the average number of bookings in August across all hotels, but essentially a figure which is not actually an average. Rather annoying.

But if you won't be following the exercises slavishly, this book is otherwise worth every penny.

excellent for all levels of SQL, 26 Jun 2003
This book was the recommended title for my second year university SQL module. I used it a s a complete newbie to SQL and found it incredibly helpful both at a basic descriptional level as well as at advanced level as I progressed. Focus is well split between essential coceptual/logical design, normalisation etc as well as actual code syntax. Absolutely essential reference for anyone using or considering using SQL (includes DBMS specific instructions too for MS Access and Oracle for example as well).

Great little book, 12 Jun 2008
I bought this book because I am a programmer and need to interact with SQL on a daily basis. However...I do not want to know the fine grain details about database management systems. This is a great little book. It is very easy to read and met my needs perfectly. The samples are all easily achievable in 10 minutes, just like it says on the cover. This makes them very easy to scan over for a refresher when you are trying to work out a solution to a problem. It does not go into great details on the more advanced topics, however it does offer a primer on some of them such as transactions and cursors. Overall I would have no hesitation in recommending this book. It won't make you a SQL pro...but it will definitely make you more comfortable in common situations using this query language.

Perfect for beginners, 19 Apr 2008
This is the best book I have seen for people learning SQL from scratch. It takes you through the basics very quickly without assuming prior knowledge. Recommended for anyone with little or no prior SQL experience. You may want a basic SQL reference book to complement it.

You are better off with online tutorials, 27 Jan 2008
I recently wrote a simple database application for a hobby use. I have previous experience with SQL, but I wanted a handy reference to remind me of the basics. Time and time again I found this book useless, and resorted to an online search. I found the organisation of the book odd. If you want to create a simple application to learn with, you have to start from the back, as he tells you how to create a database and tables at the end.

Good Basic Introduction, 10 Dec 2007
This book is a great place to start for SQL. It tells you pretty much everything you are going to need to know for basic database usage. The later chapters on more advanced features such as triggers and stored procedures aren't massively useful as they don't go into enough depth but the author does say that they are only really intended to give you an idea of what you can do, not how to do it.

This book isn't going to teach you everything you need to know about SQL but it will give you the basics quickly and painlessly.


A great (if not simplistic) reference, 19 Jun 2007
This is a great reference for those starting out with SQL, or those just looking for a quick reference book to keep on their desks.

Don't be mistaken tho, it's by no means a complete reference, and doesn't cover any of the advanced SQL, but it's explanation of triggers, stored procedures, and transactions is a great reference to get around those mental syntax blocks

Not so easy to follow, 17 Sep 2008
I found this book is quite hard to follow. This is my very first SQL server book, and I was lost just in the first couple of the lessons. The author probably expected the readers to have a good knowledge about the system already, so there are not enough screen shots to guide you.

Plain English (not), 21 Aug 2008
This book is very dry and hard to read, some of the text is pure gobbledygook. It also assumes you have knowledge of some of the subjects it teaches. This is supposed to be a training course!

Is summary I wish I had spent my money on something else.


Not Impressed!!, 03 Mar 2008
Honestly - utter rubbish!!
There is several times ive read chapters and not known what the hell they are talking about. They do alot of 'Then all you have to do is close this' without actually telling you what the hell THIS is or wher to find it!!!!I'm already a dba on SQL Server 2000 so i though this would be a good top up!!! Ive gone back to googling the chapeters and reading up somewhere(anywhere) else....

It's an IT textbook, 29 Jan 2008
This is my first Microsoft Press textbook/training kit for an exam - and this is exactly what is focuses on - getting you through the exam.

It's very dry (and rather boring), and I much preferred reading the Wrox books Beginning SQL Server 2005 Administration, and then Professional SQL Server 2005 Administration (which appear to be comprehensive as well as being more readable).

Still, this book comes with a CD for 180 trial licence for SQL Server 2005 - and a Measure Up CD with exam simulation software.



Good training guide, poor as a reference book, 11 Sep 2006
These books have a tough expectation list as people want them to provide all they need to know to get through the associated examination and be a first class refernce book. The five-star rating applies to the former of these requirements as this is the market the book is aimed at. Having sat the examination I can say that all of the questions were answered in the book - and from previous exposure to these books that is not normally the case.

As a reference book it fails, simply because it is not intended as such and more obviously because to cover all the topics adequately it would have to be five times as long. That said, the section on Service Broker is way too vague - the knowledge it imparts will get you through the examination but will leave you floundering in the real world.

Use the book to pass the exam and to introduce you to the new technologies - look elsewhere for more in-depth practical (i.e real world) material.

[...]

Best text book for a first course in database, 02 Oct 2008
I first used this book alot (second edition) when I had to teach a course to HNC and HND students at South East Essex college in 1999. It it the main book I used to put together my notes

Generally an excellent text-book. It doesn't quite carry the clout or precision of C. J Dates book on database systems, but it is far more practical. Not only are the explanations simpler, but there are more practical examples. Also because it is a newer book it is a little more up-to date. The fact that it includes examples in ACCESS as well is an added bonus for teachers and students who have no choice but to use ACCESS.

Certainly the best text for students at the HNC/HND level.


Good student textbook maybe..., 18 Dec 2005
I'll keep this short and sweet: while this may be a good textbook to use when on a database course (and I mean one for full-time students who have yet to enter the world of work) this is definitively no use to those requiring a practical manual that will help you to solve a real-world problem or implement a real-world database solution. I don't think it strives to be the latter and doesn't stake a claim to be such a work but the point needs to be made to ensure people do not purchase it under the assumption that it is something that it certainly is not.
If you want a hands-on, useful SQL primer, go for Ben Forta's "SQL in 10 minutes", or for a practical how-to book on starting out in database creation, try out George Hepworth's "Grover Park George On Access": what they lack in terms of relational calculus (find this in "Database Systems"!) they make up for in teaching you stuff you can actually use. You'll also save yourself a lot of cash.

Very good course book, 08 Feb 2005
This book is well written and aimed at those with little or no prior knowledge of databases (e.g. undergraduates). It goes from conceptual design right down to low level topics. I think the main strength of this book lies in its excellent examples. There are several case studies which are used very well to show practical examples of concepts described. Would recommend it to anyone looking for a text book on databases.

Database Systems - a student's view, 10 Mar 2004
For the most part, I found this book excellent. The text explanations are clear, thorough and easy to follow, and I would thoroughly recommend it on this basis.

The exercises for the chapters, however, are very poorly written. One or two questions in each of the exercises we have encountered so far in my class have been essentially meaningless, so if you are a teacher looking to set this text for a course, beware! Make sure that you read through and correct any ambiguous questions before you set them for your students.

To give an example, one question asks the student to write a SQL query to calculate "the average number of bookings for each hotel in August." Not the average number of bookings per night for each hotel in August, or the average number of bookings in August across all hotels, but essentially a figure which is not actually an average. Rather annoying.

But if you won't be following the exercises slavishly, this book is otherwise worth every penny.

excellent for all levels of SQL, 26 Jun 2003
This book was the recommended title for my second year university SQL module. I used it a s a complete newbie to SQL and found it incredibly helpful both at a basic descriptional level as well as at advanced level as I progressed. Focus is well split between essential coceptual/logical design, normalisation etc as well as actual code syntax. Absolutely essential reference for anyone using or considering using SQL (includes DBMS specific instructions too for MS Access and Oracle for example as well).

A rare gem, 28 Oct 2008
I have a shelf full of "teach yourself books" all proclaiming to help me use the software featured on their covers. Not all are successful and some I have even given up on after a few pages. However not this book! Its clear teaching style make it a "must have" for anyone interested in expanding their knowledge of Access VBA.

As a teacher myself I know how difficult it can be to deliver information but the author has done this very successfully. The A4 size makes it possible to deliver a lesson on a double page spread; clear instructions and screenshots complement each other and the effective use of white space allow the reader to absorb the information without a struggle.

I look forward to some of the other titles planned in this series.


Absolute Must for Access Developers, 11 Oct 2008
Very occasionally I come across a book that is perfectly suited to my needs. This is one of those books. I have dabbled with Access in the past without fully understanding it and was looking for a book which would get me up to speed. I bought a number of recommended books and whilst they were OK they didn't do it for me. Mike Smart's book did. It is thoughtfully written to lead the reader through the steps required to gain an understanding of Access and apply that understanding to build well designed and constructed databases. I like the A4 layout, the pace and the Film database which you develop through the book is a perfect example, including as it does, most of the design issues which you might come across.

Although the title might lead you to believe that this is a book for those who can use Access and want to move on to using VBA it is more than that as it starts at quite a low level and would suit someone who knows a little, but not much about Access. Importantly, the book concentrates on good design methodology, including naming conventions. It's worth the price for the Rules Appendix alone.

So well done Mike Smart. More please. Authors of software books should learn from his example.

Excellent book, 17 Sep 2008
I bought this book and finished it in a few days - what an excellent book and method this is, very well worth the cost. I am a computer systems developer of some years standing - around about 20 to be truthful - and have to say this was one of the best books of software development I have read in all those years. I bought the book because I have been asked to write a system for a local charity and, though Access will produce basic systems very quickly, I want to produce an end-user application which is more intuitive, and specifically very easy, to use. This book and method have armed me with the facilities to do just that about I am naturally delighted, as I'm sure the users at the charity will be when the system is in place.

A small point to make - there are a few inconsistencies in the book, but basically these are pretty much trivia and probably very good exercises for readers to solve and be involved in the learning process, rather than anything problematic or remotely off-putting. Having said that, this really is a minor point and I will happily recommend this book and method to anyone who wants to make progress in MS Access.

worth to purchase, 20 Apr 2008
I found this book very useful. It is easy and have well written for beginners and also include standard rules for advanced developers. However there are few things which i didn't like about this book. 1. Book is in A4 format 2. Book cover isn't good for rough use. 3. Not many self learning exercises.
Also it is the only book of such kind avaialble in market.

A great way to learn Access VBA, 17 Dec 2007
This book has really helped me get my database completed. I was stuck with macros that weren't working / not doing what I wanted them to do, and after consulting the online news groups it was recommended by several that I learn Access VBA. I had no previous experience of Access VBA at all (but had fairly good knowledge of Access).

The way the book is set out made it really easy to pick up VBA and the exercises at the end of each chapter are very helpful. Also the general Access tips are very helpful too.

I went through the whole book in under 4 days, so if you want to learn Access VBA easily and quickly I wholeheartedly recommend this book. Hats off to Mike Smart.

Great little book, 12 Jun 2008
I bought this book because I am a programmer and need to interact with SQL on a daily basis. However...I do not want to know the fine grain details about database management systems. This is a great little book. It is very easy to read and met my needs perfectly. The samples are all easily achievable in 10 minutes, just like it says on the cover. This makes them very easy to scan over for a refresher when you are trying to work out a solution to a problem. It does not go into great details on the more advanced topics, however it does offer a primer on some of them such as transactions and cursors. Overall I would have no hesitation in recommending this book. It won't make you a SQL pro...but it will definitely make you more comfortable in common situations using this query language.

Perfect for beginners, 19 Apr 2008
This is the best book I have seen for people learning SQL from scratch. It takes you through the basics very quickly without assuming prior knowledge. Recommended for anyone with little or no prior SQL experience. You may want a basic SQL reference book to complement it.

You are better off with online tutorials, 27 Jan 2008
I recently wrote a simple database application for a hobby use. I have previous experience with SQL, but I wanted a handy reference to remind me of the basics. Time and time again I found this book useless, and resorted to an online search. I found the organisation of the book odd. If you want to create a simple application to learn with, you have to start from the back, as he tells you how to create a database and tables at the end.

Good Basic Introduction, 10 Dec 2007
This book is a great place to start for SQL. It tells you pretty much everything you are going to need to know for basic database usage. The later chapters on more advanced features such as triggers and stored procedures aren't massively useful as they don't go into enough depth but the author does say that they are only really intended to give you an idea of what you can do, not how to do it.

This book isn't going to teach you everything you need to know about SQL but it will give you the basics quickly and painlessly.


A great (if not simplistic) reference, 19 Jun 2007
This is a great reference for those starting out with SQL, or those just looking for a quick reference book to keep on their desks.

Don't be mistaken tho, it's by no means a complete reference, and doesn't cover any of the advanced SQL, but it's explanation of triggers, stored procedures, and transactions is a great reference to get around those mental syntax blocks

Not so easy to follow, 17 Sep 2008
I found this book is quite hard to follow. This is my very first SQL server book, and I was lost just in the first couple of the lessons. The author probably expected the readers to have a good knowledge about the system already, so there are not enough screen shots to guide you.

Plain English (not), 21 Aug 2008
This book is very dry and hard to read, some of the text is pure gobbledygook. It also assumes you have knowledge of some of the subjects it teaches. This is supposed to be a training course!

Is summary I wish I had spent my money on something else.


Not Impressed!!, 03 Mar 2008
Honestly - utter rubbish!!
There is several times ive read chapters and not known what the hell they are talking about. They do alot of 'Then all you have to do is close this' without actually telling you what the hell THIS is or wher to find it!!!!I'm already a dba on SQL Server 2000 so i though this would be a good top up!!! Ive gone back to googling the chapeters and reading up somewhere(anywhere) else....

It's an IT textbook, 29 Jan 2008
This is my first Microsoft Press textbook/training kit for an exam - and this is exactly what is focuses on - getting you through the exam.

It's very dry (and rather boring), and I much preferred reading the Wrox books Beginning SQL Server 2005 Administration, and then Professional SQL Server 2005 Administration (which appear to be comprehensive as well as being more readable).

Still, this book comes with a CD for 180 trial licence for SQL Server 2005 - and a Measure Up CD with exam simulation software.



Good training guide, poor as a reference book, 11 Sep 2006
These books have a tough expectation list as people want them to provide all they need to know to get through the associated examination and be a first class refernce book. The five-star rating applies to the former of these requirements as this is the market the book is aimed at. Having sat the examination I can say that all of the questions were answered in the book - and from previous exposure to these books that is not normally the case.

As a reference book it fails, simply because it is not intended as such and more obviously because to cover all the topics adequately it would have to be five times as long. That said, the section on Service Broker is way too vague - the knowledge it imparts will get you through the examination but will leave you floundering in the real world.

Use the book to pass the exam and to introduce you to the new technologies - look elsewhere for more in-depth practical (i.e real world) material.

[...]

Best text book for a first course in database, 02 Oct 2008
I first used this book alot (second edition) when I had to teach a course to HNC and HND students at South East Essex college in 1999. It it the main book I used to put together my notes

Generally an excellent text-book. It doesn't quite carry the clout or precision of C. J Dates book on database systems, but it is far more practical. Not only are the explanations simpler, but there are more practical examples. Also because it is a newer book it is a little more up-to date. The fact that it includes examples in ACCESS as well is an added bonus for teachers and students who have no choice but to use ACCESS.

Certainly the best text for students at the HNC/HND level.


Good student textbook maybe..., 18 Dec 2005
I'll keep this short and sweet: while this may be a good textbook to use when on a database course (and I mean one for full-time students who have yet to enter the world of work) this is definitively no use to those requiring a practical manual that will help you to solve a real-world problem or implement a real-world database solution. I don't think it strives to be the latter and doesn't stake a claim to be such a work but the point needs to be made to ensure people do not purchase it under the assumption that it is something that it certainly is not.
If you want a hands-on, useful SQL primer, go for Ben Forta's "SQL in 10 minutes", or for a practical how-to book on starting out in database creation, try out George Hepworth's "Grover Park George On Access": what they lack in terms of relational calculus (find this in "Database Systems"!) they make up for in teaching you stuff you can actually use. You'll also save yourself a lot of cash.

Very good course book, 08 Feb 2005
This book is well written and aimed at those with little or no prior knowledge of databases (e.g. undergraduates). It goes from conceptual design right down to low level topics. I think the main strength of this book lies in its excellent examples. There are several case studies which are used very well to show practical examples of concepts described. Would recommend it to anyone looking for a text book on databases.

Database Systems - a student's view, 10 Mar 2004
For the most part, I found this book excellent. The text explanations are clear, thorough and easy to follow, and I would thoroughly recommend it on this basis.

The exercises for the chapters, however, are very poorly written. One or two questions in each of the exercises we have encountered so far in my class have been essentially meaningless, so if you are a teacher looking to set this text for a course, beware! Make sure that you read through and correct any ambiguous questions before you set them for your students.

To give an example, one question asks the student to write a SQL query to calculate "the average number of bookings for each hotel in August." Not the average number of bookings per night for each hotel in August, or the average number of bookings in August across all hotels, but essentially a figure which is not actually an average. Rather annoying.

But if you won't be following the exercises slavishly, this book is otherwise worth every penny.

excellent for all levels of SQL, 26 Jun 2003
This book was the recommended title for my second year university SQL module. I used it a s a complete newbie to SQL and found it incredibly helpful both at a basic descriptional level as well as at advanced level as I progressed. Focus is well split between essential coceptual/logical design, normalisation etc as well as actual code syntax. Absolutely essential reference for anyone using or considering using SQL (includes DBMS specific instructions too for MS Access and Oracle for example as well).

A rare gem, 28 Oct 2008
I have a shelf full of "teach yourself books" all proclaiming to help me use the software featured on their covers. Not all are successful and some I have even given up on after a few pages. However not this book! Its clear teaching style make it a "must have" for anyone interested in expanding their knowledge of Access VBA.

As a teacher myself I know how difficult it can be to deliver information but the author has done this very successfully. The A4 size makes it possible to deliver a lesson on a double page spread; clear instructions and screenshots complement each other and the effective use of white space allow the reader to absorb the information without a struggle.

I look forward to some of the other titles planned in this series.


Absolute Must for Access Developers, 11 Oct 2008
Very occasionally I come across a book that is perfectly suited to my needs. This is one of those books. I have dabbled with Access in the past without fully understanding it and was looking for a book which would get me up to speed. I bought a number of recommended books and whilst they were OK they didn't do it for me. Mike Smart's book did. It is thoughtfully written to lead the reader through the steps required to gain an understanding of Access and apply that understanding to build well designed and constructed databases. I like the A4 layout, the pace and the Film database which you develop through the book is a perfect example, including as it does, most of the design issues which you might come across.

Although the title might lead you to believe that this is a book for those who can use Access and want to move on to using VBA it is more than that as it starts at quite a low level and would suit someone who knows a little, but not much about Access. Importantly, the book concentrates on good design methodology, including naming conventions. It's worth the price for the Rules Appendix alone.

So well done Mike Smart. More please. Authors of software books should learn from his example.

Excellent book, 17 Sep 2008
I bought this book and finished it in a few days - what an excellent book and method this is, very well worth the cost. I am a computer systems developer of some years standing - around about 20 to be truthful - and have to say this was one of the best books of software development I have read in all those years. I bought the book because I have been asked to write a system for a local charity and, though Access will produce basic systems very quickly, I want to produce an end-user application which is more intuitive, and specifically very easy, to use. This book and method have armed me with the facilities to do just that about I am naturally delighted, as I'm sure the users at the charity will be when the system is in place.

A small point to make - there are a few inconsistencies in the book, but basically these are pretty much trivia and probably very good exercises for readers to solve and be involved in the learning process, rather than anything problematic or remotely off-putting. Having said that, this really is a minor point and I will happily recommend this book and method to anyone who wants to make progress in MS Access.

worth to purchase, 20 Apr 2008
I found this book very useful. It is easy and have well written for beginners and also include standard rules for advanced developers. However there are few things which i didn't like about this book. 1. Book is in A4 format 2. Book cover isn't good for rough use. 3. Not many self learning exercises.
Also it is the only book of such kind avaialble in market.

A great way to learn Access VBA, 17 Dec 2007
This book has really helped me get my database completed. I was stuck with macros that weren't working / not doing what I wanted them to do, and after consulting the online news groups it was recommended by several that I learn Access VBA. I had no previous experience of Access VBA at all (but had fairly good knowledge of Access).

The way the book is set out made it really easy to pick up VBA and the exercises at the end of each chapter are very helpful. Also the general Access tips are very helpful too.

I went through the whole book in under 4 days, so if you want to learn Access VBA easily and quickly I wholeheartedly recommend this book. Hats off to Mike Smart.

Covered all the questions, 26 Jul 2008
Used the Oracle Press SQL Exam Guide (Ramklass/Watson) and DBA Exam Guide (Watson) to take the beta exams, you get about 200 questions in three hours for the beta exams, and you don't get the result for a few weeks. I'm pretty sure I passed though, the books covered every question.

Great little book, 12 Jun 2008
I bought this book because I am a programmer and need to interact with SQL on a daily basis. However...I do not want to know the fine grain details about database management systems. This is a great little book. It is very easy to read and met my needs perfectly. The samples are all easily achievable in 10 minutes, just like it says on the cover. This makes them very easy to scan over for a refresher when you are trying to work out a solution to a problem. It does not go into great details on the more advanced topics, however it does offer a primer on some of them such as transactions and cursors. Overall I would have no hesitation in recommending this book. It won't make you a SQL pro...but it will definitely make you more comfortable in common situations using this query language.

Perfect for beginners, 19 Apr 2008
This is the best book I have seen for people learning SQL from scratch. It takes you through the basics very quickly without assuming prior knowledge. Recommended for anyone with little or no prior SQL experience. You may want a basic SQL reference book to complement it.

You are better off with online tutorials, 27 Jan 2008
I recently wrote a simple database application for a hobby use. I have previous experience with SQL, but I wanted a handy reference to remind me of the basics. Time and time again I found this book useless, and resorted to an online search. I found the organisation of the book odd. If you want to create a simple application to learn with, you have to start from the back, as he tells you how to create a database and tables at the end.

Good Basic Introduction, 10 Dec 2007
This book is a great place to start for SQL. It tells you pretty much everything you are going to need to know for basic database usage. The later chapters on more advanced features such as triggers and stored procedures aren't massively useful as they don't go into enough depth but the author does say that they are only really intended to give you an idea of what you can do, not how to do it.

This book isn't going to teach you everything you need to know about SQL but it will give you the basics quickly and painlessly.


A great (if not simplistic) reference, 19 Jun 2007
This is a great reference for those starting out with SQL, or those just looking for a quick reference book to keep on their desks.

Don't be mistaken tho, it's by no means a complete reference, and doesn't cover any of the advanced SQL, but it's explanation of triggers, stored procedures, and transactions is a great reference to get around those mental syntax blocks

Not so easy to follow, 17 Sep 2008
I found this book is quite hard to follow. This is my very first SQL server book, and I was lost just in the first couple of the lessons. The author probably expected the readers to have a good knowledge about the system already, so there are not enough screen shots to guide you.

Plain English (not), 21 Aug 2008
This book is very dry and hard to read, some of the text is pure gobbledygook. It also assumes you have knowledge of some of the subjects it teaches. This is supposed to be a training course!

Is summary I wish I had spent my money on something else.


Not Impressed!!, 03 Mar 2008
Honestly - utter rubbish!!
There is several times ive read chapters and not known what the hell they are talking about. They do alot of 'Then all you have to do is close this' without actually telling you what the hell THIS is or wher to find it!!!!I'm already a dba on SQL Server 2000 so i though this would be a good top up!!! Ive gone back to googling the chapeters and reading up somewhere(anywhere) else....

It's an IT textbook, 29 Jan 2008
This is my first Microsoft Press textbook/training kit for an exam - and this is exactly what is focuses on - getting you through the exam.

It's very dry (and rather boring), and I much preferred reading the Wrox books Beginning SQL Server 2005 Administration, and then Professional SQL Server 2005 Administration (which appear to be comprehensive as well as being more readable).

Still, this book comes with a CD for 180 trial licence for SQL Server 2005 - and a Measure Up CD with exam simulation software.



Good training guide, poor as a reference book, 11 Sep 2006
These books have a tough expectation list as people want them to provide all they need to know to get through the associated examination and be a first class refernce book. The five-star rating applies to the former of these requirements as this is the market the book is aimed at. Having sat the examination I can say that all of the questions were answered in the book - and from previous exposure to these books that is not normally the case.

As a reference book it fails, simply because it is not intended as such and more obviously because to cover all the topics adequately it would have to be five times as long. That said, the section on Service Broker is way too vague - the knowledge it imparts will get you through the examination but will leave you floundering in the real world.

Use the book to pass the exam and to introduce you to the new technologies - look elsewhere for more in-depth practical (i.e real world) material.

[...]

Best text book for a first course in database, 02 Oct 2008
I first used this book alot (second edition) when I had to teach a course to HNC and HND students at South East Essex college in 1999. It it the main book I used to put together my notes

Generally an excellent text-book. It doesn't quite carry the clout or precision of C. J Dates book on database systems, but it is far more practical. Not only are the explanations simpler, but there are more practical examples. Also because it is a newer book it is a little more up-to date. The fact that it includes examples in ACCESS as well is an added bonus for teachers and students who have no choice but to use ACCESS.

Certainly the best text for students at the HNC/HND level.


Good student textbook maybe..., 18 Dec 2005
I'll keep this short and sweet: while this may be a good textbook to use when on a database course (and I mean one for full-time students who have yet to enter the world of work) this is definitively no use to those requiring a practical manual that will help you to solve a real-world problem or implement a real-world database solution. I don't think it strives to be the latter and doesn't stake a claim to be such a work but the point needs to be made to ensure people do not purchase it under the assumption that it is something that it certainly is not.
If you want a hands-on, useful SQL primer, go for Ben Forta's "SQL in 10 minutes", or for a practical how-to book on starting out in database creation, try out George Hepworth's "Grover Park George On Access": what they lack in terms of relational calculus (find this in "Database Systems"!) they make up for in teaching you stuff you can actually use. You'll also save yourself a lot of cash.

Very good course book, 08 Feb 2005
This book is well written and aimed at those with little or no prior knowledge of databases (e.g. undergraduates). It goes from conceptual design right down to low level topics. I think the main strength of this book lies in its excellent examples. There are several case studies which are used very well to show practical examples of concepts described. Would recommend it to anyone looking for a text book on databases.

Database Systems - a student's view, 10 Mar 2004
For the most part, I found this book excellent. The text explanations are clear, thorough and easy to follow, and I would thoroughly recommend it on this basis.

The exercises for the chapters, however, are very poorly written. One or two questions in each of the exercises we have encountered so far in my class have been essentially meaningless, so if you are a teacher looking to set this text for a course, beware! Make sure that you read through and correct any ambiguous questions before you set them for your students.

To give an example, one question asks the student to write a SQL query to calculate "the average number of bookings for each hotel in August." Not the average number of bookings per night for each hotel in August, or the average number of bookings in August across all hotels, but essentially a figure which is not actually an average. Rather annoying.

But if you won't be following the exercises slavishly, this book is otherwise worth every penny.

excellent for all levels of SQL, 26 Jun 2003
This book was the recommended title for my second year university SQL module. I used it a s a complete newbie to SQL and found it incredibly helpful both at a basic descriptional level as well as at advanced level as I progressed. Focus is well split between essential coceptual/logical design, normalisation etc as well as actual code syntax. Absolutely essential reference for anyone using or considering using SQL (includes DBMS specific instructions too for MS Access and Oracle for example as well).

A rare gem, 28 Oct 2008
I have a shelf full of "teach yourself books" all proclaiming to help me use the software featured on their covers. Not all are successful and some I have even given up on after a few pages. However not this book! Its clear teaching style make it a "must have" for anyone interested in expanding their knowledge of Access VBA.

As a teacher myself I know how difficult it can be to deliver information but the author has done this very successfully. The A4 size makes it possible to deliver a lesson on a double page spread; clear instructions and screenshots complement each other and the effective use of white space allow the reader to absorb the information without a struggle.

I look forward to some of the other titles planned in this series.


Absolute Must for Access Developers, 11 Oct 2008
Very occasionally I come across a book that is perfectly suited to my needs. This is one of those books. I have dabbled with Access in the past without fully understanding it and was looking for a book which would get me up to speed. I bought a number of recommended books and whilst they were OK they didn't do it for me. Mike Smart's book did. It is thoughtfully written to lead the reader through the steps required to gain an understanding of Access and apply that understanding to build well designed and constructed databases. I like the A4 layout, the pace and the Film database which you develop through the book is a perfect example, including as it does, most of the design issues which you might come across.

Although the title might lead you to believe that this is a book for those who can use Access and want to move on to using VBA it is more than that as it starts at quite a low level and would suit someone who knows a little, but not much about Access. Importantly, the book concentrates on good design methodology, including naming conventions. It's worth the price for the Rules Appendix alone.

So well done Mike Smart. More please. Authors of software books should learn from his example.

Excellent book, 17 Sep 2008
I bought this book and finished it in a few days - what an excellent book and method this is, very well worth the cost. I am a computer systems developer of some years standing - around about 20 to be truthful - and have to say this was one of the best books of software development I have read in all those years. I bought the book because I have been asked to write a system for a local charity and, though Access will produce basic systems very quickly, I want to produce an end-user application which is more intuitive, and specifically very easy, to use. This book and method have armed me with the facilities to do just that about I am naturally delighted, as I'm sure the users at the charity will be when the system is in place.

A small point to make - there are a few inconsistencies in the book, but basically these are pretty much trivia and probably very good exercises for readers to solve and be involved in the learning process, rather than anything problematic or remotely off-putting. Having said that, this really is a minor point and I will happily recommend this book and method to anyone who wants to make progress in MS Access.

worth to purchase, 20 Apr 2008
I found this book very useful. It is easy and have well written for beginners and also include standard rules for advanced developers. However there are few things which i didn't like about this book. 1. Book is in A4 format 2. Book cover isn't good for rough use. 3. Not many self learning exercises.
Also it is the only book of such kind avaialble in market.

A great way to learn Access VBA, 17 Dec 2007
This book has really helped me get my database completed. I was stuck with macros that weren't working / not doing what I wanted them to do, and after consulting the online news groups it was recommended by several that I learn Access VBA. I had no previous experience of Access VBA at all (but had fairly good knowledge of Access).

The way the book is set out made it really easy to pick up VBA and the exercises at the end of each chapter are very helpful. Also the general Access tips are very helpful too.

I went through the whole book in under 4 days, so if you want to learn Access VBA easily and quickly I wholeheartedly recommend this book. Hats off to Mike Smart.

Covered all the questions, 26 Jul 2008
Used the Oracle Press SQL Exam Guide (Ramklass/Watson) and DBA Exam Guide (Watson) to take the beta exams, you get about 200 questions in three hours for the beta exams, and you don't get the result for a few weeks. I'm pretty sure I passed though, the books covered every question.

A must for master's students., 11 Aug 2008
I cannot tell you how pleased (and relieved) I am to have found a book like this! It is a god-send and this author deserves a medal. This is a must-have handbook for anyone undergoing a masters dissertation. I recently recommended it to a friend and it now sits in prime position on her desk.

Until I found this book, I knew what I wanted to achieve and was progressing with it. However, I lacked confidence in my approach and worried over certain areas of my work; this was certainly reflected in my writing at times.

This book is a step-by-step approach. It is structured from stage one of the dissertation proposal and takes you through each of the chapters as should be seen in your dissertation: introduction, literature review, methodology, findings, conclusion etc. Each of these chapters are then broken down into sub-sections, which should actually appear as sub-sections in your dissertation. Thus, for example, Biggam says that your introduction must include 'Background', 'Research Focus', 'Aims and Objectives', and 'Value of the Research'. The introduction chapter is therefore split up into these sub-sections and explained: Biggam indicates what kind of information is needed in these sub-sections and what the marker will expect to find.

In addition, throughout the book, the author has given little 'tip' bubbles, which indicate common mistakes by students. He also recommends students should use certain phrases. For example, in your objectives, begin with 'To identify...' and then, to indicate a sense of in-depth research, the next objectives could be 'To assess...; To examine...' etc. The appendices are also very useful.

Now, some may think that this makes the book appear very basic and maybe even 'spoon feed' the student; after all, the dissertation is about a your own research and learning.

My response is that this book doesn't do that. Yes, at times, it is common sense, but the excellent thing about the book is that it is not patronising at all. It simply tells you what you should be looking to achieve. Essentially, it paves the way for you to go smoothly through the stages of the investigation from beginning to end. As it informs you about what your dissertation should include, it ensures you remain focused on research aims/objectives.

Moreover, I was more than half way through writing up my study when I came across this book, and it's bolstered my confidence no end. It highlighted areas where I have done what's expected, but equally shown me areas where I would likely fall down on marks. For example, although I had tried to maintain a connection throughout my study, I was very concerned because it was a weak connection. This book has helped me identify how I can make the links stronger from chapter to chapter. Importantly, having learnt those one or two elements, I am now doing more effective links in my work automatically, without further reference to the book.

I have no idea how I will do on my dissertation, but I genuinely feel that this book has maybe increased my marks by at least 5 per cent.

Even if you are reluctant to spend the money, I strongly recommend that you find a copy in a library to look at. I know for a fact that in the future, if anyone needs help with a masters dissertation, I would be sending them to this book.

Great little book, 12 Jun 2008
I bought this book because I am a programmer and need to interact with SQL on a daily basis. However...I do not want to know the fine grain details about database management systems. This is a great little book. It is very easy to read and met my needs perfectly. The samples are all easily achievable in 10 minutes, just like it says on the cover. This makes them very easy to scan over for a refresher when you are trying to work out a solution to a problem. It does not go into great details on the more advanced topics, however it does offer a primer on some of them such as transactions and cursors. Overall I would have no hesitation in recommending this book. It won't make you a SQL pro...but it will definitely make you more comfortable in common situations using this query language.

Perfect for beginners, 19 Apr 2008
This is the best book I have seen for people learning SQL from scratch. It takes you through the basics very quickly without assuming prior knowledge. Recommended for anyone with little or no prior SQL experience. You may want a basic SQL reference book to complement it.

You are better off with online tutorials, 27 Jan 2008
I recently wrote a simple database application for a hobby use. I have previous experience with SQL, but I wanted a handy reference to remind me of the basics. Time and time again I found this book useless, and resorted to an online search. I found the organisation of the book odd. If you want to create a simple application to learn with, you have to start from the back, as he tells you how to create a database and tables at the end.

Good Basic Introduction, 10 Dec 2007
This book is a great place to start for SQL. It tells you pretty much everything you are going to need to know for basic database usage. The later chapters on more advanced features such as triggers and stored procedures aren't massively useful as they don't go into enough depth but the author does say that they are only really intended to give you an idea of what you can do, not how to do it.

This book isn't going to teach you everything you need to know about SQL but it will give you the basics quickly and painlessly.


A great (if not simplistic) reference, 19 Jun 2007
This is a great reference for those starting out with SQL, or those just looking for a quick reference book to keep on their desks.

Don't be mistaken tho, it's by no means a complete reference, and doesn't cover any of the advanced SQL, but it's explanation of triggers, stored procedures, and transactions is a great reference to get around those mental syntax blocks

Not so easy to follow, 17 Sep 2008
I found this book is quite hard to follow. This is my very first SQL server book, and I was lost just in the first couple of the lessons. The author probably expected the readers to have a good knowledge about the system already, so there are not enough screen shots to guide you.

Plain English (not), 21 Aug 2008
This book is very dry and hard to read, some of the text is pure gobbledygook. It also assumes you have knowledge of some of the subjects it teaches. This is supposed to be a training course!

Is summary I wish I had spent my money on something else.


Not Impressed!!, 03 Mar 2008
Honestly - utter rubbish!!
There is several times ive read chapters and not known what the hell they are talking about. They do alot of 'Then all you have to do is close this' without actually telling you what the hell THIS is or wher to find it!!!!I'm already a dba on SQL Server 2000 so i though this would be a good top up!!! Ive gone back to googling the chapeters and reading up somewhere(anywhere) else....

It's an IT textbook, 29 Jan 2008
This is my first Microsoft Press textbook/training kit for an exam - and this is exactly what is focuses on - getting you through the exam.

It's very dry (and rather boring), and I much preferred reading the Wrox books Beginning SQL Server 2005 Administration, and then Professional SQL Server 2005 Administration (which appear to be comprehensive as well as being more readable).

Still, this book comes with a CD for 180 trial licence for SQL Server 2005 - and a Measure Up CD with exam simulation software.



Good training guide, poor as a reference book, 11 Sep 2006
These books have a tough expectation list as people want them to provide all they need to know to get through the associated examination and be a first class refernce book. The five-star rating applies to the former of these requirements as this is the market the book is aimed at. Having sat the examination I can say that all of the questions were answered in the book - and from previous exposure to these books that is not normally the case.

As a reference book it fails, simply because it is not intended as such and more obviously because to cover all the topics adequately it would have to be five times as long. That said, the section on Service Broker is way too vague - the knowledge it imparts will get you through the examination but will leave you floundering in the real world.

Use the book to pass the exam and to introduce you to the new technologies - look elsewhere for more in-depth practical (i.e real world) material.

[...]

Best text book for a first course in database, 02 Oct 2008
I first used this book alot (second edition) when I had to teach a course to HNC and HND students at South East Essex college in 1999. It it the main book I used to put together my notes

Generally an excellent text-book. It doesn't quite carry the clout or precision of C. J Dates book on database systems, but it is far more practical. Not only are the explanations simpler, but there are more practical examples. Also because it is a newer book it is a little more up-to date. The fact that it includes examples in ACCESS as well is an added bonus for teachers and students who have no choice but to use ACCESS.

Certainly the best text for students at the HNC/HND level.


Good student textbook maybe..., 18 Dec 2005
I'll keep this short and sweet: while this may be a good textbook to use when on a database course (and I mean one for full-time students who have yet to enter the world of work) this is definitively no use to those requiring a practical manual that will help you to solve a real-world problem or implement a real-world database solution. I don't think it strives to be the latter and doesn't stake a claim to be such a work but the point needs to be made to ensure people do not purchase it under the assumption that it is something that it certainly is not.
If you want a hands-on, useful SQL primer, go for Ben Forta's "SQL in 10 minutes", or for a practical how-to book on starting out in database creation, try out George Hepworth's "Grover Park George On Access": what they lack in terms of relational calculus (find this in "Database Systems"!) they make up for in teaching you stuff you can actually use. You'll also save yourself a lot of cash.

Very good course book, 08 Feb 2005
This book is well written and aimed at those with little or no prior knowledge of databases (e.g. undergraduates). It goes from conceptual design right down to low level topics. I think the main strength of this book lies in its excellent examples. There are several case studies which are used very well to show practical examples of concepts described. Would recommend it to anyone looking for a text book on databases.

Database Systems - a student's view, 10 Mar 2004
For the most part, I found this book excellent. The text explanations are clear, thorough and easy to follow, and I would thoroughly recommend it on this basis.

The exercises for the chapters, however, are very poorly written. One or two questions in each of the exercises we have encountered so far in my class have been essentially meaningless, so if you are a teacher looking to set this text for a course, beware! Make sure that you read through and correct any ambiguous questions before you set them for your students.

To give an example, one question asks the student to write a SQL query to calculate "the average number of bookings for each hotel in August." Not the average number of bookings per night for each hotel in August, or the average number of bookings in August across all hotels, but essentially a figure which is not actually an average. Rather annoying.

But if you won't be following the exercises slavishly, this book is otherwise worth every penny.

excellent for all levels of SQL, 26 Jun 2003
This book was the recommended title for my second year university SQL module. I used it a s a complete newbie to SQL and found it incredibly helpful both at a basic descriptional level as well as at advanced level as I progressed. Focus is well split between essential coceptual/logical design, normalisation etc as well as actual code syntax. Absolutely essential reference for anyone using or considering using SQL (includes DBMS specific instructions too for MS Access and Oracle for example as well).

A rare gem, 28 Oct 2008
I have a shelf full of "teach yourself books" all proclaiming to help me use the software featured on their covers. Not all are successful and some I have even given up on after a few pages. However not this book! Its clear teaching style make it a "must have" for anyone interested in expanding their knowledge of Access VBA.

As a teacher myself I know how difficult it can be to deliver information but the author has done this very successfully. The A4 size makes it possible to deliver a lesson on a double page spread; clear instructions and screenshots complement each other and the effective use of white space allow the reader to absorb the information without a struggle.

I look forward to some of the other titles planned in this series.


Absolute Must for Access Developers, 11 Oct 2008
Very occasionally I come across a book that is perfectly suited to my needs. This is one of those books. I have dabbled with Access in the past without fully understanding it and was looking for a book which would get me up to speed. I bought a number of recommended books and whilst they were OK they didn't do it for me. Mike Smart's book did. It is thoughtfully written to lead the reader through the steps required to gain an understanding of Access and apply that understanding to build well designed and constructed databases. I like the A4 layout, the pace and the Film database which you develop through the book is a perfect example, including as it does, most of the design issues which you might come across.

Although the title might lead you to believe that this is a book for those who can use Access and want to move on to using VBA it is more than that as it starts at quite a low level and would suit someone who knows a little, but not much about Access. Importantly, the book concentrates on good design methodology, including naming conventions. It's worth the price for the Rules Appendix alone.

So well done Mike Smart. More please. Authors of software books should learn from his example.

Excellent book, 17 Sep 2008
I bought this book and finished it in a few days - what an excellent book and method this is, very well worth the cost. I am a computer systems developer of some years standing - around about 20 to be truthful - and have to say this was one of the best books of software development I have read in all those years. I bought the book because I have been asked to write a system for a local charity and, though Access will produce basic systems very quickly, I want to produce an end-user application which is more intuitive, and specifically very easy, to use. This book and method have armed me with the facilities to do just that about I am naturally delighted, as I'm sure the users at the charity will be when the system is in place.

A small point to make - there are a few inconsistencies in the book, but basically these are pretty much trivia and probably very good exercises for readers to solve and be involved in the learning process, rather than anything problematic or remotely off-putting. Having said that, this really is a minor point and I will happily recommend this book and method to anyone who wants to make progress in MS Access.

worth to purchase, 20 Apr 2008
I found this book very useful. It is easy and have well written for beginners and also include standard rules for advanced developers. However there are few things which i didn't like about this book. 1. Book is in A4 format 2. Book cover isn't good for rough use. 3. Not many self learning exercises.
Also it is the only book of such kind avaialble in market.

A great way to learn Access VBA, 17 Dec 2007
This book has really helped me get my database completed. I was stuck with macros that weren't working / not doing what I wanted them to do, and after consulting the online news groups it was recommended by several that I learn Access VBA. I had no previous experience of Access VBA at all (but had fairly good knowledge of Access).

The way the book is set out made it really easy to pick up VBA and the exercises at the end of each chapter are very helpful. Also the general Access tips are very helpful too.

I went through the whole book in under 4 days, so if you want to learn Access VBA easily and quickly I wholeheartedly recommend this book. Hats off to Mike Smart.

Covered all the questions, 26 Jul 2008
Used the Oracle Press SQL Exam Guide (Ramklass/Watson) and DBA Exam Guide (Watson) to take the beta exams, you get about 200 questions in three hours for the beta exams, and you don't get the result for a few weeks. I'm pretty sure I passed though, the books covered every question.

A must for master's students., 11 Aug 2008
I cannot tell you how pleased (and relieved) I am to have found a book like this! It is a god-send and this author deserves a medal. This is a must-have handbook for anyone undergoing a masters dissertation. I recently recommended it to a friend and it now sits in prime position on her desk.

Until I found this book, I knew what I wanted to achieve and was progressing with it. However, I lacked confidence in my approach and worried over certain areas of my work; this was certainly reflected in my writing at times.

This book is a step-by-step approach. It is structured from stage one of the dissertation proposal and takes you through each of the chapters as should be seen in your dissertation: introduction, literature review, methodology, findings, conclusion etc. Each of these chapters are then broken down into sub-sections, which should actually appear as sub-sections in your dissertation. Thus, for example, Biggam says that your introduction must include 'Background', 'Research Focus', 'Aims and Objectives', and 'Value of the Research'. The introduction chapter is therefore split up into these sub-sections and explained: Biggam indicates what kind of information is needed in these sub-sections and what the marker will expect to find.

In addition, throughout the book, the author has given little 'tip' bubbles, which indicate common mistakes by students. He also recommends students should use certain phrases. For example, in your objectives, begin with 'To identify...' and then, to indicate a sense of in-depth research, the next objectives could be 'To assess...; To examine...' etc. The appendices are also very useful.

Now, some may think that this makes the book appear very basic and maybe even 'spoon feed' the student; after all, the dissertation is about a your own research and learning.

My response is that this book doesn't do that. Yes, at times, it is common sense, but the excellent thing about the book is that it is not patronising at all. It simply tells you what you should be looking to achieve. Essentially, it paves the way for you to go smoothly through the stages of the investigation from beginning to end. As it informs you about what your dissertation should include, it ensures you remain focused on research aims/objectives.

Moreover, I was more than half way through writing up my study when I came across this book, and it's bolstered my confidence no end. It highlighted areas where I have done what's expected, but equally shown me areas where I would likely fall down on marks. For example, although I had tried to maintain a connection throughout my study, I was very concerned because it was a weak connection. This book has helped me identify how I can make the links stronger from chapter to chapter. Importantly, having learnt those one or two elements, I am now doing more effective links in my work automatically, without further reference to the book.

I have no idea how I will do on my dissertation, but I genuinely feel that this book has maybe increased my marks by at least 5 per cent.

Even if you are reluctant to spend the money, I strongly recommend that you find a copy in a library to look at. I know for a fact that in the future, if anyone needs help with a masters dissertation, I would be sending them to this book.


Apex Essential Reading, 22 Sep 2008
Excellent book, written by two of the most prolific contributors on the Oracle Apex forums - they've helped me out many a time.

The book has taken a long time to make it to print, but is worth the wait; whilst there are plenty of on-line resources to get you started with Apex, this book takes you through the next steps in depth. It is really well written and easy to read, with clear and useful example code throughout.

If you use, or are looking into using Apex, then this book is a must.

A must read for any APEX Developer, 19 Sep 2008
Just had to post a review on this one (and never posted a review before).
If you're a seasoned 'vet' in the APEX world or just starting out, you NEED this book.

It is crammed with insight and real-world examples into the key foundations that will make your APEX Application Development efforts a success.

10/10

Great little book, 12 Jun 2008
I bought this book because I am a programmer and need to interact with SQL on a daily basis. However...I do not want to know the fine grain details about database management systems. This is a great little book. It is very easy to read and met my needs perfectly. The samples are all easily achievable in 10 minutes, just like it says on the cover. This makes them very easy to scan over for a refresher when you are trying to work out a solution to a problem. It does not go into great details on the more advanced topics, however it does offer a primer on some of them such as transactions and cursors. Overall I would have no hesitation in recommending this book. It won't make you a SQL pro...but it will definitely make you more comfortable in common situations using this query language.

Perfect for beginners, 19 Apr 2008
This is the best book I have seen for people learning SQL from scratch. It takes you through the basics very quickly without assuming prior knowledge. Recommended for anyone with little or no prior SQL experience. You may want a basic SQL reference book to complement it.

You are better off with online tutorials, 27 Jan 2008
I recently wrote a simple database application for a hobby use. I have previous experience with SQL, but I wanted a handy reference to remind me of the basics. Time and time again I found this book useless, and resorted to an online search. I found the organisation of the book odd. If you want to create a simple application to learn with, you have to start from the back, as he tells you how to create a database and tables at the end.

Good Basic Introduction, 10 Dec 2007
This book is a great place to start for SQL. It tells you pretty much everything you are going to need to know for basic database usage. The later chapters on more advanced features such as triggers and stored procedures aren't massively useful as they don't go into enough depth but the author does say that they are only really intended to give you an idea of what you can do, not how to do it.

This book isn't going to teach you everything you need to know about SQL but it will give you the basics quickly and painlessly.


A great (if not simplistic) reference, 19 Jun 2007
This is a great reference for those starting out with SQL, or those just looking for a quick reference book to keep on their desks.

Don't be mistaken tho, it's by no means a complete reference, and doesn't cover any of the advanced SQL, but it's explanation of triggers, stored procedures, and transactions is a great reference to get around those mental syntax blocks

Not so easy to follow, 17 Sep 2008
I found this book is quite hard to follow. This is my very first SQL server book, and I was lost just in the first couple of the lessons. The author probably expected the readers to have a good knowledge about the system already, so there are not enough screen shots to guide you.

Plain English (not), 21 Aug 2008
This book is very dry and hard to read, some of the text is pure gobbledygook. It also assumes you have knowledge of some of the subjects it teaches. This is supposed to be a training course!

Is summary I wish I had spent my money on something else.


Not Impressed!!, 03 Mar 2008
Honestly - utter rubbish!!
There is several times ive read chapters and not known what the hell they are talking about. They do alot of 'Then all you have to do is close this' without actually telling you what the hell THIS is or wher to find it!!!!I'm already a dba on SQL Server 2000 so i though this would be a good top up!!! Ive gone back to googling the chapeters and reading up somewhere(anywhere) else....

It's an IT textbook, 29 Jan 2008
This is my first Microsoft Press textbook/training kit for an exam - and this is exactly what is focuses on - getting you through the exam.

It's very dry (and rather boring), and I much preferred reading the Wrox books Beginning SQL Server 2005 Administration, and then Professional SQL Server 2005 Administration (which appear to be comprehensive as well as being more readable).

Still, this book comes with a CD for 180 trial licence for SQL Server 2005 - and a Measure Up CD with exam simulation software.



Good training guide, poor as a reference book, 11 Sep 2006
These books have a tough expectation list as people want them to provide all they need to know to get through the associated examination and be a first class refernce book. The five-star rating applies to the former of these requirements as this is the market the book is aimed at. Having sat the examination I can say that all of the questions were answered in the book - and from previous exposure to these books that is not normally the case.

As a reference book it fails, simply because it is not intended as such and more obviously because to cover all the topics adequately it would have to be five times as long. That said, the section on Service Broker is way too vague - the knowledge it imparts will get you through the examination but will leave you floundering in the real world.

Use the book to pass the exam and to introduce you to the new technologies - look elsewhere for more in-depth practical (i.e real world) material.

[...]

Best text b