[kumarvvr]

Do you have any resources or books to learn all the details of all these?

Also, what is UDF?

[AxiomaticSpace]

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.

[dmoy]

> python or C++

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

[whattheheckheck]

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

[tfryman]

User defined functions