Learning Presto DB

HDRips | MP4/AVC, ~1064 kb/s | 1280x720 | Duration: 03:11:45 | English: AAC, 128 kb/s (2 ch) | 906 MB

Genre: Development / Programming

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