-
Introducing Integration With SQL Databases 1 min
- Technical Prerequisites
-
Install PostgreSQL 0 min
Install PostgreSQL
-
Create and Configure Your PostgreSQL Database 5 min
Create and Configure Your PostgreSQL Database
- Connecting to PostgreSQL
-
Concept: Connections to SQL Databases 2 min
Concept: Connections to SQL Databases
-
Concept Summary: Connections to SQL Databases 1 min
Concept Summary: Connections to SQL Databases
-
Hands On: Configure the Connection Between Dataiku DSS and PostgreSQL 5 min
Hands On: Configure the Connection Between Dataiku DSS and PostgreSQL
-
Quiz: Connecting to PostgreSQL 3 min
Checkpoint
- Wrap-Up
-
Tell Us What You Think 1 min
Tell Us What You Think
-
Course Complete 1 min
Course Complete
Integration With SQL Databases
Learn more on how to connect Dataiku DSS to relational databases
 |
The Integration With SQL databases course is designed to walk a Dataiku DSS administrator through the process of configuring a connection between DSS and a relational database.
Throughout the course, we will use a PostgreSQL database connection for illustration. Before going through the hands-on lessons, you will have a chance to grasp relevant key concepts by watching a short video. In the hands-on lesson of this course, you will create and configure your database, establish a connection between the database and DSS, and then create a DSS dataset for tables in the database. |
Learning Objectives
At the end of the Integration With SQL Databases course, you will be able to:
1 - Set up and use an SQL connection within DSS
2 - Recognize when to leverage the SQL execution engine for its computational advantages
3 - Know the levels of support that Dataiku provides for connections to particular databases
Course Properties
| Course Title | Integration with SQL Databases |
|
Target Audience |
DSS administrators who want to connect DSS with relational databases |
|
Access Level |
Free / included with registration |
|
Estimated Time for Completion |
20 Minutes |
|
Completion Criteria |
Pass course checkpoint with an 80% score |
|
Supplemental Materials (Y/N) |
NONE |
|
Knowledge Prerequisite(s) |
NONE |
|
Technical Prerequisite(s) |
Dataiku DSS - Latest version (FREE EDITION is enough) PostgreSQL - version 9 or higher DSS admin privilege |
Start by watching the Integration with SQL Databases overview video and by looking at the “Connections to SQL Databases” key concept.
 |
Register above to start learning! |