A Pragmatic Approach to Database Programming with JDBC and MySQL: A programmer's guide to building high-performance MySQL database solutions

Name: A Pragmatic Approach to Database Programming with JDBC and MySQL: A programmer's guide to building high-performance MySQL database solutions
Rating: 4.5 (4 reviews)

Vivian Siahaan · Rismon Hasiholan Sianipar

Mar 2019 · Database Programming Book 1 · SPARTA Publishing

4.5

4 reviews

Ebook

439

Pages

Ratings and reviews aren’t verified Learn More

About this ebook

You will learn Java/MySQL fast, easy and fun. This book provides you with a complete MySQL guidance presented in an easy-to-follow manner. Each chapter has practical examples with SQL script and screenshots available. If you go through the entire chapters, you will know how to manage MySQL databases and manipulate data using various techniques such as MySQL queries, MySQL stored procedures, database views, triggers.

In the first part of the book, you will learn Basic MySQL statements including how to implement querying data, sorting data, filtering data, joining tables, grouping data, subquerying data, dan setting operators.

Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters.

In the next chapter, we will discuss the database views, how they are implemented in MySQL, and how to use them more effectively. After that, you will learn how to work with the MySQL triggers. By definition, a trigger or database trigger is a stored program executed automatically to respond to a specific event e.g., insert, update or delete occurred in a table. The database trigger is powerful tool for protecting the integrity of the data in your MySQL databases. In addition, it is useful to automate some database operations such as logging, auditing, etc.

Then, you will learn about MySQL index including creating indexes, removing indexes, listing all indexes of a table and other important features of indexes in MySQL. MySQL uses indexes to quickly find rows with specific column values. Without an index, MySQL must scan the whole table to locate the relevant rows. The larger table, the slower it searches. After that, you will find a lot of useful MySQL administration techniques including MySQL server startup and shutdown, MySQL server security, MySQL database maintenance, and backup. The last chapter gives you the most commonly used MySQL functions including aggregate functions, string functions, date time functions, control flow functions, etc.

Ratings and reviews

4.5

4 reviews

Python Sumatra

June 1, 2019

Good book.

About the author

Vivian Siahaan is an self-taught programmer who likes to explores new things. She was born, grew up in Hinalang Bagasan, Balige, on the shores of Lake Toba, Indonesia, and completed her secondary education from Balige High School. She started himself learning the programming languages Java, Android, JavaScript, CSS, C ++, Python, R, Visual Basic, Visual C #, MATLAB, Mathematica, PHP, JSP, MySQL, SQL Server, Oracle, Access, and others. She studied programming from scratch, starting from the most basic syntax and logics, by building a number of simple GUI applications. Database, animation and games are fields of programming that are of interest that she has always wanted to develop.

She can be found on her blog: http://viviansiahaan.blogspot.com/p/blog-page.html, her twitter: https://twitter.com/siahaanvivian, her facebook: https://web.facebook.com/siahaanvivian, and on her instagram: https://www.instagram.com/vivian.siahaan/ .

Vivian Siahaan has written dozens of ebooks that have been published on Sparta Publishing and have been sold on Amazon:

Vivian Siahaan, Rismon Hasiholan Sianipar, “A Walkthrough, Database-Driven Programming with Java GUI for Pragmatic Programmers”, 9781708564698, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “A Walkthrough, Database-Driven Programming with Python GUI for Pragmatic Programmers”, 9781708516307, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Learn Python in One Week: The Crash Course to Develop Database-Driven Projects”, 9781708992583, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Learn Java in One Week: The Crash Course to Develop Database-Driven Projects”, 9781709046339, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “MS Access And SQL Server Crash Course: A Step by Step, Project-Based Introduction to Java GUI Programming”, 9781708056858, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “MS Access And SQL Server Crash Course: A Step by Step, Project-Based Introduction to Python GUI Programming”, 9781707996520, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “MariaDB And PostgreSQL Crash Course: A Step by Step, Project-Based Introduction to Python GUI Programming”, 9781707959181, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Building Three Java GUI Applications Using MySQL, MariaDB, and PostgreSQL”, 9781706830726, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Building Two Desktop Applications Using Python GUI and MySQL”, 9781706260646, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Building Three Desktop Applications Using Java GUI and PostgreSQL”, 9781706591207, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “BUILDING TWO DESKTOP APPLICATIONS USING PYTHON GUI AND POSTGRESQL”, 9781706337270, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “BUILDING THREE DESKTOP APPLICATIONS USING JAVA GUI AND MYSQL”, 9781706395577, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Building Two Desktop Applications Using Python GUI and MariaDB”, 9781706121664, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Building Three Desktop Applications with SQLite and Java GUI”, 9781705407097, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Database and Image Processing Using Java GUI and Microsoft Access”, 9781704410425, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Database and Image Processing Using Python and Access”, 9781704189987, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Database and Image Processing Using SQL Server and Python”, 9781704121710, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “CRYPTOGRAPHY AND IMAGE PROCESSING with Java GUI and SQLite”, 9781704114965, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Access Database with JDBC: A Hands-On, Step-by-Step to Build Java GUI Projects for Pragmatic Programmers”, 9781699384015, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Access Database Crash Course: A Comprehensive, Project-Based Guide For Python Programmers”, 9781699297285, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Access Database for Pragmatic Programmers: A Step by Step Guide to Create Database-Driven Application Using Python”, 9781699124154, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “MASTERING SQL SERVER with Java GUI for Pragmatic Programmers”, 9781698392554, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “LEARNING SQL SERVER: A self-study to easy implement database-driven Java GUI applications”, 9781698204444, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Mastering Java: A self-study to easy implement sqlite-driven GUI applications”, 9781697994049, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Python GUI: For Signal and Image Processing”, 9781697574364, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “FROM ZERO TO JDBC HERO: GUI Development for SQLite-Based Applications with NetBeans”, 9781696804219, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “SQLite with JDBC for Beginners: Learn Fundamentals of Queries and Implement NetBeans-Based Projects Easily”, 9781696466707, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Learn SQLite with JDBC: Building Database-Driven Desktop Projects”, 9781696533638, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “From Zero To Python Hero: GUI Development for SQL Server-Driven Applications with PyQt”, 9781696461061, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Learn SQLite with Python: Building Database-Driven Desktop Projects”, 9781696314794, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “SQLite For Beginners: Learn Fundamentals of Queries and Implement PyQt-Based Projects Easily”, 9781696194372, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Fluent OpenCV-Python GUI with SQL Server: Building Responsive, Powerful Cross-platform, and Database-Driven Applications with PyQt”, 9781694665706, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Python GUI with SQL Server for Absolute Beginners: Building Responsive, Powerful Cross-platform, and Database-Driven Applications with PyQt”, 9781694413864, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “OpenCV-Python with PostgreSQL for Absolute Beginners: A Hands-On, Practical Database-Driven Applications”, 9781693294631, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “OpenCV-Python with MariaDB for Absolute Beginners: A Hands-On, Practical Database-Driven Applications”, 9781693435287, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “OpenCV-Python with MySQL for Absolute Beginners: A Hands-On, Practical Database-Driven Applications”, 9781693191831, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Learning PyQt5 with MariaDB for Absolute Beginners: A Hands-On, Practical Database Programming”, 9781691545476, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “LEARNING PyQt5: A Step by Step Tutorial to Develop PostgreSQL-Based Applications”, 9781691422647, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Learning MariaDB: A Comprehensive Approach to Developing Database-Driven Applications Using NetBeans”, 9781690730941, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “LEARNING PyQt5: A Step by Step Tutorial to Develop MySQL-Based Applications”, ISBN: 9781691345809, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Python GUI with MySQL: A Step By Step Guide to Database Programming”, ISBN: 9781686034343, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Postgresql For Python Gui: A Progressive Tutorial To Develop Database Project”, ISBN: 9781686474712, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “MARIADB WITH PYTHON GUI: A Hands-On, Project-Based Database Programming”, ISBN: 9781686885099, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “JAVA GUI WITH MYSQL: A Practical Approch to Build Database Project for Students and Programmers”, ISBN: 9781687411853, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “JAVA GUI WITH POSTGRESQL: A Practical Approach to Build Database Project for Students and Programmers”, ISBN: 9781687724847, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Java GUI With Mysql: Database And Image Processing, A Progressive Guide To Build Database Project”, ISBN: 9781688650503, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “POSTGRESQL FOR JAVA GUI: Database and Image Processing”, ISBN: 9781688940666, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “MYSQL FOR JAVA GUI: Database, Cryptography, and Image Processing”, ISBN: 9781689712934, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “POSTGRESQL FOR JAVA GUI: Database, Cryptography, and Image Processing”, ISBN: 9781689911122, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “MariaDB with Java GUI for Cryptography and Image Processing: A practical guide to build database-driven applications”, ISBN: 9781689911122, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “Step By Step Database Programming with JDBC and PostgreSQL”, ISBN: 9781093460988, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “A Pragmatic Approach to Database Programming with JDBC and MySQL”, ISBN: 9781093462692, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “A Practical Guide to Database Programming with PHP/MySQL”, ISBN: 9781093788983, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “The Self-Taught Coder: The Definitive Guide to Database Programming with Python and MySQL”, ISBN: 9781093671018, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “A Heuristic Database Programming with PHP/PostgreSQL”, ISBN: 9781094749426, SPARTA Publishing.

Vivian Siahaan, Rismon Hasiholan Sianipar, “The Ultimate Guide to Professional Database Programming with Python and PostgreSQL”, ISBN: 9781093671018, SPARTA Publishing.

In addition, Vivian Siahaan has also written dozens of Indonesian ebooks that have been published on Sparta Publishing and have been sold on Google Play Books:

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman Java Mulai Dari Nol Sampai Master”, Sparta Publishing, November.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “JavaScript Dari A Sampai Z”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “PHP/MySQL Untuk Mahasiswa dan Pembelajar Mandiri”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Java Untuk Grafika Komputer dan Animasi”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “MATLAB Untuk Mahasiswa dan Peneliti”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman Java Untuk SMA/SMK Sederajat”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “HTML dan CSS3: Soal dan Penyelesaian”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman C++: Question And Answer”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman Java Untuk SMA/SMK Sederajat”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Pemrograman Database Dengan Java/MySQL”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Konsep dan Praktek Pemrograman MATLAB: Matriks, Citra Digital, Komputasi Numerik, dan Persamaan Differensial”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Visual Basic: Cookbook”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman C++ Untuk SMA/SMK dan Mahasiswa”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “C# .NET: Belajar Dari Nol Sampai Master”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Pemrograman Aplikasi Dengan GUI Python”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Grafika Dalam JavaScript: Seri Belajar Cepat”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman PHP/MySQL: Cookbook”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Metode-Metode Pengolahan Citra: Disertai Banyak Kode MATLAB”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “PHP/MySQL Untuk Mahasiswa”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman Java: Question And Answer”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Dasar CSS dan JavaScript”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman Visual Basic Dari A Sampai Z”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman C++: Cookbook”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Konsep dan Praktek C++”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Teori dan Implementasi Pemrograman PHP/MySQL Untuk Web Developer”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Fundamental C++: Konsep Dasar dan Praktek”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman Java: Cookbook”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Teori dan Praktek C++: Cocok Bagi Programmer dan Profesional”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Visual Basic .NET: Question And Answer”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Koleksi Projek C# .NET: Kriptografi, Watermarking, Steganografi, Pengkodean Data, Algoritma, dan Grafika 2D & 3D”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Membangun Dari Nol Sistem Manajemen Database Sekolah dengan Python/MySQL”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Sistem Manajemen Database Access & SQL Server Dengan Visual Basic .NET”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Pemrograman Database Menggunakan Java/PostgreSQL”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Pemrograman Database Access dan SQL Server Dengan Visual Basic .NET”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Java/MySQL Untuk Sistem Manajemen Database Jejak Kriminal”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “PHP dan MySQL Untuk Programmer dan Web Developer”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Pemrograman Database Dengan Python/PostgreSQL”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Teori dan Praktek Pemrograman Python”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Konsep dan Implementasi Pemrograman Python”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Java/MySQL: Membangun Dari Nol Sistem Manajemen Database Sekolah”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Membangun Sistem Manajemen Database Dengan Python/MySQL”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman GUI Python: Menciptakan Sendiri Aplikasi Editor Teks, E-Drum, Game Catur, dan Paint”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Tutorial Java: GUI, Grafika, dan Animasi”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Pemrograman Database Dengan Visual C# .NET”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Visual C# .NET: Pemrograman, Database, dan Web”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Teori dan Praktek Manajemen Database Dengan Java/MySQL”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Database dan Kriptografi Menggunakan Java/MySQL”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Teori dan Aplikasi Pemrograman PHP/MySQL Untuk Programmer”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Belajar Mandiri Pemrograman Java: PBO dan GUI”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Membangun Sistem Manajemen Database Access dan SQL Server Dengan Visual C# .NET”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Pemrograman Game Dengan Visual Basic .NET”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Koleksi Projek Visual Basic .NET dan Visual C# .NET”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman C: Konsep dan Implementasi”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Struktur Data Dengan Java Untuk Mahasiswa dan Peneliti”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Sistem Manajemen Database Dengan Python/MySQL”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Pemrograman Java Untuk GUI dan Animasi”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Visual Basic .NET Untuk Mahasiswa dan Peneliti”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman Database Access dan SQL Server Menggunakan Visual C# .NET”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Visual C# .NET Untuk Mahasiswa dan Peneliti”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Teori dan Praktek Pemrograman Animasi dan Game dengan Visual Basic .NET”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Langkah Demi Langkah Pemrograman Database SQLite dan MySQL dengan GUI Python”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman GUI Python dan Database: Widget PyQt, SQLite, MySQL, dan Grafika”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman Animasi dan Game Dengan Visual Basic .NET”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Pemrograman C Untuk SMA/SMK dan Mahasiswa”, Sparta Publishing.

Vivian Siahaan dan Rismon Hasiholan Sianipar, “Sistem Manajemen Database Access dan SQL Server Dengan Visual C# .NET”, Sparta Publishing.

Rismon Hasiholan Sianipar was born in Dolok Ulu, Simalungun Regency, North Sumatra on April 25, 1977. After graduating from SMAN-3 Pematang Siantar, in 1994 the writer migrated to the city of Jogjakarta. In 1998 and 2001 the authors completed their Bachelor of Engineering (S.T) and Masters of Engineering (M.T) both in Electrical Engineering, Gadjah Mada University, Indonesia, under the supervision of Prof. Dr. Adhi Soesanto and Prof. Dr. Thomas Sri Widodo, with a focus on research on non-stationary signals by analyzing their energy using a time-frequency map. Because of its non-stationary nature, the distribution of signal energy becomes very dynamic on the time-frequency map. By mapping the energy distribution in the time-frequency field using discrete wavelet transforms, one can design a non-linear filter so that it can analyze the character and data patterns contained therein. In 2003, the author obtained a Monbukagakusho scholarship from the Japanese Government. In 2005 and 2008, he completed his Master of Engineering (M.Eng) and Doctor of Engineering (Dr.Eng) education at Yamaguchi University, under the guidance of Prof. Dr. Hidetoshi Miike. Both on the master's thesis and on his doctoral thesis, R.H. Sianipar combines the strength of the non-linear filter Fitzhugh-Nagumo with the ECC cryptosystem (elliptic curve cryptography) both to suppress noise in digital images and digital video and maintain its authenticity. The results of this study have been documented in international scientific journals and are officially patented in Japan.

He actively collaborates with several universities and research institutions in Japan, especially in the fields of cryptography, cryptanalysis, and digital audio / image / video forensics. R.H. Sianipar also has experience in conducting code-breaking methods (cryptanalysis) on a number of intelligence data that are the object of research studies in Japan. R.H. Sianipar has a number of Japanese patents, and has written a number of national / international scientific articles, and dozens of national books. R.H. Sianipar has also participated in a number of workshops related to cryptography, cryptanalysis, digital watermarking, and digital forensics. In a number of workshops, R.H. Sianipar helped Prof. Hidetoshi Miike for creating applications related to steganography, cryptography, watermarking, non-linear screening, intelligent descriptor-based computer vision, and others, which are used as training material.

Field of interest in studying R.H. Sianipar is multimedia security, digital signal / image / video processing, cryptography, digital communication, digital forensics, and data compression / encoding. Until now, R.H. Sianipar continues to develop applications related to digital signal, image and video analysis, both for research purposes and for commercial purposes based on the programming languages MATLAB, VB.NET, C # .NET, and Java.

He can be found in his blog: http://rismonhasiholansianipar.blogspot.com/p/beranda.html and in his twitter: https://twitter.com/SianiparRismon.

With Vivian Siahaan, Rismon Hasiholan Sianipar has written dozens of ebooks that have been published on Sparta Publishing and have been sold on Amazon: