Microsoft SQL Server 7.0 Database Implementation Training Kit

, Microsoft Press

ISBN:1572318260, Edition: , 1999-04

Price: $99.99

Table of Contents

• Cover
  • LOC Page
• Chapter 1 -- Overview of SQL Server
  • Lesson 1: What is SQL Server?
  • Lesson 2: SQL Server Components
  • Lesson 3: SQL Server Architecture Overview
  • Lesson 4: SQL Server Security Overview
  • Review
• Chapter 2 -- Overview of Transact-SQL
  • Lesson 1: SQL Server Programming Tools
  • Lesson 2: Elements of Transact-SQL
  • Lesson 3: Ways to Execute Transact-SQL Statements
  • Review
• Chapter 3 -- Creating Databases
  • Lesson 1: Introduction to Database Design
  • Lesson 2: Introduction to SQL Server Databases
  • Lesson 3: Creating and Dropping Databases
  • Lesson 4: Managing Databases
  • Lesson 5: The library Database
  • Review
• Chapter 4 -- Creating Database Objects
  • Lesson 1: Creating Data Types
  • Lesson 2: Creating Tables
  • Lesson 3: Generating Scripts
  • Review
• Chapter 5 -- Implementing Data Integrity
  • Lesson 1: Types of Data Integrity
  • Lesson 2: Using Constraints
  • Lesson 3: Using Defaults and Rules
  • Review
• Chapter 6 -- Planning and Creating Indexes
  • Lesson 1: Introduction to Indexes
  • Lesson 2: Index Architecture
  • Lesson 3: Creating Indexes
  • Review
• Chapter 7 -- Maintaining Indexes
  • Lesson 1: Maintaining Indexes
  • Lesson 2: Statistical Information
  • Lesson 3: Full-Text Search
  • Review
• Chapter 8 -- Querying Multiple Tables
  • Lesson 1: Combining Data from Multiple Tables
  • Lesson 2: Advanced Joins
  • Review
• Chapter 9 -- Advance Query Techniques
  • Lesson 1: Subqueries
  • Lesson 2: Using Cursors
  • Lesson 3: Modifying Data
  • Review
• Chapter 10 -- Summarizing Data
  • Lesson 1: Using Aggregate Functions
  • Lesson 2: GROUP BY Fundamentals
  • Lesson 3: Generating Aggregate Values within Result Sets
  • Review
• Chapter 11 -- Implementing Views
  • Lesson 1: Introduction to Views
  • Lesson 2: Creating, Altering, and Dropping Views
  • Lesson 3: Advanced Topics
  • Review
• Chapter 12 -- Managing Transactions and Locks
  • Lesson 1: Managing Transactions
  • Lesson 2: SQL Server Locking
  • Lesson 3: Managing Locks
  • Review
• Chapter 13 -- Working with Distributed Data
  • Lesson 1: Using External Data Sources
  • Lesson 2: Working with Distributed Data
  • Lesson 3: Executing a Query on a Linked Server
  • Review
• Chapter 14 -- Implementing Stored Procedures
  • Lesson 1: Introduction to Stored Procedures
  • Lesson 2: Creating, Executing, and Modifying Stored Procedures
  • Lesson 3: Using Parameters and Error Messages
  • Review
• Chapter 15 -- Implementing Triggers
  • Lesson 1: Introducing Triggers
  • Lesson 2: How Triggers Work
  • Review
• Appendixes
  • Appendix A -- Questions and Answers
  • Appendix B -- Library Database Case Study
  • Appendix C -- Database Schemas
  • Appendix D -- Performing Basic Queries
    • Lesson 1: Retrieving Data
    • Lesson 2: Modifying Data
    • Review
  • Glossary
    • A
    • B
    • C
    • D
    • E
    • F
    • G
    • H
    • I
    • J
    • K
    • L
    • M
    • N
    • O
    • P
    • Q
    • R
    • S
    • T
    • U
    • V
    • W