Microsoft SQL Server 2000 Database Development From Scratch
- By Rob Hawthorne
- Published Feb 14, 2006 by Que.
eBook (Adobe DRM)
- This product currently is not for sale.
- About Adobe DRM eBooks
- Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
- Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.
This eBook requires the free Adobe® Digital Editions software.
Before downloading this DRM-encrypted PDF, be sure to:
Description
- Copyright 2003
- Pages: 496
- Edition: 1st
- eBook (Adobe DRM)
- ISBN-10: 0-7686-5575-7
- ISBN-13: 978-0-7686-5575-9
Microsoft SQL Server Database Development from Scratch is a road map to database management, implementation, and administration. Author Rob Hawthorne teaches readers how to create, maintain, and increase performance within the application. Concepts and techniques are reinforced as readers create a spy tracker database.
Sample Content
Table of Contents
Introduction.
1. Taking Spy Net from Idea to SQL Server Database.
A Case Study for Spy Net Limited.
An Overview of the SQL Spy Net Application. Determining What the Application Should. What Are We Going to Achieve?
Modeling the SQL Spy Net Application.
Designing the Spy Net Tables. Using Relational Theory to Model Spy Net's Application. Building Relationships Between Enemies.
Taking a Broad Overview of Spy Net. Summary. Next Steps.
2. The Tools of SQL Server 2000 for Managing an Instance.
Exploring Database Objects with Enterprise Manager.
Why You're Sure to Love Enterprise Manager. How This Tool Fits into Our SQL Spy Net Application.
Getting the Answers with Query Analyzer.
What You Can Do with Query Analyzer. Using This Tool for the SQL Spy Net Application.
Tracking Code Crimes with Profiler.
When You'll Use Profiler. Profiling and the SQL Spy Net Application.
Importing and Exporting Data the Easy Way.
Why You Should Use DTS. Generating SQL Spy Net Data with DTS.
Checking Out SQL Server 2000's Other Tools. Summary. Next Steps.
3. Making Virtual Spies-Creating Spy Net in SQL Server 2000.
Playing Program Director (Sys Admin) for SpyNet.
Setting the sa Password. Configuring the Model Database to Meet Our SQL Spy Net Application. Requirements.
Creating the SQL Spy Net Application Database.
Using Enterprise Manager to Create Our Application Database.
Using the Data Definition Language (DDL) to Create Databases and Objects.
Building Tables for Our Spies. Revisiting the Analysis of the SQL Spy Net Application.
Bringing Our Data Model and Database Together.
Developing the First Database Table for the SQL Spy Net Application. Creating Tables the Fun Way-With Code. Filling in the Blanks.
Summary. Next Steps.
4. Manipulating Data with Transact-SQL.
What Is This SELECT Statement Then?
The First Building Block for SELECT. Where Does the Data Come FROM? Limiting Data with WHERE. Put Those Spies in Order!
Let's Get Some Data in with the INSERT Statement.
Defining the Table and Columns We Want to Insert Into. Let's Put In Some New Data!
Keeping Everything Up-to-Date.
Which Table, Please? Correcting Data to Fix Data Problems. WHERE to Put the New Value.
When a Good Spy Dies...DELETE 'em. What Else Can We Do with Transact-SQL Besides DMLs and DDLs?
Declaring Variables. Assigning Values to Our Va