Hey Greg, thank you for this amazing tutorial! I have some experience with SQL but found myself learning a lot as I went through the tutorial.
Already know:
In the past when studying for interviews I was solving different SQL querying problems that involved window functions, different join operations, cte's.
Completely new:
I haven't worked with actually creating and maintaining databases, and this tutorial was great in teaching me how to: create tables, insert data, storing data as blob or json or other data types, working with these datatypes, using views, check/transactions/triggers. Everything past the 067 header was completely new to me.
What's missing:
Would be nice to have some information about SQL best practices. I know when I was starting with SQL I would name my tables tbl1 and tbl2, have no aliases, and produce these very long queries with no indentations.
Hey Greg, thank you for this amazing tutorial! I have some experience with SQL but found myself learning a lot as I went through the tutorial.
Already know: In the past when studying for interviews I was solving different SQL querying problems that involved window functions, different join operations, cte's.
Completely new: I haven't worked with actually creating and maintaining databases, and this tutorial was great in teaching me how to: create tables, insert data, storing data as blob or json or other data types, working with these datatypes, using views, check/transactions/triggers. Everything past the 067 header was completely new to me.
What's missing: Would be nice to have some information about SQL best practices. I know when I was starting with SQL I would name my tables tbl1 and tbl2, have no aliases, and produce these very long queries with no indentations.