Course Overview
This course covers the fundamentals of the powerful and versatile SDM platform. You will learn how to install, configure, and support the SDM environment. SDM allows you to easily copy/move inactive data out of your production databases and into less expensive storage. You will learn access methods that enable you to query data, preserve DB data for purposes of corporate governance and e-discovery, and improve performance by removing older, inactive data from your production database. The course is composed of walk-through demonstrations followed by hands-on practical exercises with each student having access to their own Virtual Machine (VM).
Who should attend
This course is intended for Information Technology Administrators, System Engineers, DBA’s, Project Managers, Professional Services, Sales, and Consultants.
Prerequisites
To be successful in this course, you should have the following prerequisites or knowledge:
- System and Network Administration or equivalent experience is suggested
Course Objectives
Upon successful completion of this course, you should be able to:
- Discuss the purpose and benefits of the Structured Data Manager (SDM) technology
- Learn how to use the SDM Web Console and Designer interfaces
- Install SDM in an MSSQL environment
- Configure Database Modeling using Designer
- Configure Business Flow Management using Web Console
- Configure SDM Cartridges, Schema Archives, Database to File Archives, Database to Database Archives, and 3 Tier Archives (Database to Database to File)
- Configure and use the Archive Query Server
- Understand archive access and transparency
- Perform basic SDM administration and troubleshooting
Course Content
- Module 1: SDM Introduction
- Module 2: SDM Architecture and Overview
- Module 3: SDM Web Console
- Module 4: SDM Designer
- Module 5: SDM Basic Installation - MSSQL
- Module 6: SDM Database Modeling
- Module 7: SDM Business Flow Management
- Module 8: SDM IDOL Basics
- Module 9: SDM Cartridges
- Module 10: SDM Schema Archive
- Module 11: SDM Database to File Archive
- Module 12: SDM Database to Database Archive
- Module 13: SDM 3 Tier Archive
- Module 14: SDM Archive Query Server
- Module 15: SDM Archive Access Transparency
- Module 16: SDM Administration
- Module 17: SDM Course Wrap-up