Dataiku DSS & SQL

Learn more on the usage of Dataiku DSS with SQL databases

About this course

 

The DSS & SQL course is designed to walk you through some of the more common tasks that you will encounter when working with SQL databases in Dataiku DSS. Completion of this course will enable you to move on to more advanced courses on DSS and SQL databases.

 

Throughout the hands-on lessons in this course, we will work with a fictional online t-shirt retailer called Haiku T-Shirt and use their enterprise data to illustrate some common tasks that you can expect to perform when working with SQL databases in DSS. Before each hands-on section, you will have a chance to grasp relevant key concepts by watching short videos.

In the hands-on lessons, we will learn to get data into an SQL database, perform in-database data processing using an SQL query recipe or a visual recipe, create charts using the database engine, and finally, use SQL notebooks to prototype code for querying and analyzing data.

 

 

Learning Objectives

At the end of the DSS & SQL course, you will have an understanding of:

1 - The architecture model for databases

2 - Database actions that you can perform in DSS

3 - Use cases for querying your data using SQL recipes and notebooks

4 - In-database computation

 

Course Properties

Course Title DATAIKU DSS & SQL

Target Audience

DSS users working with SQL databases

Access Level

Free / included with registration

Estimated Time for Completion

51 Minutes

Completion Criteria

Pass all the quizzes with an 80% score

Supplemental Materials (Y/N)

NONE

Knowledge Prerequisite(s)

Integration With SQL Databases

Technical Prerequisite(s)

Dataiku DSS - Latest version (FREE EDITION is enough)

An installed SQL database that is connected to DSS

 

Register above to start learning!

 

Curriculum51 min

  • Preview
    Introducing DSS & SQL 1 min
  • Move Data to Your Database
  • Concept: Architecture Model for Databases 2 min

    Concept: Architecture Model for Databases

  • Concept Summary: Architecture Model for Databases 1 min

    Concept Summary: Architecture Model for Databases

  • Hands-On: Sync Recipe 3 min

    Hands-On: Sync Recipe

  • Hands-On: Prepare Recipe 3 min

    Hands-On: Prepare Recipe

  • Quiz: Move Data to Your Database 2 min

    Quiz: Move Data to Your Database

  • SQL Code Recipes
  • Concept: SQL Recipe 2 min

    Quiz: Move Data to Your Database

  • Concept Summary: SQL Recipe 1 min

    Concept Summary: SQL Recipe

  • Hands-On: Create a New Dataset With an SQL Query Recipe 5 min

    Hands-On: Create a New Dataset With an SQL Query Recipe

  • Hands-On: Using Visual Recipes to Perform In-Database Operations 2 min

    Hands-On: Using Visual Recipes to Perform In-Database Operations

  • Quiz: SQL Recipe 2 min

    Quiz: SQL Recipe

  • In-Database Charts
  • Concept: In-Database Charts 1 min

    Concept: In-Database Charts

  • Concept Summary: In-Database Charts 1 min

    Concept Summary: In-Database Charts

  • Hands-On: In-Database Charts 1 min

    Hands-On: In-Database Charts

  • Quiz: In-Database Charts 1 min

    Quiz: In-Database Charts

  • SQL Notebooks
  • Concept: SQL Notebooks 2 min

    Concept: SQL Notebooks

  • Concept Summary: SQL Notebooks 1 min

    Concept Summary: SQL Notebooks

  • Hands-On: SQL Notebooks 4 min

    Hands-On: SQL Notebooks

  • Quiz: SQL Notebooks 3 min

    Quiz: SQL Notebooks

  • Wrap-Up
  • Course Checkpoint 7 min

    Course Checkpoint

  • Tell Us What You Think 1 min

    Tell Us What You Think

  • Course Complete 1 min

    Course Complete

About this course

 

The DSS & SQL course is designed to walk you through some of the more common tasks that you will encounter when working with SQL databases in Dataiku DSS. Completion of this course will enable you to move on to more advanced courses on DSS and SQL databases.

 

Throughout the hands-on lessons in this course, we will work with a fictional online t-shirt retailer called Haiku T-Shirt and use their enterprise data to illustrate some common tasks that you can expect to perform when working with SQL databases in DSS. Before each hands-on section, you will have a chance to grasp relevant key concepts by watching short videos.

In the hands-on lessons, we will learn to get data into an SQL database, perform in-database data processing using an SQL query recipe or a visual recipe, create charts using the database engine, and finally, use SQL notebooks to prototype code for querying and analyzing data.

 

 

Learning Objectives

At the end of the DSS & SQL course, you will have an understanding of:

1 - The architecture model for databases

2 - Database actions that you can perform in DSS

3 - Use cases for querying your data using SQL recipes and notebooks

4 - In-database computation

 

Course Properties

Course Title DATAIKU DSS & SQL

Target Audience

DSS users working with SQL databases

Access Level

Free / included with registration

Estimated Time for Completion

51 Minutes

Completion Criteria

Pass all the quizzes with an 80% score

Supplemental Materials (Y/N)

NONE

Knowledge Prerequisite(s)

Integration With SQL Databases

Technical Prerequisite(s)

Dataiku DSS - Latest version (FREE EDITION is enough)

An installed SQL database that is connected to DSS

 

Register above to start learning!

 

Curriculum51 min

  • Preview
    Introducing DSS & SQL 1 min
  • Move Data to Your Database
  • Concept: Architecture Model for Databases 2 min

    Concept: Architecture Model for Databases

  • Concept Summary: Architecture Model for Databases 1 min

    Concept Summary: Architecture Model for Databases

  • Hands-On: Sync Recipe 3 min

    Hands-On: Sync Recipe

  • Hands-On: Prepare Recipe 3 min

    Hands-On: Prepare Recipe

  • Quiz: Move Data to Your Database 2 min

    Quiz: Move Data to Your Database

  • SQL Code Recipes
  • Concept: SQL Recipe 2 min

    Quiz: Move Data to Your Database

  • Concept Summary: SQL Recipe 1 min

    Concept Summary: SQL Recipe

  • Hands-On: Create a New Dataset With an SQL Query Recipe 5 min

    Hands-On: Create a New Dataset With an SQL Query Recipe

  • Hands-On: Using Visual Recipes to Perform In-Database Operations 2 min

    Hands-On: Using Visual Recipes to Perform In-Database Operations

  • Quiz: SQL Recipe 2 min

    Quiz: SQL Recipe

  • In-Database Charts
  • Concept: In-Database Charts 1 min

    Concept: In-Database Charts

  • Concept Summary: In-Database Charts 1 min

    Concept Summary: In-Database Charts

  • Hands-On: In-Database Charts 1 min

    Hands-On: In-Database Charts

  • Quiz: In-Database Charts 1 min

    Quiz: In-Database Charts

  • SQL Notebooks
  • Concept: SQL Notebooks 2 min

    Concept: SQL Notebooks

  • Concept Summary: SQL Notebooks 1 min

    Concept Summary: SQL Notebooks

  • Hands-On: SQL Notebooks 4 min

    Hands-On: SQL Notebooks

  • Quiz: SQL Notebooks 3 min

    Quiz: SQL Notebooks

  • Wrap-Up
  • Course Checkpoint 7 min

    Course Checkpoint

  • Tell Us What You Think 1 min

    Tell Us What You Think

  • Course Complete 1 min

    Course Complete