---

MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)

ISBN: 073561248X
EAN: 2147483647

Year: 2001
Pages: 97

Authors: Microsoft Corporation

BUY ON AMAZON

• Cover
• LOC
• 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
• Review
• 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
• Review
• 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
• Review
• 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
• Review
• Chapter 5 -- Implementing Data Integrity
• Lesson 1:Introduction to Data Integrity
• Lesson 2:Implementing Integrity Constraints
• Review
• 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
• Review
• 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
• Review
• 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
• Review
• Chapter 9 -- Implementing Triggers
• Lesson 1:Introduction to Triggers
• Lesson 2: Creating and Managing Triggers
• Lesson 3:Programming Triggers
• Review
• Chapter 10 -- Implementing Views
• Lesson 1:Introduction to Views
• Lesson 2:Creating, Modifying, and Deleting Views
• Lesson 3:Accessing Data through Views
• Review
• Chapter 11 -- Implementing Indexes
• Lesson 1:Index Architecture
• Lesson 2:Index Creation and Administration
• Review
• 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
• Review
• 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
• Review
• Chapter 14 -- SQL Server Monitoring and Tuning
• Lesson 1:Monitoring Databases with SQL Profiler
• Lesson 2:Index Tuning and Database Partitioning
• Review
• Appendix A -- Questions and Answers
• Glossary
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• About This Electronic Book
• Create a List of Favorite Topics
• External Links
• Enlarge Graphics
• Use Accessibility Shortcut Keys
• Use the Shortcut Menu Commands
• To Turn On MouseKeys
• Customize the Help Viewer
• Print the Current Topic
• Full-Text Search
• Use Full-Text Search
• Advanced Full-Text Search
• Search for Information
• Find Information with Advanced Full-Text Search
• Search for Words or Phrases
• Define Search Terms
• Use Nested Expressions
• Search for Words in the Titles of Topic Files
• Find Words Similar to Your Search Term
• Search Previous Results