Apache Asterixdb For Beginners (Big Data Management System)

AsterixDB is a BDMS (Big Data Management System) with rich feature set that sets it apart from other Big Data platforms

What you'll learn

Why Apache AsterixDB is necessary for Data Engineer

The goal of this course is to help you become familiar with Apache AsterixDB bits and bytes

Learn A to Z of Apache AsterixDB (Basic level).

Hands on Experience on Apache AsterixDB and Real-time Use Case

Requirements

Basic Knowledge of SQL and Database

Desktop or Laptop with Ubuntu Operating System and Minimum 8 GB RAM is recommended

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. We will learn Introduction to AsterixDBPerformance of Apache AsterixDBKey FeaturesExample of Product using AsterixDBInstallation of Apache AsterixDBAsterix Data Model (Dataverse, Datatype, Dataset)Creating Dataset and IndexLoading Data into AsterixDBArithmetic OperatorsLogical OperatorsNumeric FunctionsString FunctionsTokenizing FunctionsAggregate Functions (Array Functions)Comparison FunctionsThis course is designed for Beginners in Apache AsterixDB and looking out for a new job as Data Engineer, Big data Engineers or Developers,  Software Developer.You'll walk away from this course with a real, deep understanding of Apache AsterixDB and its associated distributed systems, and you can apply it to real-world problems. Plus a valuable completion certificate is waiting for you at the end!AsterixDB has:Data modelA semistructured NoSQL style data model (ADM) resulting from extending JSON with object database ideasQuery languagesTwo expressive and declarative query languages (SQL++ and AQL) that support a broad range of queries and analysis over semistructured dataScalabilityA parallel runtime query execution engine, Apache Hyracks, that has been scale-tested on up to 1000+ cores and 500+ disksNative storagePartitioned LSM-based data storage and indexing to support efficient ingestion and management of semistructured dataExternal storageSupport for query access to externally stored data (e.g., data in HDFS) as well as to data stored natively by AsterixDBData typesA rich set of primitive data types, including spatial and temporal data in addition to integer, floating point, and textual dataIndexingSecondary indexing options that include B+ trees, R trees, and inverted keyword (exact and fuzzy) index typesTransactionsBasic transactional (concurrency and recovery) capabilities akin to those of a NoSQL store

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 AsterixDB

Lecture 3 Performance of Apache AsterixDB

Lecture 4 Key Features

Lecture 5 Tips to Improve Your Course Taking Experience

Lecture 6 Example of Product using AsterixDB

Section 2: Installation of Apache AsterixDB

Lecture 7 Installation Steps for Apache AsterixDB

Lecture 8 Starting Apache AsterixDB

Lecture 9 Stopping Apache AsterixDB

Section 3: Asterix Data Model

Lecture 10 Dataverses

Lecture 11 Datatypes

Lecture 12 Datasets

Lecture 13 Primitive Type

Lecture 14 Incomplete Information Types

Lecture 15 Derived Types

Section 4: ASTERIXDB PRIMER

Lecture 16 Creating Datasets and Indexes

Lecture 17 Loading Data Into AsterixDB

Lecture 18 Exact-Match Lookup

Lecture 19 Simple Aggregation

Lecture 20 Deleting Existing Data

Lecture 21 Loading New Data in Bulk (Loading Data from File)

Section 5: SQL++ Query Language

Lecture 22 Introduction to SQL++

Lecture 23 Arithmetic Operators

Lecture 24 Logical Operators

Lecture 25 Numeric Functions

Lecture 26 String Functions

Lecture 27 Tokenizing Functions

Lecture 28 Aggregate Functions (Array Functions)

Lecture 29 Comparison Functions

Lecture 30 Bonus Lecuture

Software Engineer, Software Developer, Big Data Engineer, Data Engineer, Data Analyst, Data Scientist, Machine Learning Engineer,You should take this course if want to learn Apache AsterixDB completely from scratch