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
Qshell for iSeries
Scripting
Command-Line Arguments
Sed
Writing Programs for Qshell
Appendix B Qshell versus DOS
Inside Network Security Assessment: Guarding Your IT Infrastructure
Quantitative and Qualitative Risk-Assessment Approaches
Determining the Next Step
Executive Summary
Analysis
Typical RFP Procurement Steps
Strategies for Information Technology Governance
An Emerging Strategy for E-Business IT Governance
Technical Issues Related to IT Governance Tactics: Product Metrics, Measurements and Process Control
Managing IT Functions
Governance in IT Outsourcing Partnerships
The Evolution of IT Governance at NB Power
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Reference Library Applications
How to Zero Pad a Text Number
Expand and Collapse All View Categories
Links to developerWorks
Links to developerWorks
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Office Automation Executables
Conclusion
Working with the Windows Collections
Creating a Data-Bound Customized Spreadsheet with VSTO
Introduction to Excels XML Features
GDI+ Programming with C#
Your First GDI+ Application
Tutorial: Your First GDI+ Application
Rectangles and Regions
Overview of the Printing Process
Double Buffering and Flicker-Free Drawing
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