Educational Services

The education you need to master Aster Database is never far away. Aster Data offers regularly scheduled training courses to bring new users and partners up-to-speed and to help power users and veterans get the most value out of their data.

Courses are offered monthly in a state of the art virtual environment. To schedule a training session, please fill out this training request form.

Courses

Architecture and Migration introduces you to data warehousing concepts as they apply to Aster Database.
Database Administration provides a thorough overview of the administrative tasks required to manage Aster Database.
SQL-MapReduce® for Advanced Analytics is intended for business analysts and developers who will be creating SQL-MapReduce functions.

Detailed Descriptions

More details on each course are included below, as well as the duration and any prerequisites.

Architecture and Migration
The Architecture and Migration class introduces you to data warehousing concepts as they apply to Aster Database. You will learn how Aster Data implements the MPP environment, as well as the components and functionality of Aster Database. Through this course, you will become familiar with the hardware requirements for Aster Database and its ecosystem. You will also learn data warehouse terminology and Aster Database-specific terminology. The tasks related to migrating to Aster Database are discussed.
Duration: .5 day
Prerequisites: Must have a laptop.

Database Administration
This course provides a thorough overview of the administrative tasks required to manage Aster Database. It includes a review of the relational model and how to optimize the logical-to-physical design for implementation on Aster Database. You will learn how to create and manage all database objects including databases, schemas, tables, users, in-database applications, and access rights. You will also learn the fundamentals of Aster Data's Dynamic Workload Management. You will be introduced to the Aster Management Console and other database management utilities used when managing the system, including LINUX utilities such as top, iostat, and vmstat.

You will also learn how to install and upgrade Aster Database software, troubleshoot and monitor Aster Database at the operating system level. You will become even more familiar with the Aster Management Console and other system utilities.

This course is taught through a combination of lecture and hands-on labs where you will put into practice the skills you learn in a controlled environment.
Duration: 1.5 days
Prerequisites: Must have a laptop; Architecture and Migration course; nCluster SQL course or 2 years SQL experience; Familiarity with LINUX or UNIX operating systems

SQL-MapReduce for Advanced Analytics
This course is intended for developers who will be creating SQL-MapReduce functions. The primary language for this class will be Java. You will learn the role of MapReduce functionality and how to implement that functionality at a row or partition level using Aster Data's patented SQL-MapReduce. You will become familiar with existing SQL-MapReduce functions in the Aster MapReduce Analytics Portfolio, and have hands on experience working with the nPath and Stream among other functions.

This course is taught through a combination of lecture and hands-on labs where you will put into practice the skills you learn in a controlled environment.
Duration: 2 days
Prerequisites:Must have a laptop; Architecture and Migration course; Working knowledge of the Java scripting language; Familiarity with LINUX or UNIX operating system editors

Additional Details

These courses can be customized to fit your needs. There may be additional courses available that are not yet listed. If there are other courses you'd like to see, or regions or companies you would like Aster Data Educational Services to visit, please let us know by emailing Aster Data Educational Services.

• Courses are offered to individuals and companies.
  • Enrollment fees are typically on a per-student basis
  • Custom and private offerings are available. Please inquire.
• Other offerings may be available.