National / International Training Sales
Toll Free (877) 564-8724
7833 Walker Drive, Suite 520C
Greenbelt, Maryland 20770
Phone: (301) 220-2802
Toll-Free: (877) 564-TRAIN
Fax: (301) 220-3814
45195 Research Pl, Suite 120
Ashburn, VA 20147
Phone: (571) 209-9234
Toll-Free: (877) 774-9234
Fax: (571) 209-9238
Email: click here
Sorry, there aren't any upcoming classes in this course. Check back often for frequent updates!
ACE offers on-site IT training to organizations throughout the country. If you have a group in need of computer training, we will come to you.
Students taking our MS 6231B SQL Server 2008 course will learn how to maintain and use the tools of the Microsoft SQL Server 2008 R2 database. The course lasts for five days and is intended for IT professionals. Due to the fast-paced nature of the course, students are expected to have previous knowledge of the Windows operating system, SQL and relational databases. Other individuals who may gain from this class include those who maintain SQL Server databases and develop applications for such databases. Each class is led by an instructor who teaches lessons and prepares labs for hands-on learning.
The course is divided into 20 modules with accompanying lessons and labs. Modules progress in a logical manner based on difficulty and complexity. Typically we cover four modules per day. Modules one through four introduce students to the Microsoft SQL Server 2008 R2 database. They cover topics like preparation of systems, installation of the software and working with databases. The first day of the course allows students to get used to the tools and features of the database while gaining knowledge of the structure.
Modules five through seven discuss recovery, backup and restoring methods for this Microsoft database. Students begin with an overview of the recovery models and backup strategies that they will put into practice with the labs. There is one module dedicated to importing and exporting, and students will be introduced to BCP during this lesson.
The next few lessons delve into topics relating to users and server roles. Students will learn how to create and authorize users and assign various roles. Students will get into the management and security aspects of the database starting with module 13. This section discusses the server agent and jobs. The last few labs will have students working with ongoing maintenance, managing multiple servers and troubleshooting.
By the end of the course, students will be able to perform all of the tasks they learned throughout the lessons and explain different aspects of the Microsoft SQL Server 2008 R2 database. Students will understand the architecture, system requirements, installation and configuration. They will know how to import and export wizards and data. Security is an important issue with databases, so students will have the ability to manage these aspects. By completing this course, students can work with server and database roles while managing users. Some of the major tasks of user management include creation, assignment and permission. Communication within servers is important, and students will understand the tools relating to mail and other types of notification. While maintaining databases, students will be able to monitor data, work with data-tier applications and troubleshoot common problems.
$2,700 per enrollment
*Please note that we do accept Microsoft Training Vouchers
There are no current articles related to this course. Please check back soon!