Why this course?

Description

AsterixDB is a BDMS (Big Data Management System) with a rich feature set that sets it apart from other Big Data platforms. Its feature set makes it well-suited to modern needs such as web data warehousing and social data storage and analysis.

Managing large, complex, and diverse datasets is one of the biggest challenges in today’s data-driven world. Traditional relational databases often fall short when it comes to handling semi-structured data, high scalability, and distributed environments. This is where Apache AsterixDB comes in — a powerful open-source Big Data Management System designed for the next generation of applications.

Apache AsterixDB is a highly scalable, NoSQL + SQL++ hybrid database system that brings together concepts from relational databases, semi-structured stores, and big data platforms. With built-in support for semi-structured data (JSON), advanced indexing, and a flexible query language (SQL++), it allows developers and data engineers to efficiently store, query, and analyze massive datasets.

This beginner-friendly course, Apache AsterixDB for Beginners, takes you step by step from installation to practical querying. You’ll learn the Asterix Data Model (ADM), practice creating and managing datasets, load and query data using SQL++, and perform real-world operations like indexing, aggregation, and bulk loading. By the end of this course, you will be equipped with the foundational skills needed to start working with Apache AsterixDB in data engineering or analytics projects.

What You’ll Learn

By the end of this course, you will be able to:

• Understand what Apache AsterixDB is, its performance benefits, and key features.
• Install and manage Apache AsterixDB on your system (start, stop, configure).
• Work with the Asterix Data Model (ADM), including dataverses, datatypes, datasets, and advanced types.
• Create and manage datasets, define indexes, and perform data operations like loading, deleting, and bulk data loading.
• Query and analyze data using SQL++, AsterixDB’s flexible query language.
• Apply SQL++ functions including arithmetic, logical, string, tokenizing, aggregate, and comparison functions.
• Understand real-world use cases and applications of AsterixDB in modern data systems.

 

Course Structure

The course is organized into 5 comprehensive sections with 30 lectures, covering both fundamentals and hands-on practice:

1. Introduction – Get an overview of AsterixDB, its features, performance, and real-world applications.
2. Installation of Apache AsterixDB – Step-by-step installation, startup, and shutdown procedures.
3. Asterix Data Model (ADM) – Learn about dataverses, datasets, datatypes, and how AsterixDB structures and manages data.
4. AsterixDB Primer – Hands-on practice creating datasets and indexes, loading data, running lookups, performing aggregations, and managing bulk data loads.
5. SQL++ Query Language – Explore SQL++ operators and functions, including arithmetic, logical, numeric, string, aggregate, tokenizing, and comparison functions.

 

What will students learn in your course?

• Understand what Apache AsterixDB is, its performance benefits, and key features.
• Install and manage Apache AsterixDB on your system (start, stop, configure).
• Work with the Asterix Data Model (ADM), including dataverses, datatypes, datasets, and advanced types.
• Create and manage datasets, define indexes, and perform data operations like loading, deleting, and bulk data loading.
• Query and analyze data using SQL++, AsterixDB’s flexible query language.
• Apply SQL++ functions including arithmetic, logical, string, tokenizing, aggregate, and comparison functions.
• Understand real-world use cases and applications of AsterixDB in modern data systems.
• Example: Complete a case study to manage a project from conception to completion

 

What are the requirements or prerequisites for taking your course?

• Basic Knowledge of SQL and Database
• Desktop or Laptop with Ubuntu Operating System and Minimum 8 GB RAM is recommended

 

Who is this course for?

• Beginners in Big Data who want to learn about next-generation data management systems.
• Data Engineers & Developers interested in exploring Apache AsterixDB as a scalable alternative to traditional RDBMS and NoSQL systems.
• Database Administrators & Analysts who want to expand their skills to semi-structured and distributed databases.
• Students & Enthusiasts looking to get hands-on experience with SQL++ and open-source big data technologies.