Course Outline

Introduction

Presto and Query Engines

  • What is Presto?
  • ANSI SQL

Preparing the Development Environment

  • Setting up a sandbox and Presto
  • Connecting Tableau
  • Connecting R

In-Place Analysis

  • Working with connectors
  • Benchmarking with TCHP

SQL Concepts

  • Retrieving data
  • Combining data sources
  • Using SQL functions

Advanced SQL Concepts

  • Working with bolllinger bands
  • Accessing data
  • Filtering data
  • Migrating data sources

Summary and Conclusion

Requirements

  • Experience with SQL

Audience

  • Data Scientists
  14 Hours
 

Testimonials

Related Courses

Kaggle

  14 hours

Accelerating Python Pandas Workflows with Modin

  14 hours

GPU Data Science with NVIDIA RAPIDS

  14 hours

Anaconda Ecosystem for Data Scientists

  14 hours

Cost Analysis with Presto COST IT Module

  14 hours

Big Data Business Intelligence for Telecom and Communication Service Providers

  35 hours

Data Science for Big Data Analytics

  35 hours

Data Science Programme

  245 hours

MATLAB Fundamentals, Data Science & Report Generation

  35 hours

Jupyter for Data Science Teams

  7 hours

F# for Data Science

  21 hours

Python Programming for Finance

  35 hours

Data Science essential for Marketing/Sales professionals

  21 hours

Research Methods and Professional Issues– Data science

  7 hours

A Practical Introduction to Data Science

  35 hours