Microsoft Certified
Database Administrator
(MCDBA)
| MCDBA Certification |
£1680 |
 |
MCDBA
Certification Exam and Course Highlight |
MCDBA Certification
Exam 70–228: |
Installing, Configuring, and
Administering SQL Server 2000 |
MCDBA Certification Exam
70–229: |
Designing and Implementing Databases
with SQL Server 2000 |
MCDBA Certification Exam
70-291 |
Implementing, Managing, and
Maintaining a Server 2003 Network
Infrastructure |
MCDBA Certification
Exam 70-293 |
Planning and Maintaining a Server
2003 Network Infrastructure |
|
|
|
End
2 End Process
|
Enrolment
Phone or In Person
Course Fee £1680 |
|
|
|
Books
and Course
Material Included |
| |
|
|
| |
|
Hands-on
instructor
led Training for
12
weeks, Unlimited Pratice Hours |
| |
|
|
| |
|
Free MCDBA Mock
Exam |
| |
|
|
| |
|
Actual MCDBA Exam
done @ BCOC
Fee not included |
| |
|
|
| |
|
MCDBA Certified |
|
| |
|
|
| |
|
|
Exam 70–228 - Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
Overview of MS-SQL Server
Introduction to SQL Server`
Client/Server Architecture
Role of Network Administrator
Role of Database Administrator
Role of Web Master
DBA Responsibility
SQL Server and Features
Architecture, Reliability
Service Manager, Enterprise Manager, Query Analyser
Installation and Upgrading SQL Server
Planning and Installation, Upgrade
Management and Configuration
Starting, Stopping SQL server, Enterprise Manager,
Registering Server, Connecting to SQL Server,
Manager Server Configurations, Logins, Server Roles,
Manage Database, Users and Object,
Monitor User Activity,
Manage Logs and Errors
SQL Languages
Create Statement
Insert Statement,
Select Statement,
Update Statement,
Alter Statement
Stored procedures,
Triggers,
Views, and user-defined functions
Sub Queries
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.
Programming Business Logic
Manage data manipulation by using stored procedures,
Transactions, triggers, user-defined functions, and views
Configuration and Tuning SQL Server
Configuring SQL Server and Client
Memory, Configuring Parameters
Data Storage and Managing Databases
Creating Database
Viewing Information
Database Options
Renaming Database
Deleting Database
Moving Database Files
Managing SQL Server Users and Security Features
SQL Server Login
Configure mixed security modes or Windows Authentication.
Considerations include client connectivity,
Client operating system, and security infrastructure.
Create and manage logons.
Create and manage database users.
Add and remove users from roles
Create roles to manage database security
Set permissions in a database
Considerations include object permissions, object ownership, and statement permissions
Guest User, Permission
Managing Logins
Database Access and Database Roles
Removing Logins
Changing Passwords
Lever of Security
Granting and Revoking Object Permissions
Role-Base Security Management
Stored Procedure for Data Security
Database Backup and Recovery
Backup and Recovery Overview
Planning Backups
Performing a Backup
Automating Backups
Backup Strategies
Restoring User Database
Auto Recovery
Extracting and Transforming Data with SQL Server 2000
Set up IIS with the XML
Importing and Exporting Data
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.
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.
Implementing, Managing, and Maintaining a Microsoft
Windows Server 2003 Network Infrastructure - MCDBA
Certification Exam 70-291
Implementing, Managing, and Maintaining IP Addressing
Configure TCP/IP addressing on a windows server
2003 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 windows server
2003 audit log files to find related events.
Diagnose and resolve issues related to configuration
of DHCP server 2003 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 2003 service.
Configure DNS in windows server 2003 options.
Configure DNS zone options.
Configure DNS forwarding.
Manage DNS
Manage DNS zone settings.
Manage DNS record settings.
Manage DNS windows server 2003 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.
Install and configure software update infrastructure
Install and configure software update services.
Install and configure automatic client update settings.
Configure software updates on earlier operating
systems.
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 2003.
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 windows server 2003 services.
Diagnose and resolve issues related to service dependency.
Use service recovery options to diagnose and resolve
service-related issues.
Planning and Maintaining a Microsoft Windows
Server 2003 Network Infrastructure - MCDBA Certification
Exam 70-293
Planning and Implementing Server 2003 Roles
and Server 2003 Security
Configure security for windows servers 2003 that
are assigned specific roles.
Plan a secure baseline installation.
Plan a strategy to enforce system default security
settings on new systems.
Identify client operating system default security
settings.
Identify all windows server 2003 operating system
default security settings.
Evaluate and select the operating system to
install on computers in an enterprise
Identify the minimum configuration to satisfy security
requirements.
Planning, Implementing, and Maintaining a Network
Infrastructure
Plan a TCP/IP network infrastructure strategy.
Analyze IP addressing requirements.
Plan an IP routing solution.
Create an IP subnet scheme.
Plan and modify a network topology
Plan the physical placement of network resources.
Identify network protocols to be used.
Plan an Internet connectivity strategy
Plan network traffic monitoring. Tools might include
Network Monitor and System Monitor.
Troubleshoot connectivity to the Internet.
Diagnose and resolve issues related to Network Address
Translation (NAT).
Diagnose and resolve issues related to name resolution
cache information.
Diagnose and resolve issues related to client configuration.
Troubleshoot TCP/IP addressing
Diagnose and resolve issues related to client computer
configuration.
Diagnose and resolve issues related to DHCP server
2003 address assignment.
Plan a host name resolution strategy
Plan a DNS namespace design.
Plan zone replication requirements.
Plan a forwarding configuration.
Plan for DNS security.
Examine the interoperability of DNS with third-party
DNS solutions.
Plan a NetBIOS name resolution strategy
Plan a WINS replication strategy.
Plan NetBIOS name resolution by using the Lmhosts
file.
Troubleshoot host name resolution
Diagnose and resolve issues related to DNS services.
Diagnose and resolve issues related to client computer
configuration.
Planning, Implementing, and Maintaining Routing
and Remote Access
Plan a routing strategy.
Identify routing protocols to use in a specified
environment.
Plan routing for IP multicast traffic.
Plan security for remote access users
Plan remote access policies.
Analyze protocol security requirements.
Plan authentication methods for remote access clients.
Implement secure access between private networks
Create and implement an IPSec policy.
Troubleshoot TCP/IP routing.
Tools might include the route, tracert, ping, pathping,
and netsh
commands and Network Monitor.
Planning, Implementing, and Maintaining Server
2003 Availability
Plan services for high availability.
Plan a high availability solution that uses clustering
services.
Plan a high availability solution that uses Network
Load Balancing.
Identify system bottlenecks, including memory,
processor, disk, and network related bottlenecks
Identify system bottlenecks by using System Monitor.
Recover from cluster node failure
Planning and Maintaining Network Security
Configure network protocol security.
Configure protocol security in a heterogeneous client
computer environment.
Configure protocol security by using IPSec policies.
Configure security for data transmission.
Configure IPSec policy settings.
Plan for network protocol security
Specify the required ports and protocols for specified
services.
Plan an IPSec policy for secure network communications.
Plan secure network administration methods
Create a plan to offer Remote Assistance to client
computers.
Plan for remote administration by using Terminal
Services.
Plan security for data transmission
Secure data transmission between client computers
to meet security requirements.
Secure data transmission by using IPSec.
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.
Identify the appropriate type of certificate authority
to support certificate issuance requirements.
Plan the enrollment and distribution of certificates.
Plan for the use of smart cards for authentication.
Plan a framework for planning and implementing
security
Plan for security monitoring.
Plan a change and configuration management framework
for security. |
