From the course: Advanced Analytics Engineering: Real-World Practice

Advanced SQL techniques

From the course: Advanced Analytics Engineering: Real-World Practice

Start my 1-month free trial Buy for my team

Advanced SQL techniques

“

- [Instructor] I'm so excited about this chapter. SQL is my favorite technical data tool. I've said before and I'll say it again, SQL is the backbone of everything analytics. Nearly every database platform uses SQL to interact with and query the data. And if they don't use SQL, they probably use a NoSQL interface, which still functions in a similar way as Structured Query Language. Even if you feel really comfortable with SQL, I recommend following along with these topics we'll cover in this chapter. We'll dive into recursive CTEs, running totals, various statistical metrics, indexing, window functions, and upserts. Also, SQL is so broad, it's nearly impossible to master everything. Practice will only hone your skills and let you see through the data problems quicker and solve them faster. So it's not a bad idea to practice and at least refresh your knowledge on these topics. If you're brand new to SQL, you can follow along too. You might need to look up a few things here and there, but I've designed this course so everyone can follow along in GitHub Codespaces. If you don't understand a topic or function I use, pause the video and look it up. You can navigate to our GitHub repository in Codespace using the link below. There you can find the branch that corresponds with each video in this chapter, hit the Code button, create a new Codespace on that branch. It all runs in your browser, so you shouldn't need to download anything to your computer.

Contents