OnBase Database Administration: Overview
SECTION 1: Introduction
| 01 | Introduction | 5 m | ||
| 02 | Activity: Download the Scripts |
SECTION 2: Install and Configure
| 03 | Installation Basics | 2 m | ||
| 04 | Database Components | 6 m | ||
| 05 | SQL Server Database Settings | 9 m |
SECTION 3: Maintenance and Monitoring
| 06 | Maintenance: Backups Overview & Strategy | 8 m | ||
| 07 | Creating and Configuring a Backup | 4 m | ||
| 08 | Integrity Checks | 7 m | ||
| 09 | Optimizations | 9 m | ||
| 10 | Setting Up a Maintenance Plan | 6 m | ||
| 11 | Monitoring and Baselines | 4 m |
SECTION 4: Conclusion
| 12 | Troubleshooting | 5 m | ||
| 13 | Tips and Tricks | 5 m | ||
| 14 | Want more extensive information? |
SECTION 5: Final Assessment (Earn 80% or higher to earn credit)
| 15 | Final Assessment |
Calling all DBAs! This course provides all the basics for understanding, maintaining, and troubleshooting your OnBase Database.
Hyland Database Analysts will guide you to become a more confident database administrator. With a high level overview of a DBA's responsibilities and many practical SQL queries, you will finish this course with a good idea of how to analyze and optimize your system. For more extensive information on topics mentioned in this course, see the related courses listed under Resources & Links.
Please note: This course is best viewed in full screen mode.
- Premium
- P1547
- Expert
- 1 hr 10 mins
- Available with Premium Subscription
This course requires a Premium Subscription. Login to learn more.
Prerequisites
Topics Covered
- Checking your SQL version
- Listing machine and instance name
- Checking last restart date
- Listing all databases in an instance
- Checking the tables for the OnBase database
- Listing indexes for a specific table
- Checking memory allocation for SQL Server
- Checking parallelism configuration
- Checking optimize for ad hoc workloads configuration
- Viewing file and growth settings
- Evaluating your current backup process
- Determining your recovery strategy
- Establishing a SLA
- Restoring a database from a backup
- Checking for corruption
- Checking to see last time statistics were updated
- Manually updating specific statistics
- Updating all statistics on a table
- Rebuilding an index
- Rebuilding all indexes for a table
- Scheduling a maintenance plan