SQL Administrator/ Developer
Updating Skills
SQL 2008 Administrator
SQL 2008 Developer
Updating Skills
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.
After completing this course, students will be able to:
- Describe the new features of SQL Server 2008
- Manage and Optimize SQL Server 2008
- Secure a SQL Server 2008 Database
- Develop databases by using SQL Server 2008
- Create and maintain highly available SQL Server 2008 databases
- Create and use a SQL Server 2008 data warehouse
- Use SQL Server 2008 Reporting Services and Analysis Services
Course description pending from Microsoft.
SQL 2008 Administrator
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.
After completing this course, students will be able to:
- Install and configure SQL Server 2008
- Manage database files and security
- Backup and restore databases
- Transfer data into and out of SQL Server
- Automate administrative tasks
- Replicate data between SQL Server instances
- Maintain high availability
- Monitor SQL Server
Course description pending from Microsoft.
SQL 2008 Developer
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008/2005/2000
After completing this course, students will be able to:
- Describe the uses of and ways to execute the Transact-SQL language
- Use querying tools. Write SELECT queries to retrieve data
- Group and summarize data by using Transact-SQL
- Modify data in tables and join data from multiple tables
- Write queries that retrieve and modify data by using subqueries
- Query text fields with full-text search
- Describe how to create programming objects
- Use various techniques when working with complex queries
This five-day instructor-led 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.
After completing this course, students will be able to:
- Create databases and database files, data types and tables
- Use XML-related features in Microsoft SQL Server 2008
- Plan, create, and optimize indexes
- Implement data integrity in Microsoft SQL Server 2008 databases by using constraints and triggers
- Implement views, stored procedures, functions and managed code in the database
- Manage transactions and locks
- Use Service Broker to build a messaging-based solution
Course description pending from Microsoft.
|
