En savoir plus
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 acrossyour 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.
Table des matières
SQL Server 2008 Overview and Installation.- SQL Server Management Studio.- Database Design and Creation.- Security and Compliance.- Defining Tables.- Creating Indexes and Database Diagramming.- Database Backups, Recovery, and Maintenance.- Working with the Data.- Building a View.- Stored Procedures and Functions.- T-SQL Essentials.- Advanced T-SQL.- Triggers.- SQL Server 2008 Reporting Services.
A propos de l'auteur
Robin Dewson started out on the Sinclair ZX80 (but failing to run a power station, as they claimed), then worked his way through the ZX81 and Spectrum to studying computers at the Scottish College of Textiles, where he was instilled with the belief that mainframes were the future. After many years, he eventually saw the error of his ways and started using Clipper, FoxPro, and Visual Basic. Robin is currently working on a trading system called "Kojak" in a large US investment bank in London.
Résumé
Beginning SQL Server 2008 for Developers is the starting-point in the Apress roadmap of titles for developers who wish to base their projects upon Microsoft's flagship database management system. The book takes developers from the point of installing SQL Server 2008, through the process of storing, retrieving, and securing data, to the point of being able to serve up business reports using SQL Server 2008 Reporting Services. The author has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He maintains visibility in the field through his website and his other books. The two previous editions of this book have sold well.
