Apache Superset-Connect with Multiple Data Sources

Apache Superset-Connect with Multiple Data Sources

Learn to Connect Apache Superset with SQLite, MySQL, PostgreSQL, Clickhouse, Apache Drill & CrateDB

What you’ll learn

  • To Install Various Community Edition Databases in Development Environment i.e MySQL, PostgreSQL, Clickhouse, Apache Drill, CrateDB, MongoDB
  • To Install Various Community Edition Database Management Tools in Development Environment i.e DB Browser for SQLite, MySQL Workbench, PGAdmin, Clickhouse Client, MongoDB Compass
  • To Install Various Database Dependencies before connecting Apache Superset with MySQL, PostgreSQL, Clickhouse, Apache Drill, CrateDB
  • To Connect Various Databases with Apache Superset i.e SQLite, MySQL, PostgreSQL, Clickhouse, Apache Drill, CrateDB

Requirements

  • Participants should have separate Practice system with Ubuntu Studio Already Installed (Fresh Installation)
  • Practice system should have atleast 12 GB RAM and I7 Configuration to walk through all the scenarios shown in Various Course Videos
  • Participants should have high speed internet
  • Practice system must have Apache Superset Already installed or Participant can see instruction to install in my other Course “Getting Started with Apache Superset”
  • Participants should practice Course videos in Physical Machine Instead of Virtual Machine
  • Participants Should have basic knowledge on how to enter commands in terminal
  • Participant should have Basic Knowledge of Databases
  • It is also expected that Participants should have visited or visit official Websites of Apache Superset (Incubating) and Other Products mentioned in Course to have Complete understanding
  • In case of any confusion or query, Please ask any question before/ during/after the course

Description

In this Course, Participants will get overview on how to Install multiple Databases (Community Editions) (Development Environment) and How to use these databases as data source for Apache Superset (Incubating).

Note:

1) Data Generation, Extraction, Loading & Transformation for Databases is not in scope of this Course.

2) Please read Prerequisite before enrolling in Course.

After Complete of this Course, Participants will be able to do the following tasks in development environment:

  • Installing DB Browser for SQLite
  • Connecting SQlite with Apache Superset
  • installing MySQL Server Community Edition
  • Installing MySQL Workbench Community Edition and Connecting with MySQL Server
  • Installing Database dependencies before connecting with Apache Superset with MySQL Server
  • Connecting  MySQL with Apache Superset
  • Installing PostgreSQL Community Edition with PGAdmin
  • Installing Database dependencies before connecting with Apache Superset with PostgreSQL
  • Connecting PostgreSQL with Apache Superset
  • Installing Clickhouse DB Server and Client Community Edition
  • Connecting Clickhouse DB Server and Client
  • Installing Database dependencies before connecting with Apache Superset with Clickhouse DB
  • Connecting Clickhouse DB with Apache Superset
  • Installing Apache Drill in Embedded Mode
  • Installing Database dependencies before connecting with Apache Superset with Apache Drill
  • Connecting Apache Drill with Apache Superset
  • Installing CrateDB Community Edition
  • Installing Database dependencies before connecting with Apache Superset with CrateDB
  • Connecting CrateDB with Apache Superset

Who this course is for:

  • Anyone interested to know about various data sources available for Apache Superset (Incubating)
  • Anyone interested to know as how to Install Various Databases in Development Environment
  • Anyone interested to know as how to Install Various Database Management Tool in Development Environment
  • Anyone interested to know about various database dependencies installation for Apache Superset (Incubating)
  • Anyone interested to know how to connect Apache Superset (Incubating) with various data sources