 Trade In this Item for up to £9.55
Trade in Beginning SQL Server 2008 Express for Developers: From Novice to Professional (Expert's Voice in SQL Server) for an Amazon.co.uk gift card of up to £9.55, which you can then spend on millions of items across the site. Plus, get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a database administrator, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource commonly used by students, developers of small systems, and those transferring skills from other databases. This book focuses on the features within the Express Edition and therefore will not confuse readers with coverage of features found only in the Development Edition. By the end of the book, readers will be ready to move on to Accelerated SQL Server 2008 as well as other books within the Apress SQL Server lineup such as Pro SQL Server 2008 Reporting Services.
- Covers using the free Express Edition of SQL Server
- Describes creating a database from scratch and builds on this
- Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you and your business
What you’ll learn
- Learn what features exist within SQL Server 2008 Express Edition and how to install and upgrade the product and set up security.
- Design and create a database.
- Build database objects, such as tables and stored produres, graphically as well as programmatically.
- Work with data—inserting, updating, deleting, and retrieving—using simple and complex queries, programs, and data views.
- Generate reports from data.
- Implement a solid database maintenance strategy that includes backing up and restoring your data when necessary.
- Take advantage of advanced Transact–SQL techniques to get the most out of your data.
- Ensure good performance by building the right indexes, defining the right relationships between tables, and joining tables in the most optimal manner.
Who this book is for
Anyone interested in working with SQL Server as a database, and particularly those who wish for a no–cost database platform that plays well in the .NET environment. Ideal for those starting out in IT or who have to prior database experience.
About the Author
Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at www.fat-belly.com.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
5 of 5 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
Having just installed SQL Server 2008 Express it quickly became apparent that I needed a book to explain it all to me.
Whilst there is a plethora of SQL Server books it needed to be targeted at the Express version rather than some Enterprise version which has many more facilities that I would not use (at this stage, anyway).
This book is perfect. Let me say that again. This book is brilliant at concentrating on the Express version with all the skills anyone using SQL Server would need. In fact, I would almost say that installing SQL Server Express first and using this book to get a really thorough grounding should be compulsory for anyone hoping to eventually migrate to the bigger business or enterprise versions.
It covers authentication, indexes, permissions, stored procedures, backups, the Management Console (SSMSE, absolutely essential reading) and much, much more. Dewson, quite rightly, states throughout the book (as appropriate to the context) that he won't cover this and that topic because it was too advanced. Quite so. Walk before you can run and so on!
I can't recommend this book highly enough. If you're into SQL Server Express (the free version from Microsoft) then get this book at once.
Go on, get it!
Whilst there is a plethora of SQL Server books it needed to be targeted at the Express version rather than some Enterprise version which has many more facilities that I would not use (at this stage, anyway).
This book is perfect. Let me say that again. This book is brilliant at concentrating on the Express version with all the skills anyone using SQL Server would need. In fact, I would almost say that installing SQL Server Express first and using this book to get a really thorough grounding should be compulsory for anyone hoping to eventually migrate to the bigger business or enterprise versions.
It covers authentication, indexes, permissions, stored procedures, backups, the Management Console (SSMSE, absolutely essential reading) and much, much more. Dewson, quite rightly, states throughout the book (as appropriate to the context) that he won't cover this and that topic because it was too advanced. Quite so. Walk before you can run and so on!
I can't recommend this book highly enough. If you're into SQL Server Express (the free version from Microsoft) then get this book at once.
Go on, get it!
Format:Paperback|Amazon Verified Purchase
Shame this book did not cover SQLS2008 R2. Assuming R2 is fully compatible with R1, then this book is THE place to start. It is well written and follows logical sequences, with serendipitous gems of information appearing along the way. Apart from a beautiful "training" guide, this book will become a much-referred-to reference in the future. In addition, it is priced just right to accompany Microsoft's free server system.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
5 reviews
8 of 8 people found the following review helpful
Lacking Details
24 Jun 2010
Format:Paperback
I realize this is a beginners' book and accept that technical depth wouldn't be appropriate; however, many examples of what to execute in the query window lack explanation as to what the lines mean. While at other points in the book, the author takes the time to do so. This doesn't aid in learning anything if you are simply entering what you see.
Additionally, there are numerous missed steps in the progression the author is taking you through. It's as if you skipped an entire paragraph because he makes sudden jumps as to where you should be.
Now, if this wasn't a beginners' book, it would be proper for an author to assume a certain level of knowledge but a beginners' book should not assume this. At first I accepted a few of these but I am now at the half-way point in the book and find it very irritating that gaps in how he arrived at where he is and the reasons he had me execute a particular SQL script is irritating. I bought the book to learn Why What and Where; not execute this and there you go, good luck.
Additionally, there are numerous missed steps in the progression the author is taking you through. It's as if you skipped an entire paragraph because he makes sudden jumps as to where you should be.
Now, if this wasn't a beginners' book, it would be proper for an author to assume a certain level of knowledge but a beginners' book should not assume this. At first I accepted a few of these but I am now at the half-way point in the book and find it very irritating that gaps in how he arrived at where he is and the reasons he had me execute a particular SQL script is irritating. I bought the book to learn Why What and Where; not execute this and there you go, good luck.
0 of 2 people found the following review helpful
sql management studio express
8 May 2010
Format:Paperback|Amazon Verified Purchase
This book provides a great primer on how to use sql management studio express. Sql management studio is dedicated on how to use roles, schemas, tables, databases,ddl, dml. This book should be mandatory for any programmer or dba.
0 of 3 people found the following review helpful
Good for the beginner
25 July 2010
Format:Paperback|Amazon Verified Purchase
I am not a developer so the title was misleading. While checking the index I saw the section on security and bought the book. I had a really tough time figuring this out on my own. We are developing a fairly simple asset db for our regional office hardware and software assets. We will be using an Access front end and SQL 2008 Express backend. We have six people accessing seven tables in various ways. Figuring out security for all of this was not easy for me. This book helped me a great deal. It appears that we don't even need to use db schemas as part of our security scenario. It was not clear in the book if schemas were necessary in all situations. I am using SSMS for all the administration. I have not done any of the exercises in the test environment, so I can't speak much on that part of the book.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Computer Science > Architecture & Microprocessors > Architecture & Logic
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Introduction
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
