Flylib.com
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
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
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
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Identifying Project Scope Risk
Identifying Project Schedule Risk
Quantifying and Analyzing Project Risk
Managing Project Risk
Closing Projects
Documenting Software Architectures: Views and Beyond
Elements, Relations, and Properties of the Allocation Viewtype
Examples of Interface Documentation
Building the Documentation Package
Module Generalization View
Module Layered View
A Practitioners Guide to Software Test Design
Domain Analysis Testing
Use Case Testing
Section III - Testing Paradigms
Section IV - Supporting Technologies
Appendix B Stateless University Registration System Case Study
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
Selecting More Than a Single Cell
Using Exponents in Formulas
Introduction
Forecasting
Using Trigonometry Functions
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 336 Power and Control Tray Cable Type TC
Article 353 High Density Polyethylene Conduit Type HDPE Conduit
Article 366 Auxiliary Gutters
Tables
Example No. D11 Mobile Home (See 550.18)
.NET-A Complete Development Cycle
Conclusion
Refining Requirements for 3D Text Display
Building the Web Application with ASP.NET
Implementation of Online Photo Shop
Secure Checkout
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies