Using AWS Aurora (Amazon's MySQL-Compatible Database) —
Advait Shinde shows how his company uses Amazon Aurora to improve scalability by decreasing replica lag and bypassing limitations inherit in enterprise-grade relational databases like AWS RDS.
GoGuardian video
Analyzing A Million Songs on AWS Redshift —
A look at extracting data from 1 million songs, uploading it to AWS Redshift via S3, and running some analysis via psql.
Mark Litwintschik tutorial
Unlimited Scalability Unprecedented Speed with the GridGain In-Memory Data Fabric — GridGain enables high-performance transactions, real-time streaming and fast analytics using a distributed, massively parallel architecture which can connect SQL, NoSQL, and Hadoop databases. GridGain is an enterprise-ready solution built on Apache Ignite™.
GridGain In-Memory Data Fabric sponsored
Postgres Query Plan Visualization —
Understanding query plans and EXPLAIN output can be tricky, even for an experienced user. This is a great tool to help better understand how a query is operating.
Alex Tatiyants tools
KeRF: A Next-generation Time-Series and Tick Database —
A columnar tick database and time-series language for Linux/OSX/BSD/iOS/Android. Natively speaks JSON and SQL. Ideal for trading platforms, low-latency networking, high-volume analysis of realtime and historical data, etc.
Kerf tools
Binomial Options Pricing in SQL —
How to set up a discrete binomial tree using the binomial options pricing model to value derivatives in SQL, and apply this in an example of pricing a 3-period call option.
Periscope tutorial
Gartner Sees Analytics Boom as More Data is Shared —
“forecasts greater uptake of emerging analytics technologies like semantic and graph analyses, simulation, complex event processing and neural networks”