MCSEClasses Certification Training Boot Camp MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security Military Discounts Testimonials About Us Linux/Unix Certification MCSD Certification Home MCSE Certification MCDBA Certification Cisco Certification Security Certification Java Certification Oracle® Certification CIW Certification Jobs Distance Learning Boot Camp Financing Boot Camp Pricing Boot Camp Technical Schedule Contact Us


MCDBA Windows 2003 Certification Boot Camp

Course Length: 16 days
Certifications: MCP
MCDBA
Number of Exams: 6

Class Schedule
Call for Class Schedule

  • Includes roundtrip airfare and lodging (Georgia and Florida only)
  • Hands-on instruction by a certified instructor
  • Includes all course materials and practice exams
  • Includes all certification exams
  • Onsite Testing
  • Breakfast and Lunch provided each day

If airfare and lodging are not required, the price is $1,000 less for 2-week courses, $750 less for 10 day courses, and $500 less for one week courses.

The Microsoft Certified Database Administrator (MCDBA) credential is the certification for professionals who implement and administer Microsoft SQL Server databases. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure Microsoft SQL Server.

By earning the MCDBA credential, individuals are demonstrating that they have the skills necessary to lead organizations in the successful design, implementation, and administration of Microsoft SQL Server databases.


Exam 70-270

Installing, Configuring, and Administering Microsoft Windows XP Professional

Installing Windows XP Professional
  • Perform an attended installation of Windows XP Professional.
  • Perform an unattended installation of Windows XP Professional.
  • Upgrade from a previous version of Windows to Windows XP Professional.
  • Perform post-installation updates and product activation.
  • Troubleshoot failed installations.
Implementing and Conducting Administration of Resources
  • Monitor, manage, and troubleshoot access to files and folders.
  • Manage and troubleshoot access to shared folders.
  • Connect to local and network print devices.
  • Configure and manage file systems.
  • Manage and troubleshoot access to and synchronization of offline files.
Implementing, Managing, Monitoring, and Troubleshooting Hardware Devices and Drivers
  • Implement, manage, and troubleshoot disk devices.
  • Implement, manage, and troubleshoot display devices.
  • Configure Advanced Configuration Power Interface (ACPI).
  • Implement, manage, and troubleshoot input and output (I/O) devices.
  • Manage and troubleshoot drivers and driver signing.
  • Monitor and configure multiprocessor computers.
Monitoring and Optimizing System Performance and Reliability
  • Monitor, optimize, and troubleshoot performance of the Windows XP Professional desktop.
  • Manage, monitor, and optimize system performance for mobile users.
  • Restore and back up the operating system, System State data, and user data.
Configuring and Troubleshooting the Desktop Environment
  • Configure and manage user profiles and desktop settings.
  • Configure support for multiple languages or multiple locations.
  • Manage applications by using Windows Installer packages.
Implementing, Managing, and Troubleshooting Network Protocols and Services
  • Configure and troubleshoot the TCP/IP protocol.
  • Connect to computers by using dial-up networking.
  • Connect to resources using Internet Explorer.
  • Configure, manage, and implement Internet Information Services (IIS).
  • Configure, manage, and troubleshoot Remote Desktop and Remote Assistance.
  • Configure, manage, and troubleshoot an Internet Connection Firewall (ICF).
Configuring, Managing, and Troubleshooting Security
  • Configure, manage, and troubleshoot Encrypting File System (EFS).
  • Configure, manage, and troubleshoot a security configuration and local security policy.
  • Configure, manage, and troubleshoot local user and group accounts.
  • Configure, manage, and troubleshoot Internet Explorer security settings.

[ back to top ]

Exam 70-290

Managing and Maintaining a Microsoft Windows Server 2003 Environment

Managing and Maintaining Physical and Logical Devices
  • Manage basic disks and dynamic disks.
  • Monitor server hardware. Tools might include Device Manager, the Hardware Troubleshooting Wizard, and appropriate Control Panel items.
  • Optimize server disk performance.
  • Install and configure server hardware devices.
Managing Users, Computers, and Groups
  • Manage local, roaming, and mandatory user profiles.
  • Create and manage computer accounts in an Active Directory environment.
  • Create and manage groups.
  • Create and manage user accounts.
  • Troubleshoot computer accounts.
  • Troubleshoot user accounts.
  • Troubleshoot user authentication issues.
Managing and Maintaining Access to Resources
  • Configure access to shared folders.
  • Troubleshoot Terminal Services.
  • Configure file system permissions.
  • Troubleshoot access to files and shared folders.
Managing and Maintaining a Server Environment
  • Monitor and analyze events. Tools might include Event Viewer and System Monitor.
  • Manage software update infrastructure.
  • Manage software site licensing.
  • Manage servers remotely.
  • Troubleshoot print queues.
  • Monitor system performance.
  • Monitor file and print servers. Tools might include Task Manager, Event Viewer, and System Monitor.
  • Monitor and optimize a server environment for application performance.
  • Manage a Web server.
Managing and Implementing Disaster Recovery
  • Perform system recovery for a server.
  • Manage backup procedures.
  • Recover from server hardware failure.
  • Restore backup data.
  • Schedule backup jobs.

[ back to top ]

Exam 70-291

Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

Implementing, Managing, and Maintaining IP Addressing
  • Configure TCP/IP addressing on a server computer.
  • Manage DHCP.
  • Troubleshoot TCP/IP addressing.
  • Troubleshoot DHCP.
Implementing, Managing, and Maintaining Name Resolution
  • Install and configure the DNS Server service.
  • Manage DNS.
  • Monitor DNS. Tools might include System Monitor, Event Viewer, Replication Monitor, and DNS debug logs.
Implementing, Managing, and Maintaining Network Security
  • Implement secure network administration procedures.
  • Monitor network protocol security. Tools might include the IP Security Monitor Microsoft Management Console (MMC) snap-in and Kerberos support tools.
  • Troubleshoot network protocol security. Tools might include the IP Security Monitor MMC snap-in, Event Viewer, and Network Monitor.
Implementing, Managing, and Maintaining Routing and Remote Access
  • Configure Routing and Remote Access user authentication.
  • Manage remote access.
  • Manage TCP/IP routing.
  • Implement secure access between private networks.
  • Troubleshoot user access to remote access services.
  • Troubleshoot Routing and Remote Access routing.
Maintaining a Network Infrastructure
  • Monitor network traffic. Tools might include Network Monitor and System Monitor.
  • Troubleshoot connectivity to the Internet.
  • Troubleshoot server services.

[ back to top ]

Exam 70-293

Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

Planning and Implementing Server Roles and Server Security
  • Configure security for servers that are assigned specific roles.
  • Plan a secure baseline installation.
  • Plan security for servers that are assigned specific roles. Roles might include domain controllers, Web servers, database servers, and mail servers.
  • Evaluate and select the operating system to install on computers in an enterprise.
Planning, Implementing, and Maintaining a Network Infrastructure
  • Plan a TCP/IP network infrastructure strategy.
  • Plan and modify a network topology.
  • Plan an Internet connectivity strategy.
  • Plan network traffic monitoring. Tools might include Network Monitor and System Monitor.
  • Troubleshoot connectivity to the Internet.
  • Troubleshoot TCP/IP addressing.
  • Plan a host name resolution strategy.
  • Plan a NetBIOS name resolution strategy.
  • Troubleshoot host name resolution.
Planning, Implementing, and Maintaining Routing and Remote Access
  • Plan a routing strategy.
  • Plan security for remote access users.
  • Implement secure access between private networks.
  • Troubleshoot TCP/IP routing. Tools might include the route, tracert, ping, pathping, and netsh commands and Network Monitor.
Planning, Implementing, and Maintaining Server Availability
  • Plan services for high availability.
  • Identify system bottlenecks, including memory, processor, disk, and network related bottlenecks.
  • Implement a cluster server.
  • Monitor Network Load Balancing. Tools might include the Network Load Balancing Monitor Microsoft Management Console (MMC) snap-in and the WLBS cluster control utility.
  • Plan a backup and recovery strategy.
Planning and Maintaining Network Security
  • Configure network protocol security.
  • Configure security for data transmission.
  • Plan for network protocol security.
  • Plan secure network administration methods.
  • Plan security for wireless networks.
  • Plan security for data transmission.
  • Troubleshoot security for data transmission. Tools might include the IP Security Monitor MMC snap-in and the Resultant Set of Policy (RSoP) MMC snap-in.
Planning, Implementing, and Maintaining Security Infrastructure.
  • Configure Active Directory directory service for certificate publication.
  • Plan a public key infrastructure (PKI) that uses Certificate Services.
  • Plan a framework for planning and implementing security.
  • Plan a security update infrastructure. Tools might include Microsoft Baseline Security Analyzer and Microsoft Software Update Services.

[ back to top ]

Exam 70-229

Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Developing a Logical Data Model
  • Define entities. Considerations include entity composition and normalization.
  • Design entity keys. Considerations include FOREIGN KEY constraints, PRIMARY KEY constraints, and UNIQUE constraints.
  • Design attribute domain integrity. Considerations include CHECK constraints, data types, and nullability.
Implementing the Physical Database
  • Create and alter databases. Considerations include file groups, file placement, growth strategy, and space requirements.
  • Create and alter database objects. Objects include constraints, indexes, stored procedures, tables, triggers, user-defined functions, and views.
  • Alter database objects to support replication and partitioned views.
  • Troubleshoot failed object creation.
Retrieving and Modifying Data
  • Import and export data. Methods include the bulk copy program, the Bulk Insert task, and Data Transformation Services (DTS).
  • Manipulate heterogeneous data. Methods include linked servers, OPENQUERY, OPENROWSET, and OPENXML.
  • Retrieve, filter, group, summarize, and modify data by using Transact-SQL.
  • Manage result sets by using cursors and Transact-SQL. Considerations include locking models and appropriate usage.
  • Extract data in XML format. Considerations include output format and XML schema structure.
Programming Business Logic
  • Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and views.
  • Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views.
  • Troubleshoot and optimize programming objects. Objects include stored procedures, transactions, triggers, user-defined functions, and views.
Tuning and Optimizing Data Access
  • Analyze the query execution plan. Considerations include query processor operations and steps.
  • Capture, analyze, and replay SQL Profiler traces. Considerations include lock detection, performance tuning, and trace flags.
  • Create and implement indexing strategies. Considerations include clustered index, covering index, indexed views, nonclustered index, placement, and statistics.
  • Improve index use by using the Index Tuning Wizard.
  • Monitor and troubleshoot database activity by using SQL Profiler.
Designing a Database Security Plan
  • Control data access by using stored procedures, triggers, user-defined functions, and views.
  • Define object-level security including column-level permissions by using GRANT, REVOKE, and DENY.
  • Create and manage application roles.

[ back to top ]

Exam 70-228

Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Installing and Configuring SQL Server 2000
  • Install SQL Server 2000. Considerations include clustering, default collation, file locations, number of instances, and service accounts.
  • Upgrade to SQL Server 2000.
  • Create a linked server.
  • Configure SQL Mail and SQLAgentMail.
  • Configure network libraries.
  • Troubleshoot failed installations.
Creating SQL Server 2000 Databases
  • Configure database options for performance. Considerations include capacity, network connectivity, physical drive configurations, and storage locations.
  • Attach and detach databases.
  • Create and alter databases.
  • Create and manage objects. Objects include constraints, indexes, stored procedures, triggers, and views.
Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
  • Optimize database performance. Considerations include indexing, locking, and recompiling.
  • Optimize data storage.
  • Modify the database schema.
  • Perform disaster recovery operations.
  • Perform integrity checks. Methods include configuring the Database Maintenance Plan Wizard and using the Database Consistency Checker (DBCC).
  • Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.
Extracting and Transforming Data with SQL Server 2000
  • Set up IIS virtual directories to support XML.
  • Import and export data. Methods include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries.
  • Develop and manage DTS packages.
  • Manage linked servers.
  • Convert data types.
  • Configure, maintain, and troubleshoot replication services.
Managing and Monitoring SQL Server 2000 Security
  • Configure mixed security modes or Windows Authentication. Considerations include client connectivity, client operating system, and security infrastructure.
  • Create and manage log ons.
  • Create and manage database users.
  • Create and manage security roles. Roles include application, database, and server.
  • Enforce and manage security by using stored procedures, triggers, views, and user-defined functions.
  • Set permissions in a database. Considerations include object permissions, object ownership, and statement permissions.
  • Manage security auditing. Methods include SQL Profiler and C2 auditing.
Managing, Monitoring, and Troubleshooting SQL Server 2000
  • Create, manage, and troubleshoot SQL Server Agent jobs.
  • Configure alerts and operators by using SQL Server Agent.
  • Optimize hardware resource usage. Resources include CPU, disk I/O, and memory.
  • Optimize and troubleshoot SQL Server system activity. Activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput.

[ back to top ]


MCSEClasses.com is your best choice for MCDBA, MCDBA training, MCDBA certification, MCDBA certification boot camp, MCDBA boot camp, MCDBA certification training, MCDBA boot camp training, MCDBA boot camp certification, MCDBA certification course, MCDBA course, training MCDBA, certification MCDBA, boot camp MCDBA, certification MCDBA boot camp, certification MCDBA training, boot camp MCDBA training, certification MCDBA course.



mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us





Search classes by keyword:
Search classes by category:
mcse training
MCSE boot camp MCSE Training MCSE Certification MCSE Bootcamp MCSE Boot Camp MCSE Course MCSE Training MCSE Certification MCSE Bootcamp MCSE Boot Camp MCSE MCSA Training MCSA Certification MCSA Bootcamp MCSA Boot Camp MCSA Course MCSA Training MCSA Certification MCSA Bootcamp MCSA Boot Camp MCSA Course MCSA MCSE 2003 MCSE Training 2003 MCSE Certification 2003 MCSE Boot Camp 2003 MCSE Course 2003 MCSE 2003 Training MCSE 2003 Certification MCSE 2003 Boot Camp MCSE 2003 Course Training MCSE 2003 Certification MCSE 2003 Boot Camp MCSE 2003 Course MCSE 2003 MCSE Training Course MCSE Training Boot Camp MCSE training
MCSE certification MCSE Training Certification
Training MCSE Certification Training MCSE Boot Camp Training MCSE Course MCSE Certification Training MCSE Certification Boot Camp MCSE Certification Course MCSE Boot Camp Training MCSE Boot Camp Course MCSE Course Training MCSE Course Certification MCSD MCSD Training MCSD Certification MCSD Course Certification Training Training Certification Microsoft Certification Certification Microsoft Microsoft Training

Copyright © 2010 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.

MCSE certification boot camps and courses are offered in these select cities:
Albany MCSE, Albuquerque MCSE, Alexandria MCSE, Anchorage MCSE, Atlanta MCSE, Austin MCSE, Billings MCSE, Birmingham MCSE, Bismarck MCSE, Boise MCSE, Boston MCSE, Charleston MCSE, Charlotte MCSE, Cheyenne MCSE, Chicago MCSE, Cincinnati MCSE, Cleveland MCSE, Columbia MCSE, Columbus MCSE, Dallas MCSE, Denver MCSE, Des Moines MCSE, Detroit MCSE, Fort Lauderdale MCSE, Fort Myers MCSE, Hartford MCSE, Honolulu MCSE, Houston MCSE, Indianapolis MCSE, Jackson MCSE, Kansas City MCSE, Las Cruces MCSE, Lincoln MCSE, Little Rock MCSE, Los Angeles MCSE, Louisville MCSE, Madison MCSE, Milwaukee MCSE, Minneapolis MCSE, Montpelier MCSE, New Orleans MCSE, New York City MCSE, Norfolk MCSE, Oklahoma City MCSE, Omaha MCSE, Philadelphia MCSE, Phoenix MCSE, Pierre MCSE, Pittsburgh MCSE, Princeton MCSE, Providence MCSE, Raleigh MCSE, Richmond MCSE, Sacramento MCSE, Salt Lake City MCSE, San Antonio MCSE, San Diego MCSE, San Francisco MCSE, San Jose MCSE, Seattle MCSE, Stamford MCSE, Tulsa MCSE, Washington MCSE, Wilmington MCSE.

MCSE Canada Boot Camps : mcse Calgary, mcse Edmonton, mcse Halifax, mcse Hamilton, mcse Kitchener, mcse London, mcse Montreal, mcse Ottawa, mcse Quebec City, mcse Toronto, mcse Vancouver, mcse Winnipeg.

CED Solutions offers MCSE certification boot camps and courses in the United States and Canada:
MCSE Alabama, MCSE Alaska, MCSE Arizona, MCSE Arkansas, MCSE California, MCSE Colorado, MCSE Connecticut, MCSE District of Columbia, MCSE Delaware, MCSE Florida, MCSE Georgia, MCSE Hawaii, MCSE Idaho, MCSE Illinois, MCSE Indiana, MCSE Iowa, MCSE Kansas, MCSE Kentucky, MCSE Louisiana, MCSE Maine, MCSE Massachusetts, MCSE Michigan, MCSE Minnesota, MCSE Mississippi, MCSE Missouri, MCSE Montana, MCSE Nebraska, MCSE New Jersey, MCSE New Mexico, MCSE New York, MCSE North Carolina, MCSE North Dakota, MCSE Ohio, MCSE Oklahoma, MCSE Pennsylvania, MCSE Rhode Island, MCSE South Carolina, MCSE South Dakota, MCSE Texas, MCSE Utah, MCSE Vermont, MCSE Virginia, MCSE Washington, MCSE West Virginia, MCSE Wisconsin, MCSE Wyoming.

MCSE Canada Boot Camps : Alberta mcse, British Columbia mcse, Manitoba mcse, New Brunswick mcse, Newfoundland mcse, Nova Scotia mcse, Ontario mcse, Saskatchewan mcse. Quebec mcse.