MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)
MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)
ISBN: 073561248X
EAN: 2147483647
EAN: 2147483647
Year: 2001
Pages: 97
Pages: 97
Authors: Microsoft Corporation
- 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
MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)
ISBN: 073561248X
EAN: 2147483647
EAN: 2147483647
Year: 2001
Pages: 97
Pages: 97
Authors: Microsoft Corporation