Name: MCSE Training Kit (Exam 70-229) : Microsoft SQL Server 2000 Datab
Brand: WonderClub
SKU: 9780735612488
Price: 99.99 USD
Availability: InStock
Rating: 4 (1 reviews)

Book Categories

Authors

About This Book ..... xiii: Intended Audience ..... xiii; Prerequisites ..... xiv; Reference Materials ..... xiv; About the CD-ROM ..... xiv; Features of this Book ..... xv; The Microsoft Certified Professional Program ..... xxii; Technical Support ..... xxvii
Chapter 1: Introduction to Microsoft SQL Server 2000 ..... 1: Lesson 1: Overview of SQL Server 2000 ..... 2; Lesson 2: Components of SQL Server 2000 ..... 9; Lesson 3: Overview of SQL Server 2000 Architecture ..... 20; Review ..... 42
Chapter 2: Using Transact-SQL on a SQL Server Database ..... 45: Lesson 1: SQL Server Programming Tools ..... 46; Lesson 2: Introduction to Transact-SQL ..... 66; Lesson 3: Transact-SQL Syntax Elements ..... 77; Lesson 4: Executing Transact-SQL Statements ..... 89; Review ..... 96
Chapter 3: Designing a SQL Server Database ..... 99: Lesson 1: Introduction to Database Design ..... 100; Lesson 2: Planning a SQL Server Database ..... 112; Lesson 3: Identifying System Requirements ..... 119; Lesson 4: Developing a Logical Data Model ..... 129; Review ..... 141
Chapter 4: Implementing SQL Server Databases and Tables ..... 143: Lesson 1: Creating and Managing a SQL Server Database ..... 144; Lesson 2: Identifying Data Types ..... 155; Lesson 3: Creating and Managing Tables ..... 163; Review ..... 176
Chapter 5: Implementing Data Integrity ..... 179: Lesson 1: Introduction to Data Integrity ..... 180; Lesson 2: Implementing Integrity Constraints ..... 187; Review ..... 202
Chapter 6: Accessing and Modifying Data ..... 205: Lesson 1: Accessing Data in a SQL Server Database ..... 206; Lesson 2: Using Advanced Query Techniques to Access Data ..... 215; Lesson 3: Modifying Data in a SQL Server Database ..... 229; Review ..... 240
Chapter 7: Managing and Manipulating Data ..... 243: Lesson 1: Importing and Exporting Data ..... 244; Lesson 2: Using Distributed Queries to Access External Data ..... 256; Lesson 3: Using Cursors to Retrieve Data ..... 263; Lesson 4: Retrieving XML Data ..... 272; Review ..... 281
Chapter 8: Implementing Stored Procedures ..... 283: Lesson 1: Introduction to Stored Procedures ..... 284; Lesson 2: Creating, Executing, Modifying, and Deleting Stored Procedures ..... 292; Lesson 3: Programming Stored Procedures ..... 310; Review ..... 327
Chapter 9: Implementing Triggers ..... 329: Lesson 1: Introduction to Triggers ..... 331; Lesson 2: Creating and Managing Triggers ..... 339; Lesson 3: Programming Triggers ..... 350; Review ..... 361
Chapter 10: Implementing Views ..... 363: Lesson 1: Introduction to Views ..... 364; Lesson 2: Creating, Modifying, and Deleting Views ..... 368; Lesson 3: Accessing Data through Views ..... 379; Review ..... 388
Chapter 11: Implementing Indexes ..... 391: Lesson 1: Index Architecture ..... 392; Lesson 2: Index Creation and Administration ..... 403; Review ..... 418
Chapter 12: Managing SQL Server Transactions and Locks ..... 421: Lesson 1: Transaction and Locking Architecture ..... 422; Lesson 2: Managing SQL Server Transactions ..... 432; Lesson 3: Managing SQL Server Locking ..... 446; Review ..... 459
Chapter 13: Designing and Administering SQL Server 2000 Security ..... 461: Lesson 1: Overview of SQL Server 2000 Security ..... 462; Lesson 2: Designing a Database Security Plan ..... 473; Lesson 3: Database Security Implementation and Administration ..... 479; Review ..... 496
Chapter 14: SQL Server Monitoring and Tuning ..... 499: Lesson 1: Monitoring Databases with SQL Profiler ..... 500; Lesson 2: Index Tuning and Database Partitioning ..... 511; Review ..... 519
Appendix A: Questions and Answers ..... 521
Glossary ..... 575
Index ..... 623

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

Manufacturer:

WonderClub

Item Number: 9780735612488

Number: 1

Product Description: Full Name: MCSE Training Kit (Exam 70-229) : Microsoft SQL Server 2000 Database Design and Implementation; Short Name:MCSE Training Kit

Universal Product Code (UPC): 9780735612488

WonderClub Stock Keeping Unit (WSKU): 9780735612488

Rating: 4/5 based on 1 Reviews

Image Location: https://wonderclub.com/images/covers/24/88/9780735612488.jpg

Category: Media >> Books

Weight: 0.200 kg (0.44 lbs)

Width: 7.720 cm (3.04 inches)

Heigh : 9.420 cm (3.71 inches)

Depth: 2.110 cm (0.83 inches)

Date Added: August 25, 2020, Added By: Ross

Date Last Edited: August 25, 2020, Edited By: Ross

Price	Condition	Delivery	Seller	Action
$99.99	Digital	Arrives between Apr 19 - May 19 Login to your account for a direct download. Some files are emailed from Dropbox. Continent $0.00 - World $0.00	WonderClub (9294 total ratings)

Question Concerning MCSE Training Kit

Ask a Question about MCSE Training Kit

No Question found!

Read Reviews for MCSE Training Kit (Exam 70-229) : Microsoft SQL Server 2000 Database Design and Implementation Write review

No review found!

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

Be the First to Review this Item at Wonderclub

Book Categories

Authors

WonderClub

Question Concerning MCSE Training Kit

Read Reviews for MCSE Training Kit (Exam 70-229) : Microsoft SQL Server 2000 Database Design and Implementation Write review

Login

Complaints

Blog

Games

Digital Media

Souls

Obituary

Contact Us

FAQ

You must be logged in to add to Wishlist

This item is in your Wish List

This item is in your Collection

This Item is in Your Inventory

You must be logged in to review the products