Skip to main content

Learning and Training Resources


Are you looking to increase your knowledge and understanding of SQL Server, stay competitive, or just learn about the latest technology? Microsoft Learning offers you the most comprehensive training and resources that enable you to build technical solutions and stay competitive today and in the future.

Here you will find everything from skills assessments to determine the areas you need to focus on, through the courses and books to help you improve, to the exams to demostrate your knowledge.

Learning and Training Resources



Learning Plans

Learning and Training Resources

Course 2924: Building Data Components in Microsoft Visual Studio 2005
This course provides students with a focused, hands-on environment to experience the new features and functionality related to building Data Components in Microsoft Visual Studio 2005.
Course 2925: Building Managed Code for Microsoft SQL Server 2005
This course provides students with a focused, hands-on environment to experience the new features and functionality related to building managed code for Microsoft SQL Server 2005 using Visual Studio 2005.
Course 2939: Programming Microsoft SQL Server 2005
This course is ideal for architects, systems engineers, systems administrators, solution developers, or application developers installing and securing Microsoft SQL Server 2005. The course will cover the planning/design phase of technology adoption, and the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities.
Course 2940: Building Service and Notifications Using Microsoft SQL Server 2005
This course will enable database developers experienced in SQL Server 7.0 or SQL Server 2000 to upgrade their skills to SQL Server 2005. The course consists of three modules.
Course 2941: Creating the Data Access Tier Using Microsoft SQL Server 2005
This course will enable database developers experienced with SQL Server 7.0 or SQL Server 2000 to upgrade their skills to SQL Server 2005. The course is broken into three modules.
Course 3175: Selecting Microsoft SQL Server 2005 Services to Support Business Needs
This two-hour on-line course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server2005. (US and CA only)
Course 3176: Designing a Security Strategy for a Microsoft SQL Server 2005 Database Solution
This two-hour on-line course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005. (US and CA only)
Course 3177: Designing a Data Model Strategy for a Microsoft SQL Server 2005 Solution
This two-hour on-line course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005. (US and CA only)
Course 3178: Designing a Transaction Strategy for a Microsoft SQL Server 2005 Solution
This two-hour on-line course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005. (US and CA only)
Course 3300: Approaching Database Design Systematically Using Microsoft SQL Server 2005
This 2-hour premium course teaches database developers the phases involved in database design. This course will help prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005.
Course 3301: Modeling a Database at the Logical Level with Microsoft SQL Server 2005
This 2-hour premium course teaches database developers how to logically model databases to address their organization's transactional requirements. This course will help prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005.
Course 3302: Modeling a Database at the Physical Level with Microsoft SQL Server 2005
This 2-hour premium course teaches database developers how to physically model databases to address their organization's operational requirements. This course will help prepare for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005.
Course 3303: Designing for Database Performance with Microsoft SQL Server 2005
This 2-hour premium course teaches database developers how to design for performance. This course will help prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005.
Course 3304: Designing a Database Access Strategy with Microsoft SQL Server 2005
The 2-hour premium course teaches database developers how to address database retrieval requirements. This course will help prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005.
Course 3305: Modeling Database Dependencies with Microsoft SQL Server 2005
The 2-hour premium course teaches database developers how to address database retrieval requirements. This course will help prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005.

E-Learning Courses


Classroom Training

Learning and Training Resources

Inside Microsoft SQL Server 2005: Query Tuning and Optimization
Get deep, thorough coverage of the internals of query tuning and optimization in SQL Server 2005. This practical reference delivers expert guidance and best practices for enabling more effective queries. Includes code and table examples.
Inside Microsoft SQL Server 2005: The Storage Engine
This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.
Inside Microsoft SQL Server 2005: T-SQL Programming
Exploit advanced T-SQL language features with in-depth architectural insights from the experts. Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of the programming language—solving complex problems with real-world solutions.
Inside Microsoft SQL Server 2005: T-SQL Querying
Get the in-depth architectural insights you need to exploit advanced T-SQL querying techniques. Take a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language—solving complex problems with real-world solutions.
Introducing Microsoft SQL Server 2005 for Developers
Get a developer-focused introduction to the new programmability features in the next version of Microsoft SQL Server, including integration with the Microsoft .NET Framework, and learn powerful new ways to manipulate your servers.
MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
This 2-in-1 training kit delivers in-depth preparation, plus practice for 70-442, an exam for the MCITP Database Developer certification. Ace your exam prep - and build real-world job skills - with lessons, labs, practice tests, and more.
MCITP Self-Paced Training Kit (Exam 70-443): Planning, Designing, Developing, and Optimizing Databased Solutions Using Microsoft SQL Server 2005
Get in-depth preparation for Exam 70-443, an exam for the new Microsoft Certified IT Professional: Database Administrator certification - and build real-world job skills. Includes test questions, reviews, troubleshooting labs, exam discount, and more.
MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005
Get in-depth preparation for Exam 70-444, an exam for the new Microsoft Certified IT Professional: Database Administrator certification - and build real-world job skills. Includes test questions, reviews, troubleshooting labs, exam discount, and more.
MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft SQL Server 2005 Database Administrator Core Requirements
This training kit will help evaluate your proficiency in the skills and knowledge tested on Exam 70-431. It includes: - A prep guide with lessons, reviews, real-world case scenarios, and practice exercises - A CD with practice exams and answer explanations to help identify areas for further study
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 - Implementation and Maintenance
This training kit includes an official Microsoft study guide for SQL Server 2005 with lessons, case scenarios, and practice exercises, and a CD with sample tests and a searchable version of the textbook. Learn how to: - Install and configure SQL Server - Create tables and indexes, define columns, and implement constraints - Implement functions, stored procedures, and triggers by using Transact-SQL - Work with relational and XML data - Monitor, troubleshoot and tune queries - Maintain database availability with log shipping, database mirroring, and replication - Prepare a backup strategy and restore a database
MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance
This training kit includes an official Microsoft study guide for SQL Server 2005 with lessons, case scenarios, and practice exercises, and a CD with sample tests and a searchable version of the textbook. Learn how to: - Install, configure, and manage SQL Server business intelligence components and tools - Implement SQL Server Analysis Services cubes, create KPIs, work with MDX - Build data mining models and configure algorithms - Administer SQL Server Reporting Services and deploy information-rich solutions - Develop and troubleshoot SQL Server Integration Services packages - Implement package roles, protection levels, and passwords
Microsoft SQL Server 2005 Administrator's Companion
Get comprehensive information to plan, deploy, administer, and support Microsoft SQL Server 2005 in organizations of any size. With the ADMINISTRATOR'S COMPANION, you get mission-critical information in a single volume - straight from the experts.
Microsoft SQL Server 2005 Administrator's Pocket Consultant
The fast-answers, daily administration guide to Microsoft SQL Server 2005. This pocket-sized guide features concise tables, listings, and step-by-step instructions for fast, accurate answers on the spot.
Microsoft SQL Server 2005 Analysis Services Step by Step
Your hands-on, practical guide to Microsoft SQL Server 2005 Analysis Services. Get started using Business Intelligence tools that simplify data analysis with this popular, learn-by-doing tutorial. Includes data sets and sample code on CD.

Books

Learning and Training Resources

Inside Microsoft SQL Server 2005: Query Tuning and Optimization
Get deep, thorough coverage of the internals of query tuning and optimization in SQL Server 2005. This practical reference delivers expert guidance and best practices for enabling more effective queries. Includes code and table examples.
Inside Microsoft SQL Server 2005: The Storage Engine
This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.
Inside Microsoft SQL Server 2005: T-SQL Programming
Exploit advanced T-SQL language features with in-depth architectural insights from the experts. Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of the programming language—solving complex problems with real-world solutions.
Inside Microsoft SQL Server 2005: T-SQL Querying
Get the in-depth architectural insights you need to exploit advanced T-SQL querying techniques. Take a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language—solving complex problems with real-world solutions.
Introducing Microsoft SQL Server 2005 for Developers
Get a developer-focused introduction to the new programmability features in the next version of Microsoft SQL Server, including integration with the Microsoft .NET Framework, and learn powerful new ways to manipulate your servers.
MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
This 2-in-1 training kit delivers in-depth preparation, plus practice for 70-442, an exam for the MCITP Database Developer certification. Ace your exam prep - and build real-world job skills - with lessons, labs, practice tests, and more.
MCITP Self-Paced Training Kit (Exam 70-443): Planning, Designing, Developing, and Optimizing Databased Solutions Using Microsoft SQL Server 2005
Get in-depth preparation for Exam 70-443, an exam for the new Microsoft Certified IT Professional: Database Administrator certification - and build real-world job skills. Includes test questions, reviews, troubleshooting labs, exam discount, and more.
MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005
Get in-depth preparation for Exam 70-444, an exam for the new Microsoft Certified IT Professional: Database Administrator certification - and build real-world job skills. Includes test questions, reviews, troubleshooting labs, exam discount, and more.
MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft SQL Server 2005 Database Administrator Core Requirements
This training kit will help evaluate your proficiency in the skills and knowledge tested on Exam 70-431. It includes: - A prep guide with lessons, reviews, real-world case scenarios, and practice exercises - A CD with practice exams and answer explanations to help identify areas for further study
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 - Implementation and Maintenance
This training kit includes an official Microsoft study guide for SQL Server 2005 with lessons, case scenarios, and practice exercises, and a CD with sample tests and a searchable version of the textbook. Learn how to: - Install and configure SQL Server - Create tables and indexes, define columns, and implement constraints - Implement functions, stored procedures, and triggers by using Transact-SQL - Work with relational and XML data - Monitor, troubleshoot and tune queries - Maintain database availability with log shipping, database mirroring, and replication - Prepare a backup strategy and restore a database
MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance
This training kit includes an official Microsoft study guide for SQL Server 2005 with lessons, case scenarios, and practice exercises, and a CD with sample tests and a searchable version of the textbook. Learn how to: - Install, configure, and manage SQL Server business intelligence components and tools - Implement SQL Server Analysis Services cubes, create KPIs, work with MDX - Build data mining models and configure algorithms - Administer SQL Server Reporting Services and deploy information-rich solutions - Develop and troubleshoot SQL Server Integration Services packages - Implement package roles, protection levels, and passwords
Microsoft SQL Server 2005 Administrator's Companion
Get comprehensive information to plan, deploy, administer, and support Microsoft SQL Server 2005 in organizations of any size. With the ADMINISTRATOR'S COMPANION, you get mission-critical information in a single volume - straight from the experts.
Microsoft SQL Server 2005 Administrator's Pocket Consultant
The fast-answers, daily administration guide to Microsoft SQL Server 2005. This pocket-sized guide features concise tables, listings, and step-by-step instructions for fast, accurate answers on the spot.
Microsoft SQL Server 2005 Analysis Services Step by Step
Your hands-on, practical guide to Microsoft SQL Server 2005 Analysis Services. Get started using Business Intelligence tools that simplify data analysis with this popular, learn-by-doing tutorial. Includes data sets and sample code on CD.

Exams

Learning and Training Resources

This feed, No Title, currently has no items to display.

Featured Learning Resources

Learning and Training Resources

This feed, No Title, currently has no items to display.