Frequently Bought Together
Customers Who Bought This Item Also Bought
Murach's ADO.NET 2.0 Database Programming with VB 2005 (Murach: Training & Reference) by Anne Boehm |
by Joel Murach
|
by Anne Boehm
|
by Anne Boehm
|
by Anne Boehm
|
Product details
Would you like to update product info or give feedback on images?
|
Customers Viewing This Page May Be Interested in These Sponsored Links(What is this?) |
Product Description
Every application developer who uses SQL Server 2005 should own this book. To start, the book presents the essential SQL statements for retrieving and updating the data in a database, because that's what every application developer needs to know. Then, it shows you how to design and create a database, because application developers often end up in the role of database designer and DBA. Next, it shows how to work with views, scripts, stored procedures, functions, triggers, cursors, transactions, locking, security, and XML integration so you can create database applications that are thoroughly professional. Finally, it shows how to use the new CLR integration feature, so you can use C# or Visual Basic to code stored procedures, functions, triggers, aggregate functions, and user-defined types.
From the Publisher
The SQL book that most developers don't even know they need - that's how I
think of this book.
To be an effective application developer, you need to master SQL for the
database you're going to be using. But many developers get by with the SQL
they know, never realizing how much they're missing out on.
So this is first a book for developers who use Microsoft SQL Server as
their DBMS (though it can help you if you want to master standard SQL,
too). No matter how much SQL experience you have, you'll find new features
that you haven't been taking advantage of.
In section 1, you'll learn the concepts and terms you need for working with
any database. You'll also learn how to use the Microsoft SQL Server 2005
Management Studio to work with queries and databases. At that point, you'll
be prepared for rapid progress as you learn SQL.
In section 2, you'll learn all the skills for retrieving data from a
database and for adding, updating, and deleting that data. These skills
move from the simple to the complex so you won't have any trouble if you're
a SQL novice. And they present skills like using outer joins, summary
queries, and subqueries that will raise your SQL expertise if you do have
SQL experience.
In section 3, you'll learn how to design a database and how to implement
that design by using either SQL DDL (Data Definition Language) statements
or the Management Studio. When you're done, you'll be able to design and
implement your own databases. But even if you're never called upon to do
that, this section will give you perspective that will make you a better
SQL developer.
Section 4 presents the skills for working with database features like
views, stored procedures, functions, triggers, cursors, transactions, and
security. It also teaches you how to use the enhanced SQL features for
working with XML data. These are the features that give a database
management system much of its power and that give you an extra edge in your
SQL skills.
To complete your SQL Server skills, section 5 shows you how to use the CLR
integration feature that's new in SQL Server 2005. This feature allows you
to create database objects like stored procedures and user-defined types
using any .NET language, like C# or Visual Basic.
Concordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Do Customers Ultimately Buy After Viewing This Item?
 |
78% buy the item featured on this page: Murach's SQL Server 2005 for Developers £28.59 |
 |
8% buy Murach's SQL Server 2008 for Developers£37.39 |
 |
7% buy Murach's ASP.NET 2.0 Web Programming with VB 2005 £32.99 |
 |
7% buy Murach's ADO.NET 2.0 Database Programming with VB 2005 (Murach: Training & Reference) £28.59 |
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
Most Helpful Customer Reviews
Share your thoughts with other customers: Create your own review
|
 |
Listmania!
Look for similar items by category
- 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 > Languages & Tools
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
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.
Health & Beauty at Amazon.co.uk |
More From Joel Murach
Murach's Java Servlets and JSP: 2nd... This new edition of "Murach's Java Servlets and JSP" makes it easier...
Read more
|
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 |
