Neil Sainsbury – Mastery with SQL
English | Size: 1.66 GB
Mastery with SQL
A hands-on practical course for anyone who wants to learn modern SQL
A hands-on course, built for the busy learner
Packed with high quality videos, practical examples, and interesting and challenging exercises to practice what you’ve learned. The course is broad and deep, taking you from beginner level to mastery with SQL and doing it in a way that creates a deep understanding of what you’ve learned. My goal is to give you the practical tools and skills you need to get your job done.
Learn by doing
The best way to learn is by doing, not just watching videos. In this course, you’ll learn by challenging yourself with over 150 exercises from beginner level to advanced, complete with solutions and discussion.
The exercises and examples use a sample database for a fictitious movie rental company. There’s a lot of questions you’ll have about this company. How many customers does it have? Which movies are grossing the highest amount for the business? Which stores are out of stock of particular films? You’ll be writing queries to answer real world questions about sales, staff, films, and customers.
Throughout this course you’ll be learning SQL using PostgreSQL, the world’s most advanced open source relational database. You’ll learn about (and practice using) PostgreSQL features like DISTINCT ON, lateral joins, date math with intervals, set returning functions, modern window functions, materialized views, and more.
But you’ll also be learning ANSI SQL too and I’ll discuss when we deviate from it and why, so even if you happen to be using Microsoft SQL Server, MySQL, or Oracle Database you’ll still learn key concepts and skills that easily transfer over.
I’m Neil Sainsbury, a software developer and data engineer, and I built this course to share what I’ve learned from over 10 years of working with relational databases and SQL.
I’m currently teaching, writing, and consulting, specializing in databases and data engineering. Previously, I was the co-founder and Chief Technology Officer at RateIt, a customer feedback platform used by millions of people, and I also did heavy data-crunching work applying neural networks to analyze mining site microseismic data at CSIRO.
I’ve worked with many different companies around the world including BlackBerry, Ball Aerospace, Mobile Nations, and others and built and shipped multiple products at my own company, BBSmart.
(Buy premium account for maximum speed and resuming ability)