Beginning SQL Server 2008 for Developers: From Novice to Professional

石头

作者：Robin Dewson
出版日期：July 24, 2008
出版社：Apress
页数：496
ISBN：ISBN-10: 1590599586 ISBN-13: 978-1590599587
文件格式：PDF



Product Description
SQL Server 2008 is a first–rate database management system. Itoffers more capability than any previous release of SQL Server. Morethan just a classic relational database management system, SQL Server2008 includes exciting and powerful features that make it useful foreverything from large corporate data warehouses to ad hoc departmentaldatabases. You’ll find enhanced support for XML, new support forspatial data, transparent data encryption, a policy–based managementsystem, and more.
Author and developer Robin Dewson will show you theway from beginner to SQL Server 2008 professional. Learn to install SQLServer 2008 and navigate around Management Studio before getting rightto the heart of mastering fundamental SQL Server 2008 tasks: creatingtables, storing data, securing data, and retrieving it again. Dewsonensures you’ll be fully prepared to use all the basics and create asolid 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 hardwarefailure. Dewson walks you through SQL Server 2008’s easy–to–use backupand recovery feature set, giving you the grounding that you need inorder to set up a reliable plan for recovery in your own environment.
Learn to use Transact–SQL, a full–blown procedural language that isbuilt right into the database system. Transact–SQL is the key tounlocking everything that SQL Server 2008 has to offer. UsingTransact–SQL, you can write centrally encapsulated business logicthrough the use of stored procedures, automatically trigger processingthrough the use of triggers, and manipulate data within the serverwithout having to move data back and forth across the network.
Finally, you’ll learn a bit about SQL Server 2008 ReportingServices, a powerful tool that allows enterprise reporting. ReportingServices enables you to develop and serve reports across yourorganization and even to business partners outside your company.Reporting Services also gives end users the ability to create their ownreports, helping them transform business data into valuable, usableinformation 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.

Who is this book for?Developers new to SQL Server 2008. If you are just beginning todevelop software using SQL Server 2008, or if you are planning to do soin the near future, this book will set you on the road to success.
About the Apress Beginning SeriesThe Beginning series from Apress is the right choice to get theinformation you need to land that crucial entry–level job. These bookswill teach you a standard and important technology from the ground upbecause they are explicitly designed to take you from “novice toprofessional.” You’ll start your journey by seeing what you need toknowbut without needless theory and filler. You’ll build your skill setby learning how to put together real–world projects step by step. Sowhether your goal is your next career challenge or a new learningopportunity, the Beginning series from Apress will take you there—it isyour trusted guide through unfamiliar territory!
About the Author
Robin Dewson has been hooked on programming ever since he bought hisfirst computer, a Sinclair ZX80, in 1980. He has been working with SQLServer since version 6.5 and Visual Basic since version 5. Robin is aconsultant mainly in the city of London, where he has been for nearlyeight years. He also has been developing a rugby–related website aswell as maintaining his own site at www.fat-belly.com.

Jamesliu2009