Perform fast and efficient data analysis with the power of SQL

A Quick, Interactive Approach to Learning Analytics with SQL

Complete Repository to become an expert is SQL Window Functions

Blackman-Harris Window functions (3-, 5-, 7-term etc.) from 1K to 64M points based only on LUTs and DSP48s FPGA resources. Main core - CORDIC like as DDS (sine / cosine generator)

Satellite library(fft, variogram,...)

.NET Extension methods for object-object or dictionary-object or datatable-object mapping, single item mapping use [ item.Apply(()=>new { .. }); ],multiple array items mapping use [ items.Apply(a=>new { .. }); ]. Extension methods for SQL Window Function in Linq, use [ items.GroupBy(a =>...).AsPartition(p=> p.OrderBy(a=>...)).Over(p=>...); ],can…

📖 Support examples for learning Window Functions in PostgreSQL. Ready to run.

WIndow functions in Apache Hive and Spark

The Chinook Data Analysis Project leverages PostgreSQL, Python, and Google Spreadsheets to explore and analyze the Chinook music store database. Insights will be presented through Tableau Dashboards and Stories. Stay tuned for updates as the project evolves.

Alt school Fall semester DE exam questions

This is an End to End solution to develop some complex query using SQL and window function, Postgres SQL Database and docker container in order to address different problems in BI solutions.

Investigate a Relational Database (project 1 of 3 from Udacity Programming for Data Science with Python)

Spark example project, written in Scala. It aggregates electrical energy consumption in a given time window.

Learning about SQL commands