HOME > Detail View

Detail View

MCSE training kit : Microsoft SQL Server 2000 database design and implementation, exam 70-229

MCSE training kit : Microsoft SQL Server 2000 database design and implementation, exam 70-229

Material type
단행본
Corporate Author
Microsoft Corporation.
Title Statement
MCSE training kit : Microsoft SQL Server 2000 database design and implementation, exam 70-229 / Microsoft Corporation.
Publication, Distribution, etc
Redmond, Wash. :   Microsoft Press ,   2001.  
Physical Medium
xxviii, 643 p. ; 24 cm. + 1 CD-ROM (4 3/4 in.) .
ISBN
073561248X
General Note
Includes index.  
Subject Added Entry-Topical Term
Client/server computing. Electronic data processing personnel -- Certification. Microsoft software -- Examinations -- Study guides.
000 00989camuu2200277 a 4500
001 000045458651
005 20080731144935
008 010904s2001 wau 001 0 eng
010 ▼a 2001018718
020 ▼a 073561248X
035 ▼a (KERIS)BIB000008037652
040 ▼a 222001 ▼c 222001 ▼d 244002
042 ▼a pcc
050 0 0 ▼a QA76.9.C55 ▼b M48 2001
082 0 0 ▼a 005.75/85 ▼2 22
090 ▼a 005.7585 ▼b M4783
245 0 0 ▼a MCSE training kit : ▼b Microsoft SQL Server 2000 database design and implementation, exam 70-229 / ▼c Microsoft Corporation.
260 ▼a Redmond, Wash. : ▼b Microsoft Press , ▼c 2001.
300 ▼a xxviii, 643 p. ; ▼c 24 cm. + ▼e 1 CD-ROM (4 3/4 in.) .
500 ▼a Includes index.
630 0 0 ▼a SQL server.
650 0 ▼a Client/server computing.
650 0 ▼a Electronic data processing personnel ▼x Certification.
650 0 ▼a Microsoft software ▼x Examinations ▼v Study guides.
710 2 ▼a Microsoft Corporation.

Holdings Information

No. Location Call Number Accession No. Availability Due Date Make a Reservation Service
No. 1 Location Sejong Academic Information Center/Science & Technology/ Call Number 005.7585 M4783 Accession No. 151249228 Availability Available Due Date Make a Reservation Service C

Contents information

Author Introduction

Microsoft Corporation(엮은이)

Information Provided By: : Aladin

Table of Contents

About This Book

Chapter 1. Introduction to Microsoft SQL Server 2000
Lesson 1. Overview of SQL Server 2000
Lesson 2. Components of SQL Server 2000
Lesson 3. Overview of SQL Server 2000 Architecture

Chapter 2. Using Transact-SQL on a SQL Server Database
Lesson 1. SQL Server Programming Tools
Lesson 2. Introduction to Transact-SQL
Lesson 3. Transact-SQL Syntax Elements
Lesson 4. Executing Transact-SQL Statements

Chapter 3. Designing a SQL Server Database
Lesson 1. Introduction to Database Design
Lesson 2. Planning a SQL Server Database
Lesson 3. Identifying System Requirements
Lesson 4. Developing a Logical Data Model

Chapter 4. Implementing SQL Server Databases and Tables
Lesson 1. Creating and Managing a SQL Server Database
Lesson 2. Identifying Data Types
Lesson 3. Creating and Managing Tables

Chapter 5. Implementing Data Integrity
Lesson 1. Introduction to Data Integrity
Lesson 2. Implementing Integrity Constraints

Chapter 6. Accessing and Modifying Data
Lesson 1. Accessing Data in a SQL Server Database
Lesson 2. Using Advanced Query Techniques to Access Data
Lesson 3. Modifying Data in a SQL Server Database

Chapter 7. Managing and Manipulating Data
Lesson 1. Importing and Exporting Data
Lesson 2. Using Distributed Queries to Access External Data
Lesson 3. Using Cursors to Retrieve Data
Lesson 4. Retrieving XML Data

Chapter 8. Implementing Stored Procedures
Lesson 1. Introduction to Stored Procedures
Lesson 2. Creating, Executing, Modifying, and Deleting Stored Procedures
Lesson 3. Programming Stored Procedures

Chapter 9. Implementing Triggers
Lesson 1. Introduction to Triggers
Lesson 2. Creating and Managing Triggers
Lesson 3. Programming Triggers

Chapter 10. Implementing Views
Lesson 1. Introduction to Views
Lesson 2. Creating, Modifying, and Deleting Views
Lesson 3. Accessing Data through Views

Chapter 11. Implementing Indexes
Lesson 1. Index Architecture
Lesson 2. Index Creation and Administration


Chapter 12. Managing SQL Server Transactions and Locks
Lesson 1. Transaction and Locking Architecture
Lesson 2. Managing SQL Server Transactions
Lesson 3. Managing SQL Server Locking

Chapter 13. Designing and Administering SQL Server 2000 Security
Lesson 1. Overview of SQL Server 2000 Security
Lesson 2. Designing a Database Security Plan
Lesson 3. Database Security Implementation and Administration

Chapter 14. SQL Server Monitoring and Tuning
Lesson 1. Monitoring Databases with SQL Profiler
Lesson 2. Index Tuning and Database Partitioning

Appendix A: Questions and Answers

Glossary

Index


Information Provided By: : Aladin

New Arrivals Books in Related Fields

이창현 (2021)