|
Dual MCDBA MCSA Certification Training
 MCDBA is a Certification for Database Managers from Microsoft. The
certification course combines Network Administration with programming and is an excellent alternative to becoming MCSE certified. The Training course
combines the Administration of a Windows 2003 Server and SQL Server with Design, Implementation and Administration of the SQL Server. Perfect for anyone who wants to be a network administrator and be involved with
programming.
Pre-Requisite:
A+ training, Network+ and some understanding of databases (Access or higher level databases)
Microsoft Dual MCDBA / MCSA Certification Training Tutorial Course on CD-ROM
 Our interactive CBT Curriculum provides everything you need to
become certified.
- Complete Course Material on Interactive CDs .
- Simulated Administrative and Programming practice tasks. (No need for a Windows 2003 or SQL Server). Provides real life experience.
- Practice Test Questions- Assessment exams prepare you for the test and your readiness skill.
- Complete set of E- Books
- Our Guarantee to pass
- One year of free Upgrades
- Phone and email support to trainers to answe your questions
|
MCDBA / MCSA 2003 Training - Set of 25 CDs with Quizzers and 5 E-Books covering exams 70-290, 291,270, 228, and 229
|
sp732003
|
$995.00
|
|
The curriculum covers the following Microsoft Courses
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.
Implement a RAID solution.
Defragment volumes and partitions.
Install and configure server hardware devices.
Configure driver signing options.
Configure resource settings for a device.
Configure device properties and settings.
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.
Identify and modify the scope of a group.
Find domain groups in which a user is a member.
Manage group membership.
Create and modify groups by using the Active Directory Users and Computers Microsoft Management Console (MMC) snap-in.
Create and modify groups by using automation.
Create and manage user accounts.
Create and modify user accounts by using the Active Directory Users and Computers MMC snap-in.
Create and modify user accounts by using automation.
Import user accounts.
Troubleshoot computer accounts.
Diagnose and resolve issues related to computer accounts by using the Active Directory Users and Computers MMC snap-in.
Reset computer accounts.
Troubleshoot user accounts.
Diagnose and resolve account lockouts.
Diagnose and resolve issues related to user account properties.
Troubleshoot user authentication issues.
Managing and Maintaining Access to Resources
Configure access to shared folders.
Manage shared folder permissions.
Troubleshoot Terminal Services.
Diagnose and resolve issues related to Terminal Services security.
Diagnose and resolve issues related to client access to Terminal Services.
Configure file system permissions.
Verify effective permissions when granting permissions.
Change ownership of files and folders.
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.
Manage a server by using Remote Assistance.
Manage a server by using Terminal Services remote administration mode.
Manage a server by using available support tools.
Troubleshoot print queues.
Monitor system performance.
Monitor file and print servers. Tools might include Task Manager, Event Viewer, and System
Monitor.
Monitor disk quotas.
Monitor print queues.
Monitor server hardware for bottlenecks.
Monitor and optimize a server environment for application performance.
Monitor memory performance objects.
Monitor network performance objects.
Monitor process performance objects.
Monitor disk performance objects.
Manage a Web server.
Manage Internet Information Services (IIS).
Manage security for IIS.
Managing and Implementing Disaster Recovery
Perform system recovery for a server.
Implement Automated System Recovery (ASR).
Restore data from shadow copy volumes.
Back up files and System State data to media.
Configure security for backup operations.
Manage backup procedures.
Verify the successful completion of backup jobs.
Manage backup storage media.
Recover from server hardware failure.
Restore backup data.
Schedule backup jobs.
Exam 70-270: Installing, Configuring, and Administering Microsoft Windows XP Professional
Installing Windows XP Professional
Perform and troubleshoot an attended installation of Windows XP Professional.
Perform and troubleshoot an unattended installation of Windows XP Professional.
Install Windows XP Professional by using Remote Installation Services (RIS).
Install Windows XP Professional by using the System Preparation Tool.
Create unattended answer files by using Setup Manager to automate the installation of Windows XP Professional.
Upgrade from a previous version of Windows to Windows XP Professional.
Prepare a computer to meet upgrade requirements.
Migrate existing user environments to a new installation.
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.
Configure, manage, and troubleshoot file compression.
Control access to files and folders by using permissions.
Optimize access to files and folders.
Manage and troubleshoot access to shared folders.
Create and remove shared folders.
Control access to shared folders by using permissions.
Manage and troubleshoot Web server resources.
Connect to local and network print devices.
Manage printers and print jobs.
Control access to printers by using permissions.
Connect to an Internet printer.
Connect to a local print device.
Configure and manage file systems.
Convert from one file system to another file system.
Configure NTFS, FAT32, or FAT 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.
Install, configure, and manage DVD and CD-ROM devices.
Monitor and configure disks.
Monitor, configure, and troubleshoot volumes.
Monitor and configure removable media, such as tape devices.
Implement, manage, and troubleshoot display devices.
Configure multiple-display support.
Install, configure, and troubleshoot a video adapter.
Configure Advanced Configuration Power Interface (ACPI).
Implement, manage, and troubleshoot input and output (I/O) devices.
Monitor, configure, and troubleshoot I/O devices, such as printers, scanners, multimedia devices, mouse, keyboard, and smart card reader.
Monitor, configure, and troubleshoot multimedia hardware, such as cameras.
Install, configure, and manage modems.
Install, configure, and manage Infrared Data Association (IrDA) devices.
Install, configure, and manage wireless devices.
Install, configure, and manage USB devices.
Install, configure, and manage hand held devices.
Install, configure, and manage network adapters.
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.
Optimize and troubleshoot memory performance.
Optimize and troubleshoot processor utilization.
Optimize and troubleshoot disk performance.
Optimize and troubleshoot application performance.
Configure, manage, and troubleshoot Scheduled Tasks.
Manage, monitor, and optimize system performance for mobile users.
Restore and back up the operating system, System State data, and user data.
Recover System State data and user data by using Windows Backup.
Troubleshoot system restoration by starting in safe mode.
Recover System State data and user data by using the Recovery console.
Configuring and Troubleshooting the Desktop Environment
Configure and manage user profiles and desktop settings.
Configure support for multiple languages or multiple locations.
Enable multiple-language support.
Configure multiple-language support for users.
Configure local settings.
Configure Windows XP Professional for 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 computers by using a virtual private network (VPN) connection.
Create a dial-up connection to connect to a remote access server.
Connect to the Internet by using dial-up networking.
Configure and troubleshoot Internet Connection Sharing (ICS).
Connect to resources by 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 auditing.
Configure, manage, and troubleshoot account settings.
Configure, manage, and troubleshoot account policy.
Configure, manage, and troubleshoot user and group rights.
Troubleshoot cache credentials.
Configure, manage, and troubleshoot Internet Explorer security setting.
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.
Manage DHCP clients and leases.
Manage DHCP Relay Agent.
Manage DHCP databases.
Manage DHCP scope options.
Manage reservations and reserved clients.
Troubleshoot TCP/IP addressing.
Diagnose and resolve issues related to Automatic Private IP Addressing (APIPA).
Diagnose and resolve issues related to incorrect TCP/IP configuration.
Troubleshoot DHCP.
Diagnose and resolve issues related to DHCP authorization.
Verify DHCP reservation configuration.
Examine the system event log and DHCP server audit log files to find related events.
Diagnose and resolve issues related to configuration of DHCP server and scope options.
Verify that the DHCP Relay Agent is working correctly.
Verify database integrity.
Implementing, Managing, and Maintaining Name Resolution
Install and configure the DNS Server service.
Configure DNS server options.
Configure DNS zone options.
Configure DNS forwarding.
Manage DNS.
Manage DNS zone settings.
Manage DNS record settings.
Manage DNS server options.
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.
Implement security baseline settings and audit security settings by using security templates.
Implement the principle of least privilege.
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.
Configure remote access authentication protocols.
Configure Internet Authentication Service (IAS) to provide authentication for Routing and Remote Access clients.
Configure Routing and Remote Access policies to permit or deny access.
Manage remote access.
Manage packet filters.
Manage Routing and Remote Access routing interfaces.
Manage devices and ports.
Manage routing protocols.
Manage Routing and Remote Access clients.
Manage TCP/IP routing.
Manage routing protocols.
Manage routing tables.
Manage routing ports.
Implement secure access between private networks.
Troubleshoot user access to remote access services.
Diagnose and resolve issues related to remote access VPNs.
Diagnose and resolve issues related to establishing a remote access connection.
Diagnose and resolve user access to resources beyond the remote access server.
Troubleshoot Routing and Remote Access routing.
Troubleshoot demand-dial routing.
Troubleshoot router-to-router VPNs.
Maintaining a Network Infrastructure
Monitor network traffic. Tools might include Network Monitor and System Monitor.
Troubleshoot connectivity to the Internet.
Troubleshoot server services.
Diagnose and resolve issues related to service dependency.
Use service recovery options to diagnose and resolve service-related issues.
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.
Perform a custom upgrade.
Upgrade to SQL Server 2000 from SQL Server 6.5.
Upgrade to SQL Server 2000 from SQL Server 7.0.
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.
Add filegroups.
Configure filegroup usage.
Expand and shrink a database.
Set database options by using the ALTER DATABASE or CREATE DATABASE statements.
Size and place the transaction log.
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.
Optimize files and filegroups.
Manage database fragmentation.
Modify the database schema.
Perform disaster recovery operations.
Perform backups.
Recover the system state and restore data.
Configure, maintain, and troubleshoot log shipping.
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.
Manage OLE DB Providers.
Configure security mapping.
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.
Add and remove users from roles.
Create roles to manage database security.
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.
Monitor hardware resource usage by using System Monitor.
Resolve system bottlenecks by using System Monitor.
Optimize and troubleshoot SQL Server system activity. Activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput.
Monitor SQL Server system activity by using traces.
Monitor SQL Server system activity by using System Monitor.
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.
Specify entity attributes.
Specify degree of normalization.
Design entity keys. Considerations include FOREIGN KEY constraints, PRIMARY KEY constraints, and UNIQUE constraints.
Specify attributes that uniquely identify records.
Specify attributes that reference other entities.
Design attribute domain integrity. Considerations include CHECK constraints, data types, and nullability.
Specify scale and precision of allowable values for each attribute.
Allow or prohibit NULL for each attribute.
Specify allowable values for each attribute.
Implementing the Physical Database
Create and alter databases. Considerations include file groups, file placement, growth strategy, and space requirements.
Specify space management parameters. Parameters include autoshrink, growth increment, initial size, and maxsize.
Specify file group and file placement. Considerations include logical and physical file placement.
Specify transaction log placement. Considerations include bulk load operations and performance.
Create and alter database objects. Objects include constraints, indexes, stored procedures, tables, triggers, user-defined functions, and views.
Specify table characteristics. Characteristics include cascading actions, CHECK constraints, clustered, defaults, FILLFACTOR, foreign keys, nonclustered, primary key, and UNIQUE constraints.
Specify schema binding and encryption for stored procedures, triggers, user-defined functions, and views.
Specify recompile settings for stored procedures.
Specify index characteristics. Characteristics include clustered, FILLFACTOR, nonclustered, and uniqueness.
Alter database objects to support replication and partitioned views.
Support merge, snapshot, and transactional replication models.
Design a partitioning strategy.
Design and create constraints and views.
Resolve replication conflicts.
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.
Implement error handling in stored procedures, transactions, triggers, and user-defined functions.
Pass and return parameters to and from stored procedures and user-defined functions.
Validate data.
Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views.
Specify trigger actions.
Design and manage transactions.
Manage control of flow.
Filter data by using stored procedures, 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.
Apply ownership chains.
Use programming logic and objects. Considerations include implementing row-level security and restricting direct access to tables.
Define object-level security including column-level permissions by using GRANT, REVOKE, and DENY.
Create and manage application roles.
Join the following companies who have used Netwind Learning Center for their training:
|
Ashley Furniture
City of Springfield
College of Staten Island
Compaq Computer
Diebold Inc
FSD145 Freeport School District
Milwaukee Public Schools |
Northeastern Illinois University
Petro Hunt LLC
State of Maine Dept. of Labor
Sysco Food Service
US Bankruptcy Court
US Navy EFD
Willis-Knighton Medical Center |
|
