HOME > 상세정보

상세정보

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

자료유형
단행본
단체저자명
Microsoft Corporation.
서명 / 저자사항
MCSE training kit : Microsoft SQL Server 2000 database design and implementation, exam 70-229 / Microsoft Corporation.
발행사항
Redmond, Wash. :   Microsoft Press ,   2001.  
형태사항
xxviii, 643 p. ; 24 cm. + 1 CD-ROM (4 3/4 in.) .
ISBN
073561248X
일반주기
Includes index.  
일반주제명
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.

소장정보

No. 소장처 청구기호 등록번호 도서상태 반납예정일 예약 서비스
No. 1 소장처 세종학술정보원/과학기술실/ 청구기호 005.7585 M4783 등록번호 151249228 도서상태 대출가능 반납예정일 예약 서비스 C

컨텐츠정보

저자소개

Microsoft Corporation(엮은이)

정보제공 : Aladin

목차

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


정보제공 : Aladin

관련분야 신착자료