The MDACC includes comprehensive classroom instruction in a hands-on learning environment and incorporates the Manitou Lab where users can practice course material with Bold’s staff of senior-level Manitou instructors.
Limited to 12 users, this course offers each attendee the opportunity to have individual questions addressed in detail – in a one-on-one setting.
Users who successfully complete the MDACC become a Certified Manitou Database Administrator (CMDA). This title is valid for two years following course completion.
Course Topics Include:
Session 1
·
SQL Server 2005 Server Administration
· SQL Server Services
· Configuring an Instance of SQL Server
· Managing Databases
· Modifying Database Configuration and Data Storage
· SQL Server Internals
• Protecting SQL Server Data
• Proper Backup Strategy
• Database Maintenance
• Database Replication
• Configuring and Monitoring Replication Using the MDM
Session 2
· Writing SQL Queries
• Executing Queries
• Understanding Execution Plans
• Manitou Data Structure
• Query Designer
• Joins and Multiple Table Queries
• Advanced Queries: Sub Queries, Sequences
· Custom Reports
• SQL Server Reporting Services
• Organizing Data Using Views
• Writing a Basic Report
• Sub Reports and Advanced Data Regions
Session 3
· Capacity Planning and Monitoring
• Areas of Capacity Management
• Tools for Monitoring Server Load
• Designing a New System or System Upgrade
· Manitou Signal Processing
• Understanding Manitou Signal Processing
• Troubleshooting Signal Processing
• Using a Demonstration FEP
• Signal Formats