A short summary of the Advanced SQL course
--- The course was very good in my opinion even too short.---
It was more about learning many new SQL skills and functions such as:
Window functions (row_number. partition), using CTE, pivots, cube, recursions and solving various real world problems and implementing many more maneuvers and "practices". This course is definitely an advanced course and not for beginners. We studied around 100 different case examples and questions, plus it was a small group of around 8 students which was very beneficial.
--- Extreme learning of material vs. hands on ---
I was expecting that it would be more hands on practice, however the teaching model what such that Ram presented a problem and then took us through the answering process while showing us his code and how it works, The participation part was mainly here when we discussed the problem and what we did or didn't understand. After solving each question he then made sure everyone understood and was willing to explain multiple times very nicely. Eventually this teaching model allowed us maximum learning of new material in the time we was very good although it does require further practice and to review material again.
--- Expectations vs. Reality ---
When signing up i thought the advanced course would take you to complex join-queries with different level of aggregations and uniqueness and there focus on - Advanced queries only experienced SQLers could manage correctly with all special details and cases to think about.
Instead the course took a different path and was focused on teaching new "skills &* tools" to work with. Examples were hard to solve but simple in their nature and their main purpose was to show how this or that tool works.
All in all, very glad I went to the course, I have a full book of examples, files in my dropbox to practice, and Ram as a guide to ask him questions. Thank you very much for the great course and for caring that each and everyone of us will understand and stay on track.
קורס SQL מתקדם