SQL Presto

Course Duration

4 hours, 1-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Course Description

Presto is a high performance, distributed SQL query engine for big data. Its architecture allows users to query a variety of data sources such as Hadoop, AWS S3, Alluxio, MySQL, Cassandra, Kafka, and MongoDB. Presto was designed and built from scratch for interactive analytics. It approaches the speed of commercial data warehoused while scaling to the size of very large organizations.

ENTRY COMPETENCIES of Participants (Prerequisites):

The curriculum is appropriate for students at many education levels and types of institutions, including high schools, secondary schools, universities, colleges, career and technical schools, graduates looking to build a career in Presto engine, Data Scientist, Data Engineer and Developers.
For Participants: Computer literate

COURSE OBJECTIVES/LEARNING OUTCOMES:

By the end of the course, students will be able to learn the following modules:

  • Know what Presto Is
  • Presto Use Cases and Concepts
  • Presto Installation and Deployment
  • Presto
    • Security
    • Administration
    • Query Optimizer
    • Presto Connectors
    • Functions and Operators
    • SQL Language
    • SQL Statement Syntax
    • Migration
  • Developer Guide and Release Notes
    • MAKATI
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines

    • Contact No.
    • +63 2 8891 0713
      +63 2 8751 6482

    • Email Address
    • inquiries@mapua.edu.ph

    • INTRAMUROS
    • 658 Muralla St., Intramuros, Manila 1002, Philippines

    • Contact No.
    • +63 2 8524-5572


    • Email Address
    • ccesc@mapua.edu.ph