PostgreSQL: Data Modelling and Analytics

PostgreSQL is a powerful open-source database management system (DBMS) known for standards compliance and efficient handling of large-scale datasets. Beyond its core strengths, it offers exceptional support for diverse data types and extensibility.
  
In this hands-on workshop, we’ll start with PostgreSQL’s core capabilities for data modeling and analytical querying. You’ll learn to apply aggregates, window functions, and custom aggregation functions using languages like PL/pgSQL, Python, Perl, C, R, or Lua. We’ll also explore indexing strategies for fast retrieval, including full-text search and trigram-based fuzzy matching on large textual datasets.