Flylib.com
Books
Software
Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Category list
Computers & Technology
Programming
Languages & Tools
Software
Category list
Certification
Microsoft
Computer Science
Microsoft
Development
SQL Server
Databases
Relational Databases
SQL
Education & Reference
Science & Math
Mathematics
MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification) - page 1
Buy on amazon.com >>
N
<< Previous book
Next page >>
1
2
Cover
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
1
2
Buy on amazon.com >>
N
<< Previous book
Next page >>