MCTS Exam 70 - 433: SQL Server 2008, Database Development
This course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.
Chapter 1: Data Retrieval;
1.1 Before You Begin;
1.2 Lesson 1: Querying Data;
1.3 Lesson 2: Joining Related Tables;
1.4 Lesson 3: Implementing Aggregate Queries;
1.5 Lesson 4: Combining Datasets;
1.6 Lesson 5: Applying Built-in Scalar Functions;
1.7 Chapter Review;
1.8 Key Terms;
1.9 Suggested Practices;
1.10 Take a Practice Test;
Chapter 2: Modifying Data—The INSERT, UPDATE, DELETE, and MERGE Statements;
2.1 Before You Begin;
2.2 Lesson 1: Modifying Data by Using INSERT, UPDATE, and DELETE Statements;
2.3 Lesson 2: Enhancing DML Functionality with the OUTPUT Clause and MERGE Statement; 2.4 Lesson 3: Managing Transactions;
2.5 Chapter Review;
2.6 Key Terms;
2.7 Suggested Practices;
2.8 Take a Practice Test;
Chapter 3: Tables, Data Types, and Declarative Data Integrity;
3.1 Before You Begin;
3.2 Lesson 1: Working with Tables and Data Types;
3.3 Lesson 2: Declarative Data Integrity;
3.4 Chapter Review;
3.5 Key Terms;
3.6 Suggested Practices;
3.7 Take a Practice Test;
Chapter 4: Using Additional Query Techniques;
4.1 Before You Begin;
4.2 Lesson 1: Building Recursive Queries with CTEs;
4.3 Lesson 2: Implementing Subqueries;
4.4 Lesson 3: Applying Ranking Functions;
4.5 Chapter Review;
4.6 Key Terms;
4.7 Suggested Practices;
4.8 Take a Practice Test;
Chapter 5: Programming Microsoft SQL Server with T-SQL User-Defined Stored Procedures, Functions, Triggers, and Views;
5.1 Before You Begin;
5.2 Lesson 1: Stored Procedures;
5.3 Lesson 2: User-Defined Functions;
5.4 Lesson 3: Triggers;
5.5 Lesson 4: Views;
5.6 Chapter Review;
5.7 Key Terms;
5.8 Suggested Practices;
5.9 Take a Practice Test;
Chapter 6: Techniques to Improve Query Performance;
6.1 Before You Begin;
6.2 Lesson 1: Tuning Queries;
6.3 Lesson 2: Creating Indexes;
6.4 Chapter Review;
6.5 Key Terms;
6.6 Suggested Practices;
6.7 Take a Practice Test;
Chapter 7: Extending Microsoft SQL Server Functionality with XML, SQLCLR, and Filestream;
7.1 Before You Begin;
7.2 Lesson 1: Working with XML; 7.3 Lesson 2: Using SQLCLR and Filestream;
7.4 Chapter Review;
7.5 Key Terms;
7.6 Suggested Practices;
7.7 Take a Practice Test;
Chapter 8: Extending Microsoft SQL Server Functionality with the Spatial, Full-Text Search, and Service Broker; 8.1 Before You Begin;
8.2 Lesson 1: Implementing Spatial Data Types;
8.3 Lesson 2: Implementing Full-Text Search;
8.4 Lesson 3: Implementing Service Broker Solutions;
8.5 Chapter Review;
8.6 Key Terms;
8.7 Suggested Practices;
8.8 Take a Practice Test;
Chapter 9: An Introduction to Microsoft SQL Server Manageability Features;
9.1 Before You Begin;
9.2 Lesson 1: Integrating Database Mail;
9.3 Lesson 2: Implementing Scripts by Using Windows PowerShell;
9.4 Lesson 3: Tracking Data Changes;
9.5 Chapter Review;
9.6 Key Terms;
9.7 Suggested Practices;
9.8 Take a Practice Test; Case Scenario Answers;
- Create and alter tables and views, indexes.
- Implementing Programming Objects
- Working with Query Fundamentals
- Applying Additional Query Techniques
- Working with Additional SQL Server Components
- Working with XML Data
- Gathering Performance Information
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
When you pass Exam 70-433: TS: Microsoft SQL Server 2008, Database Development, you complete the requirements for the following certification:
- Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development
Candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles. These job roles include the following:
Our Partners
