visual-guides/ Chapter 5: GSQL Mastery & Query Development
Last Updated: October 20, 2018

TigerGraph Visual Learning Path - Chapter 5: GSQL Mastery & Query Development

Chapter 5: GSQL Mastery & Query Development

Graph+AI Breakout: Using Graph for Effective Data Integration

Whether you are trying to tie together data from different databases or maybe you are going through an acquisition, graphs provide an effective way to query across dispersed data without all the overhead of a lift-and-shift or data merge. In this session, we will walk though how graphs can be used in this situation, as well as the considerations...


Conversational AI with TigerGraph & RASA

The need for real-time conversational AI is more pronounced than before. Almost every enterprise is building intelligent customer support systems for returning relevant information to its customers. Understanding the customer better is a clear mark for meeting the Enterprises' business goals and increasing sales. According to Gartner, an...


Exploring Graph with GSQL Queries

Follow along with the videos using the linked codebase: https://github.com/DanBarkus/Patent_Graph


Temporal Analysis with Time Based Custom Metrics

by Yusuf Canbaz

Winner: Most Popular

Time-based analysis by creating custom metrics (filters) using simple GSQL statements. Let's the user see the custom metrics and visualize the corresponding objects as a graph.


TigerGraph 2020 Graphathon: GSQL Real-Time Editor

A Shareable GSQL Editor that Allows Real-Time Collaboration

Learn more here: https://devpost.com/software/gsql-real-time-editor


TigerGraph 2020 Graphathon: TigerNLP

NLP-powered GSQL. Generate GSQL code from human sentences.

Built for improving accessibility and build tools for Tigergraph.

Learn more here: https://devpost.com/software/tiger-nlp


TigerGraph 2020 Graphathon: TigerGraph.NET

TigerGraph.NET is a set of libraries, tools and components for building multi-target graph-powered applications using C# and F#. There are several sub-projects under the TG.NET umbrella:

➡️ CLI

The CLI project provides a cross-platform client for querying and monitoring TigerGraph servers including free-tier server instances. It talks to the...


TigerGraph 2020 Graphathon: TigerGraph.js

Third Place Winner

A Javascript wrapper for TigerGraph aimed to simplify the TigerGraph-JavaScript development process

TigerGraph.js allows users to more easily use and integrate TigerGraph with Node.js. From the website, you can look at particular commands and use the library to query your graph.

To use it, you can install the library...


Aggregation Support for Modern Graph Analytics in TigerGraph - 2020 ACM SIGMOD/PODS Research Paper

This is a video recording of the research paper presented at the 2020 ACM SIGMOD/PODS conference https://sigmod2020.org/ where we describe how GSQL, TigerGraph’s graph query language, supports the specification of aggregation in graph analytics. GSQL makes several unique design decisions with respect to both the expressive power and the evaluation...


Graph Gurus 40: GSQL Writing Best Practices - Part 5 Data Structure

By watching this webinar you will:

  • Learn how to define data structures that may impact your performance.
  • Learn to optimize your data structure.
  • Review and conclude the query writing best practices series.

Graph Gurus 38: GSQL Writing Best Practices - Part 4 Parallelization And Preprocessing

By attending this webinar you will:

⇨ Learn the MPP mechanism of TigerGraph. ⇨ Best practices to make the query more parallel. ⇨ Use cases that preprocessing is needed. ⇨ How to do preprocessing.


Graph Gurus 36: GSQL Writing Best Practices - Part 3 Memory Optimization

By watching this webinar you will:

⇨ Learn what query semantics are memory consuming. ⇨ Learn techniques to optimize memory usage. ⇨ Learn the memory composition of TigerGraph. ⇨ Learn how to check the memory usage.


Graph Gurus 33: GSQL Writing Best Practices - Part 2 Design Optimal Traversal Plan

By watching this webinar you will:

-Learn how to design an optimal query traversal plan -Know how to analyze and tune query performance -Be able to write more efficient queries.


Graph Gurus 31: GSQL Writing Best Practices - Part 1 Thinking In GSQL

By watching this webinar you will:

➡Become more confident in GSQL query writing ➡Know more about GSQL mechanism and accumulators ➡Be able to write medium level difficulty GSQL queries.


5.2 Having, Order By and Limit Clause Demo

The basics of TigerGraph's graph query language, GSQL.

This video demonstrates the HAVING, ORDER BY and LIMIT Clause.


5.1 Having, Order by and Limit Clause

The basics of TigerGraph's graph query language, GSQL.

This video discusses the HAVING, ORDER BY and LIMIT Clause.


4.2 PostAccum Demo

The basics of TigerGraph's graph query language, GSQL.

This video demonstrates the POST-ACCUM Clause.


4.1 PostAccum

The basics of TigerGraph's graph query language, GSQL.

This video discusses the POST-ACCUM Clause.


3.2 Accum Demo

The basics of TigerGraph's graph query language, GSQL.

This video demonstrates how to use the ACCUM Clause.


3.1 Accum Clause

The basics of TigerGraph's graph query language, GSQL.

This video discusses the ACCUM Clause and how to use accumulators within the ACCUM Clause.


2.2 Accumulators Demo

The basics of TigerGraph's graph query language, GSQL.

This video shows a demonstration of Accumulators - special types of variables that accumulate information about the graph during traversal.


2.1 Accumulators

The basics of TigerGraph's graph query language, GSQL.

This video discusses Accumulators - special types of variables that accumulate information about the graph during traversal.


1.2 Select Demo

The basics of TigerGraph's graph query language, GSQL.

This video shows a demonstration of the SELECT Statement and the WHERE Clause.


1.1 Select

The basics of TigerGraph's graph query language, GSQL.

This video discusses the SELECT Statement and the WHERE Clause.


Graph Gurus 14: Pattern Matching Using GSQL Interpreted Mode

In this webinar we:

-Walk you through a tutorial on the pattern matching syntax extension using GSQL interpreted mode.

-Present a content-based recommendation application on top of a social network data set.

-Answer live questions about GSQL.


Graph Gurus 11: Using Accumulators In GSQL For Complex Graph Analytics

This Graph Gurus episode walks through the TigerGraph Test Drive, demonstrating how to use accumulators in GSQL for multiple use cases. In this episode, we:

-Present the rich set of accumulators available in GSQL -Share various use cases utilizing accumulators across industries -Review GSQL queries using a combination of multiple accumulators


Graph Gurus Episode 10: Analyzing Temporal Data with a Native Parallel Graph Database

This Graph Gurus episode walks through the TigerGraph Developer Edition, demonstrating how to build a time series analysis solution. In this episode, we will:

-Share various use cases for temporal data analysis across industries.

-Present a graph solution to perform temporal data analysis using GSQL.

-Review a real-life business use case to see...


Webinar: TigerGraph's Graph Query Language, GSQL

GSQL is a high-level yet Turing-complete query language for expressing graph analytics. GSQL features an SQL-like syntax that reduces the learning curve for SQL programmers while simultaneously supporting a Map-Reduce interpretation that is preferred by NoSQL developers and that is compatible with scalable, massively parallel evaluation.