This is the seventh part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet Today we are going to create a neural net and calculate forward propagation using PostgreSQL. Let’s go. We start with definition of the network: we … Continue reading Machine Learning Part 7 — Forward propagation in neural net in SQL
Tag: Postgres
Windowing functions in recursive CTE
Today we will see an interesting case of incompatibility between MS SQL Server 2017 and PostgreSQL 9.6 (and different versions as well). Let’s start with this code: We emulate a recursive CTE. We have two columns in source dataset, we want to sum first column for rows partitioned by second column. This gives a very … Continue reading Windowing functions in recursive CTE
Machine Learning Part 3 — Linear regression in SQL revisited
This is the third part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet Last time we saw how to calculate linear regression for the Iris dataset. However, we had to hardcode all the featuers. Today we are going … Continue reading Machine Learning Part 3 — Linear regression in SQL revisited