Satria Tech

QUERIES ON MULTI-TABLES WITH JOIN

In database design, it’s often necessary to break a large table into several smaller ones. This process, known as normalization, is done to…

ANALYSIS OF BPJS DIAGNOSIS AND ITS RELATIONSHIP WITH OPERATIONAL, FINANCIAL, AND POLICY ASPECTS

This project is a strategic analytics dashboard designed to evaluate the operational efficiency, financial sustainability, and enrollment…

DATA DEFINITION LANGUAGE CREATE, ALTER, & DROP TABLE

In this article, we will discuss the types of Data Definition Language (DDL) commands. DDL itself is an SQL command used to organize/manage…

ARITHMETIC AND AGGREGATE OPERATIONS IN SQL QUERIES

In Structured Query Language (SQL), we can not only retrieve data but also perform simple arithmetic calculations directly within a query.

FINDING Z-SCORE AND GETTING PERCENTAGE WITH Z-TABLE

Z-Score is a statistical measure that shows how far a value is above or below the average, which is measured in standard deviation units…

DETERMINING STANDARD DEVIATION USING THE EMPIRICAL RULE: A CASE STUDY