What you'll learn in this sql class:
The Microsoft SQL Server 2008 R2 certification tracks are designed to demonstrate your custom skill set and in-depth understanding of the features and functionality of key technology areas in SQL Server 2008 R2.Complete Course Title: MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database DevelopmentThis training combines and covers materials from the following courses:2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (3 days)Course Topics:Getting Started with Databases and Transact-SQL in SQL Server 2008Querying and Filtering DataGrouping and Summarizing DataJoining Data from Multiple TablesWorking with SubqueriesModifying Data in TablesQuerying Metadata, XML, and Full-Text IndexesUsing Programming Objects for Data RetrievalUsing Advanced Querying Techniques6231: Maintaining a Microsoft SQL Server 2008 R2 Database (5 days)Course Topics:Module 1: Introduction to SQL Server 2008 R2 and its ToolsetModule 2: Preparing Systems for SQL Server 2008 R2Module 3: Installing and Configuring SQL Server 2008 R2Module 4: Working with DatabasesModule 5: Understanding SQL Server 2008 R2 Recovery ModelsModule 6: Backup of SQL Server 2008 R2 DatabasesModule 7: Restoring SQL Server 2008 R2 DatabasesModule 8: Importing and Exporting DataModule 9: Authenticating and Authorizing UsersModule 10: Assigning Server and Database RolesModule 11: Authorizing Users to Access ResourcesModule 12: Auditing SQL Server EnvironmentsModule 13: Automating SQL Server 2008 R2 ManagementModule 14: Configuring Security for SQL Server AgentModule 15: Monitoring SQL Server 2008 R2 with Alerts and NotificationsModule 16: Performing Ongoing Database MaintenanceModule 17: Tracing Access to SQL Server 2008 R2Module 18: Monitoring SQL Server 2008 R2Module 19: Managing Multiple ServersModule 20: Troubleshooting Common SQL Server 2008 R2 Administrative Issues6232: Implementing a Microsoft SQL Server 2008 R2 Database (5 days)Course Topics:Module 1: Introduction to SQL Server and its ToolsetModule 2: Working with Data TypesModule 3: Designing and Implementing TablesModule 4: Designing and Implementing ViewsModule 5: Planning for SQL Server IndexingModule 6: Implementing Table Structures in SQL ServerModule 7: Reading SQL Server Execution PlansModule 8: Improving Performance through Nonclustered IndexesModule 9: Designing and Implementing Stored ProceduresModule 10: Merging Data and Passing TablesModule 11: Creating Highly Concurrent SQL Server ApplicationsModule 12: Handling Errors in T-SQL CodeModule 13: Designing and Implementing User-Defined FunctionsModule 14: Ensuring Data Integrity through ConstraintsModule 15: Responding to Data Manipulation via TriggersModule 16: Implementing Managed Code in SQL ServerModule 17: Storing XML Data in SQL ServerModule 18: Querying XML Data in SQL ServerModule 19: Working with SQL Server Spatial DataModule 20: Working with Full-Text Indexes and Queries
