Collection 2786 Designing a Microsoft SQL Server 2005 Infrastructure
This 18-hour, 9-course online collection is comprised of a rich multimedia experience coupled with comprehensive technical labs. This collection introduces you to Transact-SQL starting with basic SELECT queries, then advancing to grouping, joins, subqueries, data modification, transactions, and heterogeneous data sources. This collection is intended for IT Professionals who must access and manipulate data in SQL Server 2005 databases and other data sources.
Plus, Collection 2778 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL E-Learning lets you learn at your own pace. Work online or download courses to your computer to study when you are not connected to the Internet.
This offer includes the following:
Course 3589: Analyzing Capacity Needs for Microsoft SQL Server 2005
In this online learning course you will learn strategies for gathering data about the capacity of basic system resources such as storage, CPU, memory, and network bandwidth. You will also apply guidelines to help estimate future capacity needs. This course also includes access to five searchable E-Reference books for quick just-in-time problem solving. This course will also help prepare you for certification exam 70-443.
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 2 Hours
Language: English
Course 3590: Designing a Data Archiving Strategy for Microsoft SQL Server 2005
In this online learning course you will design a strategy for data archiving for Microsoft® SQL Server™ 2005. You will first determine how much data can be archived, then choose an appropriate structure for the archival data, and finally create a plan for archiving the data. This course also includes access to five searchable E-Reference books for quick just-in-time problem solving. This course will also help prepare you for certification exam 70-443.
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 2 Hours
Language: English
Course 3591: Designing a Database Server Consolidation Strategy for Microsoft SQL Server 2005
In this online learning course you will design the database server infrastructure of an organization. You will consider the benefits and risks of consolidating database servers, and how to use multiple SQL Server instances to optimize the design of your database server infrastructure. This course also includes access to five searchable E-Reference books for quick just-in-time problem solving. This course will also help prepare you for certification exam 70-443.
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 2 Hours
Language: English
Course 3592: Designing a Data Distribution Strategy for Microsoft SQL Server 2005
In this online learning course you will design a data distribution plan to distribute data among multiple locations. You will determine the data requirements for each location and then select an appropriate data distribution tool. IThis course also includes access to five searchable E-Reference books for quick just-in-time problem solving. This course will also help prepare you for certification exam 70-443.
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 2 Hours
Language: English
Course 3593: Designing a Microsoft SQL Server 2005 Database Server Infrastructure
In this online learning course you will evaluate the existing database server infrastructure of an organization and gather the technical and business requirements from various stakeholders. In addition, you will design modifications to a database server infrastructure and utilize best practices for standardizing database server hardware and software. This course also includes access to five searchable E-Reference books for quick just-in-time problem solving. This course will also help prepare you for certification exam 70-443.
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 2 Hours
Language: English
Course 3594: Designing a Data Recovery Strategy for Microsoft SQL Server 2005
In this online learning course you will design a data recovery strategy utilizing Microsoft® SQL Server™ 2005 . You will design a comprehensive strategy for your entire infrastructure that saves both time and money. This course also includes access to five searchable E-Reference books for quick just-in-time problem solving. This course will also help prepare you for certification exam 70-443.
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 2 Hours
Language: English
Course 3595: Establishing Database Conventions and Standards for Microsoft SQL Server 2005
In this online learning course you will establish database conventions and standards for Microsoft® SQL Server™ 2005 to help organize your server infrastructure and make your database administrator and developer teams more productive. This course also includes access to five searchable E-Reference books for quick just-in-time problem solving. This course will also help prepare you for certification exam 70-443.
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 2 Hours
Language: English
System Requirements:
To view this course, you need:
A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
Microsoft Windows 2000 or higher
Microsoft Internet Explorer 6.0 or higher
Macromedia Flash 7.0 or higher (1MB disk space needed to install)
Microsoft Windows Media Player 7.0 or higher
Microsoft XML Core Services 3.0 or higher
A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
A sound card, and either speakers or headphones (for multi-media audio).
Internet bandwidth of 56K or faster. Broadband internet access is recommended.
Accessibility Requirements:
The following software must be running on your computer in order to access this course with Screen Reader Software:
Microsoft Internet Explorer 6.0 or higher
Window-Eyes from GS Micro
JAWS from Freedom Scientific
MSAA enabled
|
