T-SQL Programming for Developers
Your Instructor
Being a Data Expert in Madeira is pure fun and it’s always interesting. I enjoy learning something new every day, seeing different types of systems and applications, and using the wide array of MSSQL technologies to their full potential.
Along with over 10 years of experience in various programming technologies, I gained a wide knowledge in the data industry, from DB design and development, through performance tuning and maintenance and up to a deep understanding of DB architecture.
Outside Madeira, I enjoy a wide variety of activities: From drawing comics to playing computer games, to watching the night sky through my telescope, and traveling the country with my family. There is no better feeling than helping people, teaching people, and seeing the appreciation in their eyes. This is how I make the world a better place and there’s nothing better.
Course Curriculum
-
PreviewModules 1- Course Introduction (2:00)
-
PreviewModules 2- Variables and Parameter Sniffing (11:27)
-
StartModules 3- Table Variables vs Temp Tables (6:51)
-
StartModules 4- Optimize Search Arguments (11:45)
-
StartModules 5- Multiline vs Inline Functions (10:18)
-
StartModules 6- The Problem with Cursors (4:49)
-
StartModule 7- CASE and RAND (7:32)
-
StartModule 8- CROSS APPLY and ROW_NUMBER (4:16)
-
StartModule 9- Summary (6:21)