MCTS: SQL Server 2008, Database Development e-Camp
Who Needs to Attend
IT professionals who work with SQL Server 2008 and write application code against systems that run SQL Server 2008, write T-SQL or Microsoft .NET CLR code that runs inside SQL Server 2008, or develop solutions in SQL Server 2008, and who are seeking certification preparation
Prerequisites
- Familiarity with using Microsoft Windows
- Knowledge of basic relational database concepts and querying data by using Transact-SQL
- Familiarity with the role of a database administrator
Follow-On Courses
There are no follow-ons for this course.
This e-Camp will prepare qualified Microsoft professionals to earn the Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification. This intensive prep program will help you get up to speed on technologies needed to work with SQL Server 2008 and writing application code against systems that run SQL Server 2008. It will also help you prepare for certification. This course features a combination of the theory and practical aspects of technologies as well as test-preparation materials for the MCTS: SQL Server 2008, Database Development certification exam.
You Will Receive In Your e-Camp:
- Official Microsoft e-Learning content
- One exam voucher
- Test preparation software from Self Test Software
- Global Knowledge Online Reference Library
You Will Prepare For This Exam:
- Exam 70-433: TS: Microsoft SQL Server 2008, Database Development
Pass The Exam To Earn This Certification:
- MCTS: SQL Server 2008, Database Development
What You'll Learn
- Use Transact-SQL querying tools
- How to filter data
- How to write correlated sub queries
- How SQL Server interacts with XML
- How to apply Transact-SQL commands
Course Outline
Exam 70-433: TS Microsoft SQL Server 2008, Database Development
1. Introduction to Transact-SQL in Microsoft SQL Server 2008
- Transact-SQL programming language
- Transact-SQL elements
- Using Transact-SQL querying tools
- Using Books Online
2. Querying and Filtering Data in Microsoft SQL Server 2008
- The SELECT statement
- How to filter data
- How to retrieve unknown values
- Format result sets
- Performance considerations of Transact-SQL
3. Grouping and Summarizing Data in Microsoft SQL Server 2008
- Aggregate functions
- Using the GROUP BY clause
- Using the GROUPING SETS clauses
- Using the TOP N and RANKING clause
4. Joining Data from Multiple Tables in Microsoft SQL Server 2008
- How to query data from multiple tables
- Joins for typical reporting needs
- How to combine and limit result sets
5. Working with Subqueries Using Microsoft SQL Server 2008
- How to write basic subqueries
- How to write correlated subqueries
- Compare subqueries with joins and temporary tables
- Common table expressions
6. Modifying Data in Tables with Microsoft SQL Server 2008
- Overview of transactions
- Transaction isolation levels
- Insert data into tables
- Delete data from tables
- Update data in tables
- Merge data into tables
7. Integrated Full Text Search and Returning XML Result Sets in SQL Server 2008
- Integrated Full Text Search service
- How to use the Full Text Search service
- How SQL Server interacts with XML
- How to return result sets in a XML format
8. Introduction to Programming Objects in Microsoft SQL Server 2008
- Using views
- Stored procedures and triggers
- User-defined functions
- Writing distributed queries
9. Querying Metadata in Microsoft SQL Server 2008
- Transact-SQL commands vs. the SQL Server Management Studio
- How to query metadata
- Applying Transact-SQL commands
Labs
RSS