Advanced Manitou Database & System Administrator (AMDSA)

Advanced Manitou Database & System Administrator (AMDSA)

Advanced Manitou Database & System Administrator (AMDSA)

Summary

A Database administrative course for Manitou Database and Systems Administrators

Description

Course Description:

The Advanced Manitou Database and System Adminstrator Course is designed to help our technical-minded customers gain knowledge to manage the Manitou database, including:  SQL Queries, Database Maintenance, and custom reports.

Course Objectives

Upon completion of this course learners should feel confident:

• Conducting regular Database Maintenance.

• Creating Maintenance Plans in Microsoft SQL Server Management Studio.

• Restoring a Database in the event of a failure.

• Troubleshooting Database issues.

• Writing and Troubleshooting SQL Queries including

• Select statments

• Joins

• Creating views 

• Exception handling

• Writing custom reports and importing them into Manitou.

 

Prerequisites

Prior to attending class learners should have a quality understanding of:

• Manitou Systems Basics Series (BoldU BTT104)

• General Manitou functionality, specifically Report Templates.

• Completion of the Pre-course survey.

 

Successful Completion Requirements

In order to receive a completion certificate, all attendees receive an attendance certificate, learners are expected to do the following:

• Complete all prerequisites

• Attend all course hours

• Successfully complete the Assessment

Course Schedule

Day 1

• Introduction to Course

• Database Maintenance

• Database  Recovery and Disaster Planning

Day 2

• SQL Queries

• Basics

• Importing Data

• Joins

• Views

• Reporting

• Queries for Reports

• Building Reports

• Testing Reports

• Importing Reports into Manitou

• Exceptions

• Transactions

• Troubleshooting

Duration

2 Days

Audience

IT and Manitou System Administrators

Upcoming Classes

No classes have been scheduled, but you can always Request a Quote.

Onsite Training

For groups of three or more

Request Quote

Public Training

Advanced Manitou Database & System Administrator (AMDSA) Ratings

Training Organized
Training Objectives
Training Expectations
Training Curriculum
Training Labs
Training Overall

What do these ratings mean?