From the course: Advanced SQL for Data Scientists
What you should know
- [Instructor] This is an advanced course, so I make some assumptions about what you already know or at least familiar with, and that starts with assuming that you're fairly comfortable with writing complex SQL statements. So that includes working with different types of joins, applying different filtering operations, such as where and having clauses, applying windowing functions, and working with common table expressions. I also assume you're capable of installing Postgres or PostgreSQL, and as well as any kind of graphical base query tools you would like to use, and also, I assume you have some familiarity with data structures. So when we're talking about things like balanced trees and hashes in the index topics that you will be comfortable and be able to follow along.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.