![]() |
![]() |
|
Microsoft Windows Server Administration Plan and Maintain a Windows Server Network Install, configure, and optimize an SQL Server. Create, troubleshoot, backup, and restore databases. Work with ODBC data sources and manage OLE DB providers. Configure database options to optimize system performance. Implement authentication modes with servers and/or databases. Manage and monitor security and system activity. Maintain high availability utilizing primary and standby servers, replication, and clustering. Exam #70-228 Course Length: 32 hours Microsoft SQL Server Database Design and Implementation Design and develop logical data models. Create and alter databases, consider and include file groups, file placement growth strategy, and space requirements. Learn to create, troubleshoot, and optimize databases and programming objects (including stored procedures, transactions, triggers, user-defined functions, and views). Retrieve and modify data using Transact-SQL and XML. Enforce data integrity, create indexes, and implement distributed data in a network environment. Exam #70-229 Course Length: 32 hours MCDBA - Prerequisites
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||