SitemapTable of ContentsBackCoverMCAD/MCSE/MCDBA Self-Paced Training Kit-Microsoft SQL Server 2000 Database Design and Implementation, Second Edition, Exam 70-229About This BookIntended AudiencePrerequisitesReference MaterialsAbout the CD-ROMFeatures of This BookBefore You Begin Part 2Using Part 2Using Part 2 of This BookExam Objectives SummaryGetting More HelpThe Microsoft Certified Professional ProgramTechnical SupportPart 1: Self-Paced Training for Microsoft SQL Server 2000 Database Design and ImplementationChapter 1: Introduction to Microsoft SQL Server 2000Before You BeginLesson 1: Overview of SQL Server 2000Lesson 2: Components of SQL Server 2000Lesson 3: Overview of SQL Server 2000 ArchitectureReviewChapter 2: Using Transact-SQL on a SQL Server DatabaseBefore You BeginLesson 1: SQL Server Programming ToolsLesson 2: Introduction to Transact-SQLLesson 3: Transact-SQL Syntax ElementsLesson 4: Executing Transact-SQL StatementsReviewChapter 3: Designing a SQL Server DatabaseBefore You BeginLesson 1: Introduction to Database DesignLesson 2: Planning a SQL Server DatabaseLesson 3: Identifying System RequirementsLesson 4: Developing a Logical Data ModelReviewChapter 4: Implementing SQL Server Databases and TablesBefore You BeginLesson 1: Creating and Managing a SQL Server DatabaseLesson 2: Identifying Data TypesLesson 3: Creating and Managing TablesReviewChapter 5: Implementing Data IntegrityBefore You BeginLesson 1: Introduction to Data IntegrityLesson 2: Implementing Integrity ConstraintsReviewChapter 6: Accessing and Modifying DataBefore You BeginLesson 1: Accessing Data in a SQL Server DatabaseLesson 2: Using Advanced Query Techniques to Access DataLesson 3: Modifying Data in a SQL Server DatabaseReviewChapter 7: Managing and Manipulating DataBefore You BeginLesson 1: Importing and Exporting DataLesson 2: Using Distributed Queries to Access External DataLesson 3: Using Cursors to Retrieve DataLesson 4: Retrieving XML DataReviewChapter 8: Implementing Stored ProceduresBefore You BeginLesson 1: Introduction to Stored ProceduresLesson 2: Creating, Executing, Modifying, and Deleting Stored ProceduresLesson 3: Programming Stored ProceduresReviewChapter 9: Implementing TriggersBefore You BeginLesson 1: Introduction to TriggersLesson 2: Creating and Managing TriggersLesson 3: Programming TriggersReviewChapter 10: Implementing ViewsBefore You BeginLesson 1: Introduction to ViewsLesson 2: Creating, Modifying, and Deleting ViewsLesson 3: Accessing Data through ViewsReviewChapter 11: Implementing IndexesBefore You BeginLesson 1: Index ArchitectureLesson 2: Index Creation and AdministrationReviewChapter 12: Managing SQL Server Transactions and LocksBefore You BeginLesson 1: Transaction and Locking ArchitectureLesson 2: Managing SQL Server TransactionsLesson 3: Managing SQL Server LockingReviewChapter 13: Designing and Administering SQL Server 2000 SecurityBefore You BeginLesson 1: Overview of SQL Server 2000 SecurityLesson 2: Designing a Database Security PlanLesson 3: Database Security Implementation and AdministrationReviewChapter 14: SQL Server Monitoring and TuningBefore You BeginLesson 1: Monitoring Databases with SQL ProfilerLesson 2: Index Tuning and Database PartitioningReviewPart 2: Preparation for MCP Exam 70-229Objective Domain 1: Developing a Logical Data ModelTested Skills and Suggested PracticesFurther ReadingObjective 1.1: Define Entities.Objective 1.2: Design entity keys.Objective 1.3: Design attribute domain integrity.Objective Domain 2: Implementing the Physical DatabaseTested Skills and Suggested PracticesFurther ReadingObjective 2.1: Create and alter databases.Objective 2.2: Create and alter database objects.Objective 2.3: Alter database objects to support replication and partitioned views.Objective 2.4: Troubleshoot failed object creation.Objective Domain 3: Retrieving and Modifying DataTested Skills and Suggested PracticesFurther ReadingObjective 3.1: Import and export data.Objective 3.2: Manipulate heterogeneous data.Objective 3.3: Retrieve, filter, group, summarize, and modify data by using Transact-SQL.Objective 3.4: Manage result sets by using cursors and Transact-SQL.Objective 3.5: Extract data in XML format.Objective Domain 4: Programming Business LogicTested Skills and Suggested PracticesFurther ReadingObjective 4.1: Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and views.Objective 4.2: Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views.Objective 4.3: Troubleshoot and optimize programming objects.Objective Domain 5: Tuning and Optimizing Data AccessTested Skills and Suggested PracticesFurther ReadingObjective 5.1: Analyze the query execution plan.Objective 5.2: Capture, analyze, and replay SQL Profiler traces.Objective 5.3: Create and implement indexing strategies.Objective 5.4: Improve index use by using the Index Tuning Wizard.Objective 5.5: Monitor and troubleshoot database activity by using SQL Profiler.Objective Domain 6: Designing a Database Security PlanTested Skills and Suggested PracticesFurther ReadingObjective 6.1: Control data access by using stored procedures, triggers, user-defined functions, and views.Objective 6.2: Define object-level security including column level permissions by using GRANT, REVOKE, and DENY.Objective 6.3: Create and manage application roles.Appendix A: Questions and AnswersChapter 2: Using Transact-SQL on a SQL Server Database ReviewChapter 3: Designing a SQL Server DatabaseLesson 1: Introduction to Database DesignExercise 1: Exploring the Basic Concepts of Database DesignChapter 3: Designing a SQL Server Database Lesson 3: Identifying System Requirements Exercise 2: Identifying the System Requirements for Your Database DesignChapter 3: Designing a SQL Server Database Lesson 4: Developing a Logical Data ModelExercise 3: Developing a Logical Data ModelChapter 3: Designing a SQL Server DatabaseReviewChapter 4: Implementing SQL Server Databases and Tables Lesson 2: Identifying Data Types Exercise 2: Identifying Column Data TypesChapter 4: Implementing SQL Server Databases and TablesReviewChapter 5: Implementing Data IntegrityLesson 1: Introduction to Data IntegrityExercise 1: Identifying the Properties Used to Ensure Data IntegrityChapter 5: Implementing Data IntegrityLesson 2: Implementing Integrity ConstraintsExercise 2: Adding Constraints to Existing TablesChapter 5: Implementing Data IntegrityReviewChapter 6: Accessing and Modifying DataLesson 3: Modifying Data in a SQL Server DatabaseExercise 3: Modifying Data in a SQL Server DatabaseChapter 6: Accessing and Modifying DataReviewChapter 7: Managing and Manipulating DataLesson 1: Importing and Exporting DataExercise 1: Importing and Exporting DataChapter 7: Managing and Manipulating DataReviewChapter 8: Implementing Stored ProdeduresLesson 1: Introduction to Stored ProceduresExercise 1: Exploring Stored ProceduresLesson 2: Creating, Executing, Modifying, and Deleting Stored ProceduresExercise 2: Working With Stored ProceduresChapter 8: Implementing Stored ProdeduresReviewChapter 9: Implementing TriggersReviewChapter 10: Implementing ViewsReviewChapter 11: Implementing IndexesLesson 1: Index ArchitectureExercise 1: Viewing Index Properties and Using an IndexChapter 11: Implementing IndexesLesson 2: Index Creation and AdministrationExercise 2: Creating a Clustered IndexChapter 11: Implementing IndexesReviewChapter 12: Managing SQL Server Transactions and LocksReviewChapter 13: Designing and Administering SQL Server 2000 Security Lesson 2: Designing a Database Security Plan Exercise 1: Designing Security for BookShopDBChapter 13: Designing and Administering SQL Server 2000 Security ReviewChapter 14: SQL Server Monitoring and TuningLesson 1: Monitoring Databases with SQL ProfilerExercise 1: Capturing Events Using SQL ProfilerChapter 14: SQL Server Monitoring and TuningReviewGlossaryABCDEFGHIJKLMNOPQRSTUVWXIndexIndex_AIndex_BIndex_CIndex_DIndex_EIndex_FIndex_GIndex_HIndex_IIndex_JIndex_LIndex_MIndex_NIndex_OIndex_PIndex_QIndex_RIndex_SIndex_TIndex_UIndex_VIndex_WIndex_XList of FiguresCD Content |
لطفا منتظر باشید ...
