From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Building basic select queries

Building basic select queries

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Start my 1-month free trial Buy for my team

Building basic select queries

“

- [Instructor] Query concepts are pretty universal, but the way a particular software queries data is controlled by how that software is designed. For example, the way we query data in SQL and the way we query in Power BI, we end up with the same fields, the same types of joins, but we build the queries in entirely different interfaces. For this course, we're focused on the universal query concepts and how to apply them. Then you can apply those concepts anywhere a tool has a querying component. To teach concepts, I've used Microsoft Access for years because it's a database program, it has both tables and queries, it's widely available to anyone who has Microsoft Office on a PC, and its interface is less intimidating than SQL Server Management Studio. What you learn and discover, here, is applicable to any database tool that has a querying component. So here's the ask, who are the top customers over time? It's important to remember, before we have an answer to this question we have to…

Contents