From the course: Intermediate SQL for Data Scientists (2021)
Join today to access over 24,700 courses taught by industry experts.
Basic aggregate functions
From the course: Intermediate SQL for Data Scientists (2021)
Basic aggregate functions
- [Instructor] Now that we have our database set up and our data loaded, let's explore the data. Now in this section of the course, I'm going to quickly review some basic elements of SQL that you are probably already familiar with, but I just want to make sure that we all start at the same sort of common ground. So what we'll look at in this video, are some basic aggregation functions. So the first thing I'm going to do is navigate up to the tools menu, and select query tool, and that will open a query window for us, and this is where I can enter a SQL command. Now, before I enter the SQL command, I just want to look over here in the left pane in this hierarchical browser, and I just want to see that we have three tables, and these tables are in the data size schema, the tables are called company departments, company regions, and employees. So those are the three we're going to work with. So let's say I want to get a…
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.