Books Home | About Us | Index | Next Record | Browse

Tel: 0121 706 6000 

• Published by: Murach (Mike) & Associates Inc.
• Author: Bryan Syverson ; Joel Murach
• Page Count: 702
• Group: General - COMPUTER PROGRAMMING
• ISBN: 1890774391/9781890774394
• Published: Aug 2006

Our Price: 34.99
 

For Latest Pricing and Availability Click Here
 

Book Information and Description:

Murach's SQL Server 2005 for Developers
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.


Contents:

An introduction to relational databases and SQL
- How to use the Management Studio
- How to retrieve data from a single table
- How to retrieve data from two or more tables
- How to code summary queries
- How to code subqueries
- How to insert, update, and delete data
- How to work with data types and functions
- How to design a database
- How to create and maintain databases and tables with SQL statements
- How to use the Management Studio for database design
- How to work with views
- How to code scripts
- How to code stored procedures, functions, and triggers
- How to work with cursors
- How to manage transactions and locking
- How to manage database security
- How to work with XML
- An introduction to CLR integration
- How to code CLR stored procedures, functions, and triggers
- How to code aggregate functions and user-defined types.


Brief Description:

Aimed at every application developer who uses SQL Server 2005, this book presents the essential SQL statements for retrieving and updating the data in a database. It also shows you how to design and create a database, how to work with views, stored procedures, transactions, security, and XML integration, and how to use the CLR integration feature.