Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server

About this Course
This instructor-led course provides the knowledge and skills to design, optimize, and maintain a database administrative solution for Microsoft SQL Server 2008.
Audience Profile
The primary audience of this course is IT professionals who design and maintain SQL Server databases. The audience can also comprise technical architects and consultants who design and implement SQL Server solutions. Students taking this course are expected to have three or more years of experience working on databases for two or more of the following phases in the product lifecycle - design, development, deployment, optimization, maintenance, or support.
The students should have experience in the following areas:
  • Administering databases
  • Designing logical database schema solutions
  • Defining high-availability solutions
  • Automating administrative tasks
  • Defining security solutions
  • Monitoring and troubleshooting the database server
  • Designing and executing deployments
  • Defining the infrastructure (storage, hardware, and number of servers or instances, etc.)
At Course Completion
After completing this course, students will be able to:
  • Implement an administrative solution for SQL Server 2008.
  • Deploy SQL Server 2008.
  • Design the physical structure for SQL Server 2008.
  • Design a strategy for maintaining SQL Server 2008.
  • Design a strategy for managing SQL Server 2008.
  • Automate the database managing strategy for SQL Server 2008.
  • Design a strategy for securing databases in SQL Server 2008.
  • Design a strategy for monitoring SQL Server 2008.
  • Design a strategy for content distribution in SQL Server 2008.
  • Design a strategy for replication in SQL Server 2008.
  • Design a high availability solution for SQL Server 2008.
  • Design a strategy for backup and recovery in SQL Server 2008.
 
Повеќе информации за курсот можете да најдете на следниот линк.

Microsoft SQL® Server 2008, Implementation, and Maintenance

Audience Profile

Candidates should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work in environments in which databases are central to their job roles. These job roles include the following:
  • IT generalists who work in environments in which SQL Server 2008 R2 is part of an overall solution
     
  • IT professionals who manage systems that run SQL Server 2008 R2
     
  • IT professionals who work with third-party applications that are built on SQL Server 2008 R2
     
  • Developers who build applications that use SQL Server 2008 R2
     
     
    Повеќе информации за курсот можете да најдете на следниот линк.