LearningSQLServer.com - Learning SQL Server

Application Developers
Database Administrators | Certification Exam Guides

Application Developer Subsections
Web Applications

Application Developers

Murach's SQL Server 2005 for Developers
By: Bryan Syverson, Joel Murach
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.

<MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/krislynsstrictly" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com"> SQL Server 2005 for Developers
By: Robert Ericsson, Jason Cline
Done in Murach’s unique "paired-pages" style, this book gives syntax and coding examples for each topic on the right hand page and extra perspective and explanation on the left.
With the release of SQL Server 2005, Microsoft will significantly enhance the capabilities of the product. These enhanced features fall into three main categories: data management, developer tools, and business intelligence. Developer’s Guide to SQL Server 2005 explores these new and improved features and covers topics relevant to developers beyond simple administrative tasks. The book is structured around the construction of an Internet movie rental Web site, where the database maintains customer lists, the catalog of films, and transactions. It also shows how SQL Server can be used to store video. This application illustrates the features of SQL Server 2005 in a realistic manner, and provides many insights into the new ways for developers to manipulate servers and databases. Each of the chapters in the book builds up pieces of the application as they would be done through a real development lifecycle, and the end product is a fully functioning database application. Specific discussions of similarities and differences between SQL Server 2005 and past versions allow users to leverage what they already know and apply it. After working through the book, developers will be up to speed and ready to integrate SQL Server 2005 into their own projects.