Hi all! Welcome back! In analysing the data, we often use data visualization to understand the characteristics inlcuding trends in our data. One of the libraries in python that is commonly used for data visualization purposes is matplotlib. So, let’s start! Pengenalan Dataset Pertama, kita akan membuka data dari: ‘https://dqlab-dataset.s3-ap-southeast…

SCALAR VS AGGREGATE FUNCTION Functions are methods used to perform data operations on the database. These operations can be numerical calculations such as sum, count, avg, etc; or non-numeric operations such as string concatenations and sub-strings. SQL functions can be divided into 2 categories, namely scalar functions and aggregate functions. Scalar functions in SQL…

Hello all! I am starting my journey on exploring more about data analyst. Let’s start with SQL! What is SQL ? SQL is the abbreviation of Structured Query Language, which is a standard computer language used to interact with a database system — or rather a Relational Database Management System…

Welcome back on my journey of learning SQL with DQLab! Let’s explore more ! Suppose we got a sales transaction report of kotak pensil and flashdisk 32 GB for branch X. …