From the course: Advanced SQL for Data Scientists
Advanced SQL techniques for data science
From the course: Advanced SQL for Data Scientists
Advanced SQL techniques for data science
- [Dan] Welcome to this course on Advanced SQL for Data Scientists. In this course, we'll go beyond writing complex select statements to learning how to design performant data models using denormalization and read replicas. We'll review how and when to use various types of indexes, including GiST and GIN indexes, which we use for composite data types. Next, we'll move on to see how to optimize queries by analyzing query execution plans. SQL is extensible, so we'll spend time learning how to create user defined functions that can streamline working with SQL for data science. We'll also see how to take advantage of specialized features for working with JSON, as well as specialized data types for tree structures that can provide an order of magnitude speed up over conventional hierarchical queries based on recursive common table expressions. So let's get started and learn some Advanced SQL for Data Science.
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.