Pemanfaatan Aplikasi MySQL untuk Membantu Siswa SMK Swasta Nur Azizi dalam Pengolahan Data

Yunita Sari Siregar; Boni Oktaviana Sembiring; Eka Rahayu; Hasdiana Hasdiana; Rizky Franchitika

doi:10.70340/japamas.v3i2.185

Authors

Yunita Sari Siregar Universitas Harapan Medan
Boni Oktaviana Sembiring Universitas Harapan Medan
Eka Rahayu Universitas Harapan Medan
Hasdiana Hasdiana Universitas Harapan Medan
Rizky Franchitika Universitas Harapan Medan

DOI:

https://doi.org/10.70340/japamas.v3i2.185

Keywords:

MySQL, Pengolahan Data, SMK, Manajemen Basis Data, Teknologi Pendidikan, Clustering, Data Science, Vocational school

Abstract

The rapid development of technology has influenced various aspects of education, including data management in schools. One of the key aspects of vocational education is efficient data processing to support administrative and academic activities. This community service program was conducted to provide students of SMK Swasta Nur Azizi with knowledge and skills in utilizing MySQL as a database management system for data processing. MySQL was chosen for its capability to efficiently manage and process data, making it highly relevant to industry needs. This program employed a qualitative approach with a case study method, focusing on the implementation of MySQL in student data processing. Data were collected through interviews, observations, and documentation to analyze the effectiveness of MySQL in school operations. The activities included socialization sessions covering theoretical explanations of MySQL fundamentals, software installation, and hands-on practice in database creation and SQL queries. The results of this program indicate that students were able to understand the basic concepts of MySQL, create databases and tables, and process data using fundamental SQL commands such as SELECT, INSERT, UPDATE, and DELETE. Thus, this initiative is expected to enhance students' data processing skills, enabling them to apply these competencies in various fields and strengthen their qualifications in the job market.

Downloads

Download data is not yet available.

References

M. A. Nur and M. Saihu, “Pengolahan Data,” Scientica, vol. 2, no. 11, pp. 163–175, 2024.

K. Sidharta and T. Wibowo, “Studi Efisiensi Sumber Daya Terhadap Efektivitas Penggunaan Database: Studi Kasus SQL Server dan MySQL,” Conf. Business, Soc. Sci. Innov. Technol., vol. 1, no. 1, pp. 508–515, 2020, [Online]. Available: https://journal.uib.ac.id/index.php/cbssit/article/view/1455.

Z. Reno Saputra et al., “Perancangan Aplikasi Pengolahan Data Obat Berbasis Mysql Dengan Client Server Mysql-Based Data Processing Design Using Client Server,” J. Digit. Teknol. Inf., vol. 2, no. 1, pp. 43–50, 2019.

E. Hartati, “Sistem Informasi Transaksi Gudang Berbasis Website Pada Cv. Asyura,” Klik - J. Ilmu Komput., vol. 3, no. 1, pp. 12–18, 2022, doi: 10.56869/klik.v3i1.323.

S. Bahri, “Rancang Bangun Sistem Informasi Berbasis Web Pada Teaching Factory Bakery Smk Putra Anda Binjai,” Informatika, vol. 8, no. 3, pp. 95–100, 2020, doi: 10.36987/informatika.v8i3.1820.

M. Ahmadar, P. Perwito, and C. Taufik, “PERANCANGAN SISTEM INFORMASI PENJUALAN BERBASIS WEB PADA RAHAYU PHOTO COPY DENGAN DATABASE MySQL,” Dharmakarya, vol. 10, no. 4, p. 284, 2021, doi: 10.24198/dharmakarya.v10i4.35873.

R. D. Alit, M. C. Aruan, and A. Rahadyan, “Sistem Informasi Pelayanan Medis Pada Pasien di Klinik Insani Citeureup Berbasis Java,” Innov. Res. Informatics, vol. 2, no. 1, pp. 16–21, 2020, doi: 10.37058/innovatics.v2i1.1412.

Aulia Fitri Maharan, Christian Wiradendi Wolor, and Roni Faslah, “Analisis Sistem Informasi Pengolahan Data Gugus Tugas Pemenangan Caleg X,” J. Multidisiplin Ilmu Akad., vol. 1, no. 4, pp. 629–636, 2024, doi: 10.61722/jmia.v1i4.2347.

E. W. Fridayanthie and T. Mahdiati, “RANCANG BANGUN SISTEM INFORMASI PERMINTAAN ATK BERBASIS INTRANET (STUDI KASUS: KEJAKSAAN NEGERI RANGKASBITUNG) Eka,” J. Khatulistiwa Inform., vol. IV, no. 2, pp. 126–138, 2016.

Nurmalasari, Anna, and R. Arissusandi, “RANCANG BANGUN SISTEM INFORMASI AKUNTANSI LAPORAN LABA RUGI BERBASIS WEB PADA PT. UNITED TRACTORS PONTIANAK,” J. Sains dan Manaj., vol. 7, no. 2, pp. 6–14, 2019.