provide by DQLab

Image for post
Image for post

My fourth project after completing a course in DQLab about fundamental SQL. I have completed the modules of fundamental SQL use SELECT statement, FUNCTION, GROUP BY, INNER JOIN, UNION and Having. This project is provided by DQLab and the database used is MySQL.

DATA USED IN THE PROJECT

The dataset used is data from the DQLab Store which is an e-commerce where buyers and sellers meet each other. Users can buy goods from other users who sell. Each user can be both a buyer and a seller.

There are 4 tables used in this project:

1. users table: contains details…


Mentor: Trisna Yulia Junita — Data Scientist at PT. BUMA

Image for post
Image for post

My third project after completing a course in DQLab about fundamental SQL. I have completed the modules of fundamental SQL using the SELECT, FUNCTION, GROUP BY, INNER JOIN, UNION and Having. This project is provided by DQLab and uses MariaDB.

In this project, xyz.com will review the company’s performance during the last quarter. A data analyst is asked to provide data and analysis regarding the current condition of the company.

List of Tables

The tables that will be used in this project are:


Mentor: Nelda Ampulembang Parenta — Senior Data Analyst at Logisly

Image for post
Image for post

Another project I worked on after completing a course in DQLab about fundamental SQL. I have completed the modules of fundamental SQL use SELECT statement, FUNCTION, GROUP BY, INNER JOIN, UNION and Having. This project is provided by DQLab and uses MariaDB.

1.1 Dataset Brief

The dataset used contains transactions from 2009 to 2012 with a total of raw data is 5500, including order status which is divided into order finished, order returned and order cancelled.

The dataset that will be used in this project contains the following data: 1. OrderID 2. Order Status 3. Customer 4. Order Date 5…


provide by DQLab

Image for post
Image for post

Finally, I have completed a course on DQLab about fundamental SQL in data analyst career track. I have completed the modules of fundamental SQL use SELECT statement, FUNCTION, GROUP BY, INNER JOIN, UNION and Having. Then, I worked on the first project provided by DQLab to apply the knowledge that I had learned. Here, the results of my first project.

Test SQL — MySQL Dialect

  • Left Join

Consider the following two tables:

Nilda Nurmala

Be happy

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store