Learn & Query On
Aginity Provides a Collaborative Experience for SQL Server 2019 Customers to Discover, Manage and Share SQL
Chicago, Illinois, November 6, 2019 /PRNewswire/ — Today, we’re announcing that we’ve added support for SQL Server 2019 in our next-generation SQL analysis products, Aginity Pro and Aginity Team.
At Aginity, we are lucky to interact with Data Analysts, Data Engineers and Data Scientists from across a wide range of industries and company sizes. It gives us a birds-eye view of some trends in data processing and the thousands of users of our SQL query applications…
IBM Db2 customers can now discover, manage and share SQL in a collaborative environment using Aginity Pro and Aginity Team.
It’s been an unprecedented year of growth for us at Aginity. With the recent launch of our two next-generation solutions Pro and Team, we’ve got tens of thousands of individuals and enterprises depending on our products in their everyday workflow.
If the retirement of Netezza has you floundering, we’ve got at least one point of consolation: this doesn’t mean you have to part ways with Aginity! In addition to supporting IBM’s next generation database offerings with support coming out this year, Aginity already enables your SQL query and development workloads on 10 different databases (and counting), including cloud specialists like Azure Data Warehouse and Amazon Redshift.
Learn how to become a rock star SQL analysts, data engineer or data scientist.
For Data Engineers
Redshift Utilities: Generate DDL and Search Table Metadata
MPP databases require you to figure out how to navigate their system tables. We’ll show you a few examples how to work with system tables to reverse engineer DDL and search for tables using wildcards.
Generating SQL to Profile Table Data
Leveraging what we learned in Lesson 1, we will expand the concept to use system tables and prior scripts to generate code that profiles a Redshift table. Check out this lesson to learn more.
Building a Random Number Generator to Create an Image
Feeling creative? Check out this lesson to learn how to build a random number generator in Redshift and create an image of Aginity’s Enterprise Product Manager George L’Heureux.
For Business Analysts
Rate of Return on Redshift
Internal Rate of Return (IRR) is a calculation frequently used to estimate an investment’s rate of return. Take this lesson to figure out how to use Redshift SQL to perform this calculation..
Create Basic Recency, Frequency and Monetary Segments
RFM (Recency, Frequency, Monetary) analysis is highly used marketing model for behavior based customer segmentation. It groups customers based on their purchase history. Learn how to do this in SQL!