Wednesday, August 20, 2008

Beginning SQL Server 2008 for Developers From Novice to Professional Jul 2008

Beginning SQL Server 2008 for Developers: From Novice to Professional
(c) by Apress

The type of the release is: eBook
In the PDF format with ISBN: 1590599586 and Pub Date: July 24, 2008
The size of the release is: 06 disks x 2.88mb
And released on: 08/15/2008

SQL Server 2008 is a first–rate database management system. It offers
more capability than any previous release of SQL Server. More than just
a classic relational database management system, SQL Server 2008
includes exciting and powerful features that make it useful for
everything from large corporate data warehouses to ad hoc departmental
databases. You’ll find enhanced support for XML, new support for spatial
data, transparent data encryption, a policy–based management system, and
more. Author and developer Robin Dewson will show you the way
from beginner to SQL Server 2008 professional. Learn to install SQL
Server 2008 and navigate around Management Studio before getting right
to the heart of mastering fundamental SQL Server 2008 tasks: creating
tables, storing data, securing data, and retrieving it again. Dewson
ensures you’ll be fully prepared to use all the basics and create a
solid foundation for your own projects. Don’t forget about backups! Your
database will house important data, so backing up is essential to
protect yourself from inevitable hardware failure. Dewson walks you
through SQL Server 2008’s easy–to–use backup and recovery feature set,
giving you the grounding that you need in order to set up a reliable
plan for recovery in your own environment. Learn to use Transact–SQL, a
full–blown procedural language that is built right into the database
system. Transact–SQL is the key to unlocking everything that SQL Server
2008 has to offer. Using Transact–SQL, you can write centrally
encapsulated business logic through the use of stored procedures,
automatically trigger processing through the use of triggers, and
manipulate data within the server without having to move data back and
forth across the network. Finally, you’ll learn a bit about SQL Server
2008 Reporting Services, a powerful tool that allows enterprise
reporting. Reporting Services enables you to develop and serve reports
across your organization and even to business partners outside your
company. Reporting Services also gives end users the ability to create
their own reports, helping them transform business data into valuable,
usable information to guide their day–to–day decisions.
What you’ll learn
- Install and manage SQL Server on your system.
- Create and secure tables.
- Store and query data; use indexes to improve query performance.
- “Sleep when the wind blows,” because you have a solid backup and
recovery process.
- Run procedural code inside your database in the form of Transact–SQL
procedures and triggers.
- Serve up business reports to in–house users and outside business
partners via SQL Server 2008 Reporting Services.

Download Here