AMDSA

The Advanced Manitou Database and System Administrator Course is designed to help our technical-minded customers gain knowledge to manage the Manitou database, including: SQL Queries, Database Maintenance, and custom reports. Upon successful completion of this course, attendees will be permitted to administer their Manitou database, including making light changes, without voiding their warranty.

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 custom reports and importing them into Manitou.

Writing and Troubleshooting SQL Queries including:

  • Select statements
  • Joins
  • Creating views
  • Exception handling

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

Josh Brennan

Instructor

Josh began his career with Bold Group in 2017 as a Data Conversion Specialist and has since been promoted to the cloud team as a IT Developer. He earned his Masters degree in Computer Science with a concentration in Software Engineering in 2018.

Itinerary and Location

Price is $3995 per person. Course fee includes continental breakfast and lunch each day. Course is limited to 14 attendees. No refunds or credits will be issued after 5/17/19
Arrive: 6/3/19 (afternoon or evening)
AMDSA Course: 6/4 & 6/5/19
Depart: late 6/5 (class ends at 4pm) or 6/6/19
Location: Bold Group

Airports and Hotels

COS Airport: 25 mins | Directions
Denver Airport: 80 mins | Directions
Staybridge Suites: 2 mins | Book Here
Holiday Inn Express & Suites: 2 mins | Book Here
Colorado Springs Marriott: 5 mins | Book Here

Course Registration