Do you have a rough idea of what SQL is? Do you need to get data out of object storage in the cloud and some relational database at the same time? You should look at Trino and learn about SQL.
Or do you know the ins and outs of joins, window functions, and your SQL queries are counted by the pages and not lines? You may even be the expert on SQL on your team. You should also look at Trino and SQL.
Luckily for you all, we have the right SQL training for everyone in our upcoming series with the founders of the Trino project and SQL experts Martin Traverso, Dain Sundstrom, and David Phillips, and myself as host and co-trainer.
In the SQL training series, we start with the basics of Trino. You will learn that despite the fact that there is leopard frog on the cover of Trino: The Definitive Guide, SQL does not stand for Silly Quacking Leopardfrogs. Instead SQL stands for Structured Query Language, and you will learn about the benefits of connecting many data sources to Trino, and using different clients. And you can always use the same powerful SQL. And for the SQL pros, you learn about catalogs and queries that go across data sources.
Then we’ll glance at the basic SQL foundations, since there are literally
hundreds of books, videos, and training course around. All of them teach you
things like SELECT statements, and WHERE clauses, and unravel the confusions
around LEFT OUTER JOIN and the like.
And after this is when we get to the interesting stuff. Following is a list of some of the topics we will cover:
- Trino concepts like cluster, data source, client, catalog, and more
- Overview of all the SQL support with statements, data types, functions, and connector support
- Working with data types, including numerical and text values, dates and times, JSON, …
- Lots of scalar, aggregation, window functions
- Object storage and other data sources
- Creating schemas, tables, and views
- Inserting, merging, moving and deleting data
- Metadata in general and in hidden tables like
$properties - Table procedures
- Trino views, Trino materialized views and other views
- Global and connector level table functions, including query pass-through
- Support for SQL routines, also known as user-defined functions
Interested now? No matter how great your SQL knowledge or Trino expertise is, you will learn something new in this series. So what are you waiting for?
Join us in one or all of the sessions on the following dates:
- 18th of October 2023: Getting started with Trino and SQL
- 1st of November 2023: Advanced analytics with SQL and Trino
- 15th of November 2023: Data management with SQL and Trino
- 29th November 2023: Functions with SQL and Trino
We look forward to seeing you in class.
Martin, Dain, David, and Manfred
Update:
Videos, slide decks, and other resources for all classes are now available:
- Getting started with Trino and SQL: Blog post with resources and video, Video on YouTube
- Advanced analytics with SQL and Trino: Blog post with resources and video, Video on YouTube
- Data management with SQL and Trino: Blog post with resources and video, Video on YouTube
- Functions with SQL and Trino: Blog post with resources and video, Video on YouTube