• BERITA & ACARA
  • E-LEARNING
  • MYUMN
  • PENELITIAN & PENGABDIAN
  • GLOBAL OFFICE
  • NEWS & EVENT
  • E-LEARNING
  • MYUMN
  • RESEARCH & SERVICE
  • GLOBAL OFFICE
Logo-web-UMN2-2Logo-web-UMN2-2logo-baru-umnlogo-baru-umn
  • Profile
    • Profile
    • Management
      • Rector Welcome Speech
      • University Board Member
      • Lecturers
    • Business Partner
      • Kompas Gramedia
      • Skystar Ventures
      • UMNConsulting
      • DQ Lab
    • Sustainability Program
    • Master Plan Kampus
  • Why UMN?
    • Facilities
    • Achievements
    • Scholarship
    • Career Opportunity
    • Testimonials
  • Academic
    • Faculty of Information & Technology
      • Informatics
      • Computer Engineering
      • Electrical Engineering
      • Engineering Physics
      • Information System
      • Joint Degree – Informatics Program
    • Faculty of Business
      • Dept of Hotel Operations
      • Accounting
      • Management
      • Joint Degree – Management Program
      • MMT – Master of Technology Management
    • Faculty of Communication
      • Strategic Communication
      • Digital Journalism
      • Strategic Communication (DL)
      • Master Communication Studies
    • Faculty of Art & Design
      • Visual Communication Design
      • Architecture
      • Film & Animation
    • Continuing Education Department (CED)
  • Admission
  • Campus Life
    • Student Activities
      • (BEM)Student Executive Board
      • DKBM
      • UKM
      • KAMI
    • Infrastructure
      • Library
      • Access & Environment
      • Dormitory UMN
      • Bus Kampus
✕
Tips and Tricks of Learning Data Science for Non-IT Beginners
March 7, 2022
MMT UMN Takes the Initiative to Share Knowledge About Circular Economy
March 7, 2022

Learn SQL, An Essential Skill for Data Practitioners

Published by umnadmin on March 7, 2022
Categories
  • DQLab EN
  • General EN
  • News
Tags
  • artikel dqlab
  • beasiswa DQlab
  • dqlab umn
  • tetris program dqlab

(dok. DQLab)

(dok. DQLab)

TANGERANG – Seeing the need for talents working with data in Indonesia, DQLab offers a scholarship Tetris Program themed “#StackYourSkill” on Tuesday (22/02/22) virtually. The Tetris Program offers scholarships to study data science intensively, build a portfolio, and get internships with well-known companies such as Tokopedia, Kompas Gramedia, Kawan Lama Group, Rupa-rupa, Niagahoster, Kitabisa and Xeratic. At the same time, DQLab also invited Muhammad Farhan Novianto (Aan), a Business Intelligence Analyst at Bukalapak, to talk about Structured Query Language (SQL).

Aan expresses the importance of SQL. The first few tests to become a data practitioner are SQL, programming using R/Pyton, data analysis, and data modelling. Managers or seniors do not commonly take the SQL tests, but it is mandatory for fresh graduates or juniors. When looking for a job as a data analyst, it is a job requirement that you master SQL. 

SQL is important because all company data becomes a database, and all tasks regarding data analysts have something to do with SQL. Aan said that SQL will become “The New Microsoft Office.”

“What The New Microsoft Office means is that now, mastering Microsoft Office no longer is a job requirement, but it is seen as a basic skill that most working people can use. In the future, SQL will be like that too,” Aan explained.

The database system is a system used to store data. The most popular database system is a relational database or Relational Data Management System (RDBMS). RDBMS is a software system that its database relates or connects to its tables. There are other database systems such as network database, hierarchical database, object-oriented database, etc.

SQL is the language used for data management in RDBMS. SQL is usually a simple command containing instructions for data manipulation. SQL commands are often called “Query”. There are two types of databases: RDBMS or SQL and Non-RDBMS or No-SQL. 

RDBMS has its characteristics. They consist of interconnected tables using a Primary key and Foreign Key. The schema has been determined before the data is entered, suitable for application data with a consistent structure and can be used for complex queries. While Non-RDMS consists of documents that use key-values and irregular shapes, dynamic or unstructured schemas, suitable for log data or data with an uncertain number of variables, not suitable for complex queries.

Also read Webinar DQLab x Shopee: Mengenal SQL pada Business Analytics untuk Mahasiswa

Aan proceeded to give some examples of databases. For RDBMS: MySQL, PostgreSQL, SQLite, Oracle, SQL-Server, Google BigQuery, Redshift, and Hive. While Non-RDBM examples are MongoDB, Redis, Casandra, Hbase and Neo4j. 

He also shared commonly used applications, namely the Command Line (CMD). In addition, there are other special applications for Query as well, namely DBeaves, HeidiSQL, SQL WorkbenchJ. Then there is the SQL-Based Dashboard, namely Metabase, Redash and Superset. And the last programming language for analysis is R, Python, Golang and NodeJS.

In this session, Aan also explains why you should learn to use MySQL. According to him, because many people use it, it is open-source. Many developers, many web applications use MySQL as a default database. The installation is relatively easy, and there is much accessible information regarding it on the internet since many experienced people use it.

“When there is a problem in MySQL, we can politely complain and there will be many developers who will help,” Aan said.

Other than introducing SQL to the participants, Aan also showed how to use SQL and import data. So the participants of this program can see how to properly use SQ and even try it out themselves. This is one of the main key success factors when learning data science.

In this Tetris program, it is hoped that people can learn data science online to the fullest, and achieve a career as a data practitioner in their dream company. Feel the benefits of participating in the data science learning program at  DQLab.

*by DQLab

Kuliah di Jakarta untuk jurusan program studi Informatika| Sistem Informasi | Teknik Komputer | Teknik Elektro | Teknik Fisika | Akuntansi | Manajemen| Komunikasi Strategis | Jurnalistik | Desain Komunikasi Visual | Film dan Animasi | Arsitektur | D3 Perhotelan | International Program, di Universitas Multimedia Nusantara. www.umn.ac.id

Share

Related posts

January 16, 2023

Proud! UMN Students Win The Best Student at France’s Shortdoc Award


Read more

Pemberian Medali kepada Pemenang (Dok. UMN)

January 16, 2023

Birthing Young Researchers, UMN and CYS Hold a Youth Research Competition Throughout Banten


Read more

Dekan Fakultas Teknik dan Informatika UMN Niki Prastomo (kanan) menerima penghargaan dari Nanotech Development Center and Consultant. (dok. UMN)

January 16, 2023

UMN Lecturer, Together with the Head of the National Agency for Research and Innovation, Wins the NDCC Scientist Achievement Award


Read more
  • Home
  • Profile
  • Admission
  • Academic Calendar
  • Campus Life
  • News & Events
  • Achievements
  • Dormitory UMN
  • Career at UMN
  • CED

Admission Information

Email : [email protected]
Format: name, address, phone number,
majors, and description

UMN Information

Email : [email protected]

Yayasan Multimedia Nusantara
Universitas Multimedia Nusantara

Jl. Boulevard, Gading Serpong, Kel. Curug Sangereng, Kec. Kelapa Dua, Kab. Tangerang,
Prop. Banten, Indonesia
(T)+62-21.5422.0808
(F)+62-21.5422.0800
e-mail: [email protected]

© Copyright Universitas Multimedia Nusantara. Designed by Dorado
    • No translations available for this page
      • Daftar Sekarang!

      • Hubungi Kami