EncartaLabs

Presto DB

( Duration: 2 Days )

Presto is an open source distributed SQL engine, is widely recognized for its low-latency queries, high concurrency, and native ability to query multiple data sources. This Presto DB training course provides skills for querying data at huge scales, across many data-sources (S3, SQL databases, NoSQL databases, and more).

By attending Presto DB workshop, delegates will learn to:

  • Install, deploy and configure Presto.
  • Query data on S3 and HDFS using standard SQL.
  • Execute SQL queries across multiple datasources using Presto's query federation.
  • Understand what it takes to deploy and use Presto in real-word scenarios.

  • Basic Linux skills and SQL knowledge

COURSE AGENDA

1

Introduction to Presto

  • Big Data, Data Warehousing, Data Lakes and Clouds.
  • What is Presto and why is it needed.
  • Use cases.
  • Presto Architecture.
  • Catalogs, Schemas and Tables.
  • Installation and configuration.
2

The Presto Ecosystem

  • The Presto CLI and Web UI.
  • Data Sources and Connectors.
  • JDBC and ODBC connectivity.
  • Using Presto from BI Tools and IDEs.
3

Real-world Presto

  • Partitioning and Bucketing.
  • File formats: Avro, ORC, Parquet.
  • Query planning and execution.
  • Cost-based optimizations.
  • Query performance monitoring and tuning.
  • Understanding joins and spill to disk.
4

Query Federation

  • More built-in connectors: MySQL, PostgreSQL.
  • Query relational data using Presto.
5

Cluster and Data Source Administration

  • Deployment options and administrative tools.
  • Cluster best practices and high-availability.
  • Resource groups.
  • Security overview: Authentication, Authorization and Encryption.

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top