From the course: Advanced SQL Project: Design and Manage a Database
Join today to access over 25,500 courses taught by industry experts.
Introduction to SQL queries (basic, aggregate, joins) - SQL Tutorial
From the course: Advanced SQL Project: Design and Manage a Database
Introduction to SQL queries (basic, aggregate, joins)
- You've done an incredible job so far completing modules one through four. You've tackled database planning, gathered requirements, designed robust schemas, and implemented ETL processes like a true data modeler. Now as we move into module five, you'll be segueing into the role of data analyst. Shout out to you for leveling up with these foundational skills. Keep pushing forward as you journey into deeper data analysis. So with our error handling and logging performed, we're now ready to exchange hats, so to speak. Up to this point, everything we've done fell more or less under the hat of a data modeler. Now we can assume the hat of a data analyst and start working with data that has already been right sized, validated, and set up in our database. So we're going to treat part of this session as a recap of some simple to complex SQL statements and then get into some specific analysis with regard to the data that we have imported. All right, so let's start with this first statement…
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.