From the course: Advanced SQL: High Performance Relational Divisions

Setting expectations - SQL Tutorial

From the course: Advanced SQL: High Performance Relational Divisions

Start my 1-month free trial

Setting expectations

“

- [Instructor] We will spend most of our time writing code. More dev, less PowerPoint. And I highly recommend that you watch, "Logical Query Processing Parts One and Two" before taking this course, even though I am going to provide a few reminders along the way. You can always trust me to include relational theory and database design craziness. I will try to plant some weird design ideas in your head. Who knows, you may end up adopting some, God forbid. I will use Azure Data Studio and SQL Server for all code demos for no good reason other than the fact that I'm used to them and like them. There will be no fancy syntax elements, only the basic constructs that we all love. The same code will work pretty much the same way on all relational database management systems, which I will refer to from now on as databases. You will see that the standard SQL constructs pack more than enough logical complexity and wizardry. You will find the code files that include all demo queries and challenges in the course materials, and you can also get them on the course's public GitHub repository. Links to pre-populated DB Fiddle UK pages will be provided as well for your convenience. And if you're not familiar with DB Fiddle UK, check them out and please consider donating to keep this amazing resource alive. The course is high paced and challenging. It is not an introductory course to SQL by any means. You're going to learn some of the most unconventional query techniques out there, and to get the most value out of it I need you to be focused, determined, and to practice. I'll make you work hard, but it will be worth every minute. Do we have a deal? Don't answer, it's a rhetorical question. Enough smalltalk, relational division time.

Contents