Phone Orders CALL 800-617-5586
Hours 9:00 am to 7:00 PM EST Monday-Friday |
MCDBA Microsoft Certification Training |
MCDBA Self Study Kit Microsoft Database Manager Certification Demo Price: $1,195.00 Product Highlights: Interactive Self-Paced training on CD-ROM. Learn anytime, anywhere.
- Integrated Test-Prep (WorkOut) to ensure you are exam ready.
- All study material is Microsoft Approved.
- Includes Performance Tracking to keep you organized.
- A complete solution to prepare you for certification!
The MCDBA Self Study Kit consists of courses that cover the knowledge and skills required to pass the following MCDBA Exams: Core Exams
- Designing and Implementing Databases with Microsoft SQL Server 7.0 (MS Exam 70-029)
- Administering Microsoft SQL Server 7.0 (MS Exam 70-028)
- Implementing and Supporting Microsoft Windows NT Server 4.0 (MS Exam 70-067)
- Implementing and Supporting Microsoft NT Server 4.0 in the Enterprise (MS Exam 70-068)
Elective Exam
- Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0 (MS Exam 70-175)
NIIT's MCDBA Self Study Kit packs over 300 hours of highly interactive self paced instruction delivered across 28 titles. This self study kit helps you
prepare for the MCDBA exams. Each title is individually certified by Microsoft for depth and breadth of subject matter coverage for the MCDBA exams.
The NIIT MCDBA Self Study Kit uses the "Learn by Doing" paradigm to ensure that as a part of your learning experience, you practice concepts and
procedures covered in the courses in a real life environment. Practice sessions consist of hints that guide a learner towards the correct solution to a
problem. Practice sessions also contain sample solutions. All practice sessions contain diagnostic and/or prescriptive feedback that reinforces learning and enables remedial learning. The courses simulate software so
you do not have to purchase expensive software to complete the learning experience. The NIIT Self Study Kit ensures that you are the master of your art by the time you complete the learning experience.
Each course comes with WorkOut, NIIT's exclusive integrated test preparation software that simulates each Microsoft Certification Exam. WorkOut helps you
determine your preparedness for the certification exam. Advanced learners can attempt WorkOut as a pre-test to check their understanding of the concepts and skills covered in each course. Based on the pre-test, learners
can choose topics for additional study. This increases the efficiency of learner time spent on learning material. It also serves as a learning tool by giving you feedback to help you focus your training efforts.  Each title in this self study kit consists of job aids such as
quick reference guides and glossary of terms. Quick reference guides are used to detail new features, comparisons, additional facts / data / information. The glos sary provides
definitions of terms used in the learning material. Each glossary item has related terms available as hyperlinks to provide for easy navigation while you reference.
Duration Over 300 hours
Audience This curriculum is intended for professionals who are preparing for the MCDBA exams. Benefits After completing this curriculum, you will be able to:
- Develop logical and physical database design
- Create and use filegroups
- Create and manage databases and tables
- Retrieve rows, columns, conditional rows, and specific columns from a table, using operators and functions
- Format and sort query results and generate summary reports
- Retrieve data from multiple tables
- Retrieve data using views
- Implement entity integrity, domain integrity, and referential integrity
- Create and execute stored procedures
- Optimize query performance
- Manage and implement distributed transactions
- Execute queries on Linked Servers
- Execute remote stored procedures
- Import and export data using BCP
- Import and export data using DTS
- Install and configure SQL Server 7.0.
- Implement Windows NT and SQL Server security.
- Create, manage, and maintain SQL Server 7.0 databases.
- Design and implement database security.
- Back up and restore system databases and user databases
- Automate SQL Server administration tasks using alerts and jobs
- Transfer data from different data sources to SQL Server.
- Implement full-text search in SQL Server databases for accessing data.
- Enable access to remote data using linked servers.
- Manage replication of databases.
- Monitor and optimize the performance of SQL Server
- Diagnose and resolve problems encountered in administering SQL Server 7.0.
- Install Windows NT Server using different options
- Support applications such as POSIX, OS/2, WIN 16, WIN 32, WIN 3.x and MS-DOS
- Manage User Accounts and Groups
- Establish trust relationships between domains
- Manage Domain Controllers
- Configure NT network components and services
- Set up and manage directory replication and manage the NT Server file system
- Implement an appropriate fault tolerance method
- Manage the boot process and backup and restore data
- Use system policy editor and registry editor
- Integrate Windows NT Server with NetWare, Apple Macintosh and UNIX systems
- Install and configure IIS
- Implement and troubleshoot RAS
- Set up the printing environment
- Monitor processor activity, disk activity, network activity and server memory
- Identify the hardware requirements for installing Windows NT Server 4.0
- Install, configure, and upgrade to Windows NT Server 4.0
- Identify types of installation and perform Unattended Installation
- Install Windows NT Server on RISC based machines
- Set up a dual-boot system
- Create startup disk and disk sets to perform network installation on clients such as: Microsoft Windows 95, Microsoft network Client for MS-DOS ver 3.0, Microsoft Lan manager for MS-DOS ver 2.2c, and
Microsoft LAN manager for OS/2 ver 2.2c .
- Troubleshoot installation problems and uninstall Windows NT Server 4.0
- Support applications such as MS-DOS, Win16, Win32, POSIX, Windows 3.x, and OS/2 in NT
- Develop simple Visual Basic 6.0 applications
- Debug Visual Basic applications and handle all types of runtime errors
- Develop COM components using Visual Basic 6.0, that expose properties, methods, and events
- Develop Visual Basic client applications that use COM components
- Develop Visual Basic applications that access data from a server in a distributed environment
- Install and configure Microsoft Transaction Server to implement the business services in a distributed application
- Develop MTS components that support transactions
- Debug and optimize the performance of a distributed application
- Develop Internet applications using Active Server Pages, Webclasses, DHTML, and ActiveX documents
- Package and deploy distributed applications
- Configure DCOM applications
Pre-requisites
To benefit from the curriculum, you should be familiar with:
- Fundamentals of the functions of computer components such as CPU, RAM
- Performing basic tasks using the Windows GUI. This includes tasks such as configuring the desktop, starting applications
- Basic networking concepts such as protocols, LANs, Network adapter cards, Internet
- Outline
Outline
Designing and Implementing Databases with Microsoft SQL Server 7.0 (MS Exam 70-029)
- MS SQL Server 7.0 - Introducing SQL Server Architecture
- MS SQL Server 7.0 - Retrieving Information
- MS SQL Server 7.0 - Implementing Data Integrity
- MS SQL Server 7.0 - Optimizing Query Performance
- MS SQL Server 7.0 - Managing Data Processing
- MS SQL Server 7.0 - Accessing Remote Data
Administering Microsoft SQL Server 7.0 (MS Exam 70-028)
- MS SQL Server 7.0 - Installing and Configuring
- MS SQL Server 7.0 - Managing Databases - Part 1
- MS SQL Server 7.0 - Managing Databases - Part 2
- MS SQL Server 7.0 - Automating Tasks and Loading Data
- MS SQL Server 7.0 – Replication and Server Performance
Implementing and Supporting Microsoft Windows NT Server 4.0 (MS Exam 70-067)
- MS NT Server 4.0: Implementing the Windows NT Server
- MS NT Server 4.0: Supporting the NT Server
- MS NT Server 4.0: Networking the NT Server
Implementing and Supporting Microsoft NT Server 4.0 in the Enterprise (MS Exam 70-068)
- MS NT Server 4.0: Planning for NT Server
- MS NT Server 4.0: Installation and Configuration
- MS NT Server 4.0: Managing Resources
- MS NT Server 4.0: Monitoring and Optimization - 1
- MS NT Server 4.0: Internetworking NT Server
- MS NT Server 4.0: Monitoring and Optimization - 2
- MS NT Server 4.0: Configuring Server Resources
- MS NT Server 4.0: Troubleshooting NT Server
Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0 (MS Exam 70-175)
- MS Visual Basic 6.0 - Visual Basic 6 Fundamentals
- MS Visual Basic 6.0 - Debugging and Compiling Applications
- MS Visual Basic 6.0 - Building COM Components
- MS Visual Basic 6.0 - Accessing Data in Distributed Systems
- MS Visual Basic 6.0 - Building Components with MTS
- MS Visual Basic 6.0 - Creating Internet Applications
System Requirements The minimum system requirements are:
- 80486 DX processor or higher
- 8 MB RAM (more RAM improves performance)
- VGA or higher monitor
- MS-Windows mouse
- 15 MB free disk space
- MS Windows 3.1 or higher
Microsoft Database Manager Certification |
#mcdba |
$1,195.00 |
|
|
