课程: Coding Exercises: SQL Data Science

Up for a code challenge? - SQL教程

课程: Coding Exercises: SQL Data Science

开始一个月试用 购买团队方案

Up for a code challenge?

“

(bouncy music) - [Narrator] Hello. Welcome to SQL code challenge. A series of videos where you will be challenged to write SQL queries to solve various problems and answer questions. The challenges will start out at a low difficulty level and they will keep getting slightly more complex as you move towards the end. In these videos, we'll use a single database for simplicity. The database has multiple tables containing information about social media post analytics, statistics about countries and Olympic games. You can download the database from the exercise files. I'll be using pgAdmin, a free cross-platform application that works with PostgreSQL databases. To get started with pgAdmin, you need to install it on your machine, and then just open up the provided database using the application. Spend some time taking a look at the structure of the database and the tables that the database has. The challenges will assume that you have already taken a peek and know a little bit about the database before you start writing your queries. Good luck and let's get started.

内容