MCSE Training Guide
SQL Server 7 Database Design
Published on 7. June 1999
Book
Mixed media product
576 pages
978-0-7357-0004-8 (ISBN)
Description
The Microsoft Certified Systems Engineer (MCSE) certification continues to increase in popularity. Employers often require this certification because it proves applicants have mastered the ability to design, develop, implement, and support solutions with Microsoft products and technologies. Computer professionals who become Microsoft Certified are recognized as experts and are sought after industry-wide. Having MCSE credentials increases an administrator's salary potential by thousands of dollars. In order to obtain their MCSE, candidates are required to pass six exams-four core exams and two elective exams. This curriculum is very rigorous and extremely challenging. The MCSE exams, which cost $100 each, are much more difficult than the Novell CNE exams. Candidates are in need of a complete, concise, inexpensive study guide to fully prepare them to pass the exams.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 242 mm
Width: 208 mm
Thickness: 41 mm
Weight
1376 gr
ISBN-13
978-0-7357-0004-8 (9780735700048)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
(NOTE: Each chapter begins with an Introduction.)I. EXAM PREPARATION.
1. Data Modeling.
A College Enrollment Database. Introducing Data Modeling Concepts: Entities, Attributes, and Relationships. Implementing Entities and Attributes. Implementing Relationships. Normalizing Your Database Design.
2. Creating Physical Storage.
Units of Storage in SQL Server. Database Files and File Groups. Creating a Database. Database Options.
3. Implementing a Physical Design.
Understanding Data Types. Managing Tables. Using Constraints.
4. Indexing.
Introduction to Indexes. Types of Indexes. Guidelines for Indexing. Managing Indexes with Transact-SQL. Managing Indexes with Enterprise Manager. Implementing Full-Text Search.
5. Populating a Database.
Using Bulk Copy to Import and Export Data. Using the BCP Command-Line Utility. Using the BULK INSERT Statement. Using Data Transformation Services to Import and Export Data.
6. Retrieving Data.
Writing SELECT Statements: An Overview. Choosing Columns. Using DISTINCT and ALL Keywords. Choosing Rows. Sorting Result Rows. Generating Summary Data. Using Joins. Using Sub-Queries.
7. Modifying Data.
The INSERT Statement. The UPDATE Statement. The DELETE Statement.
8. Programmability.
Control-of-Flow Statements. Managing Errors. Using Transactions. Implementing Cursors.
9. Miscellaneous Programming Techniques.
Stored Procedures. Views. Triggers. Distributed Queries.
10. Client Accessibility.
Dynamic Model versus Stored Procedure Model. Configuring Session-Level Options.
11. Maintaining a Database.
Creating, Examining, and Optimizing Execution Plans. Diagnosing and Resolving Locking Problems. Using SQL Server Profiler.
II. FINAL REVIEW.
12. Fast Facts: SQL_Server 7 Database Design.
Developing a Logical Data Model. Deriving the Physical Design. Creating Data Services. Creating a Physical Database. Maintaining a Database.
13. Study and Exam Prep Tips.
Study Tips. Exam Prep Tips. Final Considerations. Chapter-Practice Exam. Answers and Explanations.
III. APPENDIXES.
Appendix A: Glossary.
Appendix B: Overview of the Certification Process.
Types of Certification. Certification Requirements.
Appendix C: What's on the CD-ROM.
Top Score. Exclusive Electronic Version of Text. Copyright Information and Disclaimer.
Appendix D: Using the Top Score Software.
Getting Started. Instructions on Using the Top Score Software. Summary.
Index.
1. Data Modeling.
A College Enrollment Database. Introducing Data Modeling Concepts: Entities, Attributes, and Relationships. Implementing Entities and Attributes. Implementing Relationships. Normalizing Your Database Design.
2. Creating Physical Storage.
Units of Storage in SQL Server. Database Files and File Groups. Creating a Database. Database Options.
3. Implementing a Physical Design.
Understanding Data Types. Managing Tables. Using Constraints.
4. Indexing.
Introduction to Indexes. Types of Indexes. Guidelines for Indexing. Managing Indexes with Transact-SQL. Managing Indexes with Enterprise Manager. Implementing Full-Text Search.
5. Populating a Database.
Using Bulk Copy to Import and Export Data. Using the BCP Command-Line Utility. Using the BULK INSERT Statement. Using Data Transformation Services to Import and Export Data.
6. Retrieving Data.
Writing SELECT Statements: An Overview. Choosing Columns. Using DISTINCT and ALL Keywords. Choosing Rows. Sorting Result Rows. Generating Summary Data. Using Joins. Using Sub-Queries.
7. Modifying Data.
The INSERT Statement. The UPDATE Statement. The DELETE Statement.
8. Programmability.
Control-of-Flow Statements. Managing Errors. Using Transactions. Implementing Cursors.
9. Miscellaneous Programming Techniques.
Stored Procedures. Views. Triggers. Distributed Queries.
10. Client Accessibility.
Dynamic Model versus Stored Procedure Model. Configuring Session-Level Options.
11. Maintaining a Database.
Creating, Examining, and Optimizing Execution Plans. Diagnosing and Resolving Locking Problems. Using SQL Server Profiler.
II. FINAL REVIEW.
12. Fast Facts: SQL_Server 7 Database Design.
Developing a Logical Data Model. Deriving the Physical Design. Creating Data Services. Creating a Physical Database. Maintaining a Database.
13. Study and Exam Prep Tips.
Study Tips. Exam Prep Tips. Final Considerations. Chapter-Practice Exam. Answers and Explanations.
III. APPENDIXES.
Appendix A: Glossary.
Appendix B: Overview of the Certification Process.
Types of Certification. Certification Requirements.
Appendix C: What's on the CD-ROM.
Top Score. Exclusive Electronic Version of Text. Copyright Information and Disclaimer.
Appendix D: Using the Top Score Software.
Getting Started. Instructions on Using the Top Score Software. Summary.
Index.