Hacker News new | ask | show | jobs
by kumarvvr 119 days ago
Do you have any resources or books to learn all the details of all these?

Also, what is UDF?

3 comments

Pretty much any SQL book will cover it those, and there's a bunch of online SQL tutorials. UDF means user defined function, so if there's some function you want to perform in SQL but that function doesn't come out of the box, you can just write your own. And those can be defined in non-SQL syntax, such as UDF's written in python or C++, which can be pretty handy.
> python or C++

Also sometimes Lua, which is kinda a nice middleground between c++ efficiency and python ease of writing

Data warehouse toolkit for Kimball

Google will inmon for the info factory

Google data vault

Joe reis is the guy for tying it up with a modern bow recently.

Designing data intensive applications book

User defined functions