[Free] Apache Superset-Connect With Multiple Data Sources
Learn to Connect Apache Superset with SQLite, MySQL, PostgreSQL, Clickhouse, Apache Drill & CrateDB – Free Course
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
