Learning Presto DB

Video description

Learning Presto DB

Video description

Facebook, Netflix, Airbnb, LinkedIn, and Uber. These are just a few of the leading companies who use Presto to query SQL on Hadoop at big data scale. This course provides an introduction to Presto. You'll learn about the concepts and architecture behind Presto, how to install and configure Presto for different requirements (single node, multi-node, with Yarn, without Yarn, etc.), and how to administer Presto, including tuning, performance, and diagnosis.

It also covers how to use JDBC/ODBC drivers to connect applications and tools to Presto, how Presto security works, and how you can become active in the PrestoDB community. Course prerequisites include: A strong understanding of Hadoop (including HDFS, Hive, YARN, Ambari), Linux, AWS, and SQL. A basic understanding of Kerberos, LDAP, CPU/Memory/Disk tradeoffs, JDBC, ODBC, and Tableau, as well as light experience with Git, Java, Python, Maven, and Intellij.

Gain practical hands-on experience working with the Presto SQL query engine
Explore Presto's architecture, history, and use cases
Learn to install and configure Presto for various deployments (multi-node, with Yarn, etc.)
Discover how to query various data sources such as Hive, S3, and PostgreSQL
Learn how to configure Presto security
Understand how to use applications and BI tools to connect to Presto
Pick up valuable experience managing Presto clusters

Matt Fuller leads the Presto engineering team at Teradata, which is the second largest contributor to Presto next to Facebook. Matt has worked in database architecture and development for nine years. In addition to Teradata, he's worked at Hadapt, and Vertica Systems. He earned a Masters in Computer Science from Brown University and is the holder of one U.S. Patent.

Publisher resources

Download Example Code

Introduction

Welcome To The Course 00:02:47

About The Author 00:01:23

What Is Presto?

What Is Presto? 00:06:42

High Level Architecture 00:04:15

Download Presto Sandbox 00:03:22

Running Queries In Presto Sandbox 00:07:20

Deployment Models 00:02:04

Installing Presto On Single Node

Single Node Presto Installation On Mac/Linux 00:08:44

Installing Java 00:01:15

Download And Extract Presto Installation 00:01:35

Configuring Presto 00:05:38

Running Presto 00:02:28

Querying Data Sources In Presto

Adding Hadoop Connector 00:03:46

Adding PostgreSQL Connector 00:04:17

Query From S3 00:01:23

Query Federation 00:02:06

Installing Presto On Multi Node

Multi Node Installation Using Presto Admin 00:02:45

Installing Presto Admin 00:01:47

Configuring Presto Admin 00:01:35

Installing Java Using Presto Admin 00:01:44

Installing Presto Using Presto Admin 00:05:03

Adding Hadoop Connector Using Presto Admin 00:02:41

Presto Hadoop Integrations

Download And Install Ambari Plugin 00:02:04

Install Presto Via Ambari 00:04:18

Presto YARN Integration - Creating Presto View 00:06:48

Presto YARN Integration - Installing Presto 00:06:35

Presto Administration And Monitoring

Presto Web UI 00:07:21

Presto Admin Commands 00:06:25

System Tables 00:02:48

Security

Security In Presto 00:03:20

Hive Security 00:05:41

Kerberos 00:05:51

GRANT/REVOKE Privileges 00:06:23

Advanced Presto

Reading Explain Plans 00:05:38

Query Execution 00:06:12

Memory Management 00:03:54

Presto Tuning 00:07:07

File Formats 00:02:23

Queues 00:03:47

ODBC & JDBC

Downloading JDBC And ODBC Drivers 00:01:27

Installing ODBC On Mac 00:00:58

Installing ODBC On Linux 00:05:35

Using JDBC 00:02:46

Using Tableau With Presto 00:01:42

Presto Community

Joining The Presto Community 00:06:51

Cloning The Git Repo 00:02:17

Configuring Intellij 00:01:30

Running Presto From Intellij 00:05:05

Conclusion

Wrap Up And Thank You 00:01:02

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.