|
SQL Server 2005: Database Essentials Step-by-Step
Get the guidance you need to start designing databases - one step at a time. With this practical tutorial, you'll teach yourself the core skills for building and managing databases with the next generation of SQL Server. Discover how to: *Install and configure SQL Server 2005 *Design database components with SQL Server Management Studio *Apply a three-step
modeling approach to design databases that meet business requirements *Create, modify, and manage views *Write user-defined functions and stored procedures using T-SQL *Add, delete, and update information in your databases *Work with data from custom applications and legacy systems *Troubleshoot error messages and handle exceptions CD features: *All practice exercises *Code samples
CONTENTS:
Part 1 - Introduction to Database Development with Microsoft SQL Server 2005
Introducing Database Development with Microsoft SQL Server 2005
Installing & Setting up your Microsoft SQL Server 2005 Development Environment
Reviewing Microsoft SQL Server 2005 Management Tools
Part 2 - How to Create a Microsoft SQL Server 2005 Database
Gathering & Understanding Business Requirements before Creating Database Objects
Designing a Database to solve Business Needs
Part 3 - How to Query Data from Microsoft SQL Server 2005
Reading Microsoft SQL Server 2005 Data from Client Applications
Selecting the Data You Need
Creating Views to Encapsulate Queries
Retreiving Data using Programmable Objects
Part 4 - How to Modify Data in Microsoft SQL Server 2005
Inserting Data in Microsoft SQL Server 2005
Deleting Data from Microsoft SQL Server 2005
Updating Data from Microsoft SQL Server 2005
Index
|
