MCSE/MCDBA 2000
Home Page Training
MCSE 2003  7 in 1
MCSE Server 2003 SQL
MCSE/Security 2003
MCSE/MCDBA 2003
MCSE 2003 Value
MCSE 2000 Value
MCSE/MCDBA 2000
MCSE 2000 Security
IIS 5.x
Exchange 2000
Microsoft SQL Training
Windows XP 70-270

MCSE MCDBA MCSA 2000 Certification Training

mcse mcdba mcsa microsoft certification training tutorial course on CDs sqlMCSE MCSA Combo  Training for certification has never been cheaper. For this month only, you can get your certification training on your choice of Class-Room Style Full Multi-Media CD-ROMS or Videos with Exam Quizzers.  

Each course has a Microsoft Certified trainer to take you step by step through your certification training. Getting certified has never been easier.

Ask About MCSE 2003
 

Receive the following

  • Your Choice of over 35 Videos or Full Mutli-Media CD-ROMS covering all seven certification exams  210,215,216,217,218,220 and Security+
  • Seven  Simulated Exam Quizzers
  • Seven E-Books
  • Exam Support Mentoring to Trainers
  • 30 day money Back Guarantee
  • Guarantee to pass**

    • Call for Special Promotional Pricing
    Save over $300.00
    800-617-5586    .

Microsoft MCSE MCDBA MCSA Training Combo for Certification Self Study Course

 

Certified Training Course Contains the following Courses

  • Exam 70-210 Installing, Configuring and Administering Microsoft Windows 2000 Professional
  • Exam 70-215: Installing, Configuring and Administering Microsoft Windows 2000 Server
  • Exam 70-216: Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
  • Exam 70-217: Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure

...and training electives

  • Exam 70-218: Maintaining a Windows 20000 Network
  • Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server™ 2000 Enterprise Edition
  • Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

 Description of Training Courses on Videos and CD-ROMs

Exam 70-210 Installing, Configuring and Administering Microsoft Windows 2000 Professional
  • Windows 2000 Environment
  • Installing Windows 2000 Professional
  • Manual Installations
  • Managing Hardware Devices
  • Upgrading to 2000
  • Unatteneding Installations
  • Users and Groups
  • Sharing Folders
  • NTFS
  • Printing
  • User Profiles
  • Desktop Configuration
  • Password Controls
  • NTFS Features
  • Disk Management
  • Backup and Recovery
  • Application Support
  • Performance Monitoring Dial-up Connection
  • Installation Options
    • Exam 70-215: Installing, Configuring and Administering Microsoft Windows 2000 Server
  • Introduction to Server
  • Installation
  • Installation Problems
  • Service Paks
  • Disk Management
  • Sharing File Resources
  • NTFS Resources
  • Web Resources
  • Printing Resources
  • Distributing File Systems
  • Sytems Recovery
  • Network Configuration
  • DHCP
  • DNS
  • RRAS
  • Upgrading NT 4.0 Servers
  • Terminal Servers
  • Policies and Security

    • Certification Exam 70-216 : Implementing and Administering a Microsoft Windows 2000 Network Infrastructure

  • Overview
  • Network Fundamentals
  • Protocols
  • NWLink
  • TCP/IP
  • IP Addressing
  • Name Resolution
  • DNS
  • INstalling DNS
  • Zone Files
  • WINS
  • Advance WINS
  • Advantages to IP Addressing
  • DHCP Installing
  • Remote Access
  • Remote Access Policies
  • Configuring Virtual Private Networks
  • Remote Acccess Policies
  • NATIPSec
  • Certificte Services
  • IP Routing
  • Custom Subnetting
    • Exam 70-217: Training for Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure
  • Introduction to Active Directory
  • Active Directory Domain Controller
  • Installing Active Directory Domain Controller
  • Users, Groups, & Organizational Units (OUs)
  • Managing Physical Boundaries: Site Management
  • Working with Active Directory Replication Settings
  • Understanding the Domain Name System (DNS) & Active Directory
  • Implementing a DNS Strategy for Active Directory
  • Security Permissions
  • Performance Techniques and Troubleshooting
  • Working with Group Policy Objects
  • Software Deployment
  • Managing Security Policy Setting
  • Working with Security Template Files
  • RIS
  • RIS Workstation Deployment & Configuration Settings
  • Backing Up & Restoring the Active Directory Database
  • Group Policy Inheritance Behavior & Delegation of Control
  • System Auditing with Group Policy Objects
    • Exam 70-218: Designing a Microsoft Windows 2000 Directory Services Infrastructure
  • Delegate Admin Control of Org.Unit
  • Install and Configure DNS Service
  • Identify and Resolve Active Directory Replication Issues
  • Implement Group Policy
  • Manage by Using Group Policy
  • Implement and Manage Web-Based Services in an Intranet
  • Implement and Manage RAS, DHCP, and WINS
  • Troubleshoot Client Computer Startup and User Logon Problems
    • 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.

    • Call for Special Promotional Pricing
    Save over $300.00
    800-617-5586    .

    ***Guaranteed to pass or your money back. Student must provide  proof of failing a current Microsoft MCSE exam more than once with documentation of practice test score above 95% on our practice MCSE exam questions with returned  training course within 180 days of purchase

     

    | Home Page | Product List | A+ | CDi Cisco Certification Training | Classes |
    | CNE Certification Training | Diagnostic Tools | Lotus Note | MCDBA | MCSD | MCSE |
    | Microsoft Office | NT/98/XP/2000 | Unix | Programming | Delphi | Java | Oracle | Web Training |
    | PhotoShop | AutoCAD | QuickBooks | PageMaker |

    This study guide and/ or material is not sponsored by, endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA™, CCDP™, CCNP™, CCIE™, CCSI™, the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc.
    phone

    sales@e-trainonline.com
    Copyright  © CDi Communications Inc 1996-2004

    *30-Day Guarantee applies only if products purchased are returned with 50% of product unopened. For example if product purchased contains 6 videos, 3 must remain unopened.