课程: Advanced SQL Project: Design and Manage a Database

今天就学习课程吧!

今天就开通帐号,24,600 门业界名师课程任您挑!

Introduction to SQL queries (basic, aggregate, joins)

Introduction to SQL queries (basic, aggregate, joins) - SQL教程

课程: 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…

内容