|
Frequently Bought Together
Customers Who Bought This Item Also Bought
Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (Wrox Programmer to Programmer) by Paul Turley |
Professional Microsoft SQL Server 2008 Reporting Services (Wrox Programmer to Programmer) by Paul Turley |
Professional Microsoft SQL Server 2008 Administration (Wrox Programmer to Programmer) by Brian Knight |
Professional Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer) by Robert Vieira |
Beginning ASP.NET 3.5: in C# and VB (Programmer to Programmer) by Imar Spaanjaars |
Product details
Would you like to update product info or give feedback on images?
|
Product Description
- This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in–depth look at SQL Server itself
- Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server
- Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more
- Features updated and new material, including new examples using Microsoft′s AdventureWorks sample database
From the Back Cover
Starting simply and gradually progressing to increasingly advanced topics, this introduction to the SQL Server database focuses on what is distinctive about the SQL environment—SQL Server 2008, in particular—versus other programming environments. Author Robert Vieira draws on his experience as one of the leading authorities on Microsoft SQL Server and uses his unique tutorial approach to explain the significant changes to the fundamental core components of SQL Server 2008.
You′ll begin with an overview of database design concepts and learn how to implement these fundamental concepts with Microsoft SQL Server 2008. Then, you′ll take a look at the role of an RDBMS (relational database management system) and where it fits in the grand scheme of system development. Thorough coverage of the key additions and changes to the 2008 version of SQL Server include discussions on DATE and TIME datatypes, hierarchyID datatypes, MERGE and multiple inserts, recursive queries, and more. With this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008.
What you will learn from this book
- How RDBMSs store, manage, and retrieve data
-
Ways to create and alter tables
-
Various "forms" of database normalization
-
Techniques for writing scripts and working with stored procedures
-
The positives and negatives of indexes
-
Myriad consequences that locks and deadlocks have on system performance
-
An understanding of triggers and how they are used
Who this book is for
This book is for developers who are looking for a complete introduction to database design concepts and learning SQL. A basic understanding of development fundamentals is helpful.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.
See all Product Description
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Do Customers Ultimately Buy After Viewing This Item?
 |
68% buy the item featured on this page: Beginning Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer)£16.24 |
 |
14% buy Professional Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer)£22.09 |
 |
8% buy Professional Microsoft SQL Server 2008 Administration (Wrox Programmer to Programmer) £25.49 |
 |
5% buy Microsoft® SQL Server® 2008 Step by Step (Step by Step (Microsoft)) £19.99 |
Customer Reviews
There are no customer reviews yet. Create your own review
| |||
Video reviews
|
 |
Listmania!
Look for similar items by category
- 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 > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Introduction
- Books > Computing & Internet > Programming > Languages & Tools
- Books > Computing & Internet > Programming > Languages > XML > XML & Databases
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
- Books > Computing & Internet > Software & Graphics
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
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.
Fun for Everyone |
More From Robert Vieira
Professional Microsoft SQL Server... Master the increasingly complex feature set of the latest release of...
Read more
|
Up to 53% off Braun Series Shavers |
Treat Someone
With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is). |
|||||||
| |||||
Your Recent History
(What's this?)|
You have no recently viewed items or searches.
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. Look to the right column to find helpful suggestions for your shopping session. |
Continue Shopping: Top Sellers
| ||||
Amazon Home | |
| International Sites: United States | Germany | France | Japan | Canada | China | |
| Business Programs: Sell on Amazon | Fulfilment by Amazon | Join Associates | Join Advantage | |
| Customer Service | Help | View Basket | Your Account | |
| About Amazon.co.uk | Careers at Amazon | |
| Conditions of Use & Sale | Privacy Notice © 1996-2009, Amazon.com, Inc. and its affiliates |