SQL Data Exploration

SQL Project based on Udemy courses dataset. Data Exploration


This project uses SQL to query data from a dataset of courses on Udemy. 

The first part of the code includes a script that selects data from the Udemy table in the database. Several SQL queries are then performed to answer various questions about the dataset. These queries use different SQL syntaxes such as SELECT, FROM, WHERE, GROUP BY, ORDER BY, and TOP.

The second part of the code creates two new tables called course_info and course_price using the CREATE TABLE syntax. Data is then inserted into these tables using the INSERT INTO syntax.

The final part of the code uses the JOIN syntax to combine data from the course_info and course_price tables. Two SQL queries are performed using JOIN to answer different questions about the dataset.