Alibaba Cloud: The Fundamentals of Database

Leverage your skills to the maximum level with Alibaba Cloud Digital Talent program.

Digital Talent Scholarship program is initiated by Indonesia Ministry of Communications and Informatics, and it is sponsored by Alibaba Cloud Academy. We provide our Membership and lab coupon to Indonesian participants only FOR FREE so that you will get FREE access to all Apsara Clouder courses, certifications and labs below!

To deepen your understanding of cloud computing knowledge in each Stage, we have scheduled three recap courses at
(1) 7PM-9PM JKT on March 18th,
(2) 7PM-9PM JKT on March 25th,
(3) 7PM-9PM JKT on April 1st.
To make sure of the course quality, you are required to finish all the self-training materials in Stage I before March 18th, Stage II before March 25th, and Stage III before April 1st.

Target Audience

Fresh Graduates

Students

IT Developers

Stage I: Alibaba Cloud Relational Database Services

Course Name

Objective

Week 1 Onboarding

7PM-8PM JKT, March 9th

In this meeting, you will better understand how DTS program works. You will also get to know how to utilize this self-training learning path and how to gain Alibaba Cloud Associate (ACA) Database Training and Certification for free.

Join the meeting

Week 1 Introduction

The Past, Present, Future Of Database Technology

This is a live chat upon database technology between Thomas Heinis, "Professor" in Data Management at Imperial College London, and Feng Shen, Tech Lead at Alibaba Cloud Data Lake Analytics. They will focus on database analysis and share their insights on the past, present and the future of database technology.

Start to learn

Week 1 ApsaraDB

2021 with ApsaraDB | Journey of Alibaba Cloud Cloud-Native Database

In this video, you will learn Alibaba Cloud Database Products Portfolio and how ApsaraDB powered Alibaba Double 11 Global Shopping Festival in 2021. This helps you better understand Alibaba Cloud Database products and services.

Start to learn

Week 1 RDS

The Basic Use of RDS - 1. Connect ApsaraDB RDS MySQL Single Instance

In this video, you will see the differences between connecting to an ECS-hosted MySQL database and to an ApsaraDB RDS MySQL on Alibaba Cloud. This helps you better understand the new way of cloud database connection.

Start to learn

Week 1 RDS

The Basic Use of RDS - 2. Build LAMP Applications With ApsaraDB RDS MySQL

In this video, you will learn comprehensive details about building a basic LAMP application with ApsaraDB instead of MySQL database on premise. It can be a good material if you wannt to build your own LAMP applications from ground or to migrate your existing applications to the cloud.

Start to learn

Week 1 RDS

The Basic Use of RDS - 3. Import & Export To and From ApsaraDB RDS MySQL

In this lesson, you will be able to learn how to import data from ECS-hosted MySQL or on-premise MySQL to ApsaraDB RDS MySQL through both CLI and DMS (Data Management provided by Alibaba Cloud). Meanwhile, one way to export data from RDS MySQL using Alibaba Cloud Data Management-DMS will be introduced through a vivid demonstration.

Start to learn

Week 1 RDS

The Basic Use of RDS - 4. Introduction To ApsaraDB RDS MySQL Series

In this video, we will introduce the ApsaraDB RDS for MySQL series, including three types which are Basic Edition (also named as single instance), High-Availability Edition with two nodes, and Enterprise Edition with three nodes. The engine versions support from MySQL 5.5 to MySQL 8.0.

Start to learn

Week 1 RDS

ApsaraDB for RDS

ApsaraDB RDS is a stable, reliable, and scalable online database service that is built on top of the Apsara Distributed File System and high-performance SSDs of Alibaba Cloud. ApsaraDB RDS supports the MySQL, SQL Server, PostgreSQL, and MariaDB TX database engines.

Start to learn

Week 1 RDS Hands-On Lab

Build a Relational Database Using RDS

This experiment is designed to build a relational database through RDS. RDS for MySQL is used as an example.

Start the lab

Week 1 PolarDB

Alibaba Cloud ApsaraDB for PolarDB Technical Essentials

ApsaraDB for PolarDB is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle. ApsaraDB for PolarDB provides the performance and availability of traditional enterprise databases and the flexibility and cost-effectiveness of open-source databases. By learning this online course, you will not only get familiar with Alibaba Cloud database products portfolio but also know most of the technical features PolarDB will provide. We also provide comprehensive operation demo including cluster creation, endpoints management, system monitoring, etc. for your hands-on reference.

Start to learn

Week 1 PolarDB

PolarDB Tutorial: Java JDBC Program with PolarDB High Availability

In this tutorial, you will see an example that Java JDBC program work with the PolarDB high availability feature.

Start to learn

Flip Virtual Class

7PM-9PM JKT, March 18th

In this trainer-led class, the trainer will recap the developement history of database technology as well as key points of Alibaba Cloud products and services, including ApsaraDB for RDS and PolarDB. There will also be a Q&A session for you to clarify your confusions while learning the courses by yourselves. Instructor will also show some sample questions for your better preprartion for the upcoming ACA Database Certification Exam.

Playback

Stage II: NoSQL Databases And Applicable Scenarios In Gaming Industry

Week 2 NoSQL

NoSQL Webinar - Dive Deep Into ApsaraDB for Redis On Alibaba Cloud

In this video, the speaker will talk about details of ApsaraDB for Redis on Alibaba Cloud. You will learn the Alibaba Cloud Database product overview, issues running with original redis, the enterprise edition of Redis called Tair, advanced data structures of Tair, common data structures of original Redis, and use case Sscenario.

Start to learn

Week 2 ApsaraDB for Redis

Introduction To ApsaraDB for Redis Series - How To Choose The Right Architecture For Applications

In this video, you will learn the details about the version and architecture of cloud managed Redis on Alibaba Cloud. If you are considering to use Redis to be a part of your backend, this may help you to choose right.

Start to learn

Week 2 ApsaraDB for Redis

ApsaraDB for Redis

ApsaraDB for Redis is a database service that is compatible with the open source Redis protocol and supports a hybrid of memory and disks for storage. ApsaraDB for Redis provides the hot standby architecture and the cluster architecture, and can scale to meet requirements for high-throughput and low-latency operations.

Start to learn

Week 2 ApsaraDB for Redis Hands-On Lab

Analyze The Memory Of ApsaraDB For Redis

The following experiment primarily uses ApsaraDB for Redis.Redis is an open-source and memory-based key-value storage system with high performance. It is similar to Memcached, but supports more data types, including string, list, set, and hash table. Redis also supports data persistence.This experiment introduces a method to analyze the memory usage of data in a Redis instance without affecting its online use. With the assistance of redis -rdb-tools and SQLite, the method performs static analysis by using the RDB files generated from Redis persistence commands. The method is easy, practical, and useful for every Redis user.

Start the lab

Week 2 MongoDB

MongoDB Tutorial: Build Enterprise MongoDB with MongoShake

MongoShake is an open-sourced platform service and tool for MongoDB written in golang by Alibaba Cloud MongoDB team.

Start to learn

Week 2 MongoDB

ApsaraDB for MongoDB

ApsaraDB for MongoDB is a MongoDB-compatible database service that is developed based on the distributed system and high-reliability storage engine of Apsara. ApsaraDB for MongoDB uses a multi-node architecture to ensure high availability, and supports elastic scaling, disaster recovery, backup and restoration, and performance optimization.

Start to learn

Week 2 MongoDB Hands-On Lab

Basic Use Of MongoDB

This experiment primarily introduces the processes for installing and using MongoDB databases on Alibaba Cloud ECS instances.MongoDB is a DFS-based database written in C++. DFS is short for Distributed File System.The data structure supported by MongoDB is the JSON-like BSON format that can store more complex data types. The supported query language is very powerful, allowing you to implement most of the table query functions used in relational databases.In this experiment, we will provide a detailed introduction to the basic query functions of MongoDB.

Start the lab

Week 2 Database In Gaming

Gaming - What's behind? - Part I: Preface - Redis Cache for MySQL Architecture

You may know many games and how to play, but you may not know how they work and how they are designed. In a typical gaming application, a memory cache is often necessary to be implemented on top of a relational database system to meet the extreme low latency requirement. In this video, you will learn what exactly is behind a java application or a java game.

Start to learn

Week 2 Database In Gaming

Gaming - What's behind? - Part II: A Simple Example of A Java Backend To Know Its Implementation

After you understood what Redis is and how Redis is being used in Enterprise solutions in the first part, you will learn in this second part how a java backend is built in a MySQL + Redis architecture by a simple example.

Start to learn

Week 2 Database In Gaming

Gaming - What's behind? - Part III: Who Is Actually Reacting To Your Request - A Live Demo

After learning Redis in Enterprise solutions and the logic of a Java application/game interacting with its back-end databases, you will see a live demo of a simple java application to explore how a MySQL + Redis architecture actually work in practice.

Start to learn

7PM-9PM JKT, March 25th

In this trainer-led class, the trainer will recap the key points of Alibaba Cloud products and services, including Redis and MongoDB. There will also be a Q&A session for you to clarify your confusions while learning the courses by yourselves. Instructor will also show some sample questions for your better preprartion for the upcoming ACA Database Certification Exam.

Playback

Stage III: Cloud Database Related Tools And Migration Solutions

Week 3 Database Migration

Database Migration Knowledges (Part I) - How To Migrate Wisely?

If you are considering to run their workload on cloud, we will introduce you the reasons to choose Alibaba Cloud, what database services we can offer, tips to select right database products for your application according to the actual needs, two migration approaches and more details about the best approach to migrate your database.

Start to learn

Week 3 Database Migration

Database Migration Knowledges (Part II) - Working Principles & Birth Stories of DTS and LTS

In previous video, Data Transmission service (DTS) is recommended by its online migration abilities to ensure enterprise SLA. In this video, you will learn the principle of DTS and how it was used to migrate Alibaba Group Oracle cluster to MySQL which was the biggest in the world. Also, you will understand how Lindorm Tunnel Service (LTS) works to help you better migrate your HBase and Cassandra cluster to Alibaba Cloud.

Start to learn

Week 3 Database Migration Hands-On Lab

Migrate Self-Built Database To RDS

The main content of this experiment is to explain how to migrate self-built databases based on ECS to the RDS database. The data migration process is implemented through the Data Transmission Service (DTS)

Start the lab

Week 3 DMS

Secure and Easy Data Management with DMS

In this course, you will not only learn what Data Management Service is, you'll also gain an understanding of some of the pain points of the modern Database Administrator, and see how DMS can address those pain points. You'll also learn how to perform operations in the DMS console, including creating new database tables, querying and modifying data, and importing data from CSV files.

Start to learn

Week 3 DMS

Data Management Service (DMS)

Data Management (DMS) is a one-stop data management platform that allows you to manage data throughout its lifecycle. You can use DMS to manage global data assets, govern data, design and develop databases, integrate data, develop data, and consume data. These features help enterprises mine value from data in an efficient and secure manner and help enterprises undergo digital transformation.

Start to learn

Week 3 DBS

Alibaba Cloud Database Backup Service Technical Essentials

Database Backup (DBS) is a secure and cost-efficient solution for continuous data protection. The service offers strong protection for data stored in multiple environments, such as enterprise data centers, hybrid clouds, public clouds, and third-party cloud vendors. Through this course, you will not only learn about Alibaba Cloud RBS technical essentials and applicable scenarios, but also by watching product console demos, you will be familiar with DBS major functions and operation details

Start to learn

Week 3 DBS

Database Backup Service (DBS)

Database Backup (DBS) is a cost-effective and highly reliable cloud-native database backup platform that is provided by Alibaba Cloud. DBS provides unlimited backup storage, second-level emergency recovery, and recovery drills. DBS activates cold data by using second-level sandbox instances and backup data queries.

Start to learn

Flip Virtual Class

7PM-9PM JKT, April 1st

In this trainer-led class, the trainer will recap the key points of Alibaba Cloud products and services, then quickly show database eco-system tools and utilities including Database Management Service, Data Transmission Service and Data Backup Service, etc. There will also be a Q&A session for you to clarify your confusions while learning the courses by yourselves. Instructor will also show some sample questions for your better preprartion for the upcoming ACA Database Certification Exam.

Playback

Stage IV: Alibaba Cloud Associate Database Certification Exam

Learning Module

Exam Name

Certification Introduction

Sign Up

Week 4 ACA Database Exam

Alibaba Cloud Associate Database Certification is a certification for college students, database developers, and database O&M engineers, obtaining this certification proves that you have mastered the core functions and applicable skills of Alibaba Cloud database products and can obtain better employment opportunities in Alibaba Cloud ecosystem.

Sign up for exam

1.

2.

3.

There will be two exam sessions for the ACA Database Certification Exam at
(1) 7-9:30PM JKT on April 7th,
(2) 1-3:30PM JKT on April 9th.
You will receive the exam email with all the arrangement details one work day before each exam date. Please sign up to choose your exam session in Exam Application Form. However, the exam will ONLY be free for those who complete at least 80% of three live courses combined, otherwise your free exam opportunity would be expired.

4.

For the Clouder quizzes in the learning path above, you will have two attempts, but there will be only one opportunity for ACA Database Certification Exam. Please fully prepare yourselves for it.

5.