WHERE Do I Start? Belajar SQL dan Database dari Dasar
Keywords:
SQL, Basis Data Relasional, Analisis Data, Data Base, Pengolahan DataSynopsis
Buku ini membahas dasar-dasar pengelolaan basis data relasional menggunakan SQL secara sistematis dan praktis. Materi mencakup pengenalan database, struktur tabel, tipe data, pengambilan dan penyaringan data, fungsi agregat, penggabungan tabel, subquery, manipulasi data, transaksi, serta konsep lanjutan seperti stored objects dan window functions. Dilengkapi dengan contoh kueri, ilustrasi, analogi kontekstual, dan praktik terbaik penulisan SQL, buku ini membantu pembaca memahami konsep sekaligus menerapkannya dalam pengelolaan data. Buku ini cocok bagi pemula, mahasiswa, maupun praktisi yang ingin membangun keterampilan SQL sebagai dasar pengolahan dan analisis data secara terstruktur, efisien, dan andal.
References
Beaulieu, A. (2020). Learning SQL (3rd ed.). O'Reilly Media.
Ben-Gan, I. (2019). T-SQL window functions: For data analysis and beyond
(2nd ed.). Microsoft Press.
Ben-Gan, I. (2023). T-SQL fundamentals (4th ed.). Microsoft Press.
Botros, S., & Tinley, J. (2021). High performance MySQL (4th ed.). O'Reilly
Media.
Chamberlin, D. D., & Boyce, R. F. (1974). SEQUEL: A structured English query
language. In Proceedings of the 1974 ACM SIGFIDET Workshop on Data
Description, Access and Control (pp. 249–264). Association for Computing
Machinery. https://doi.org/10.1145/800296.811515
Churcher, C. (2016). Beginning SQL queries: From novice to professional (2nd
ed.). Apress. https://doi.org/10.1007/978-1-4842-1955-3
Codd, E. F. (1970). A relational model of data for large shared data banks.
Communications of the ACM, 13(6), 377–387.
https://doi.org/10.1145/362384.362685
Connolly, T., & Begg, C. (2015). Database systems: A practical approach to
design, implementation, and management (6th ed.). Pearson.
Date, C. J. (2015). SQL and relational theory: How to write accurate SQL code
(3rd ed.). O'Reilly Media.
DeBarros, A. (2022). Practical SQL: A beginner's guide to storytelling with data
(2nd ed.). No Starch Press.
Elmasri, R., & Navathe, S. B. (2016). Fundamentals of database systems (7th
ed.). Pearson.
Gray, J. (1981). The transaction concept: Virtues and limitations. In Proceedings
of the 7th International Conference on Very Large Data Bases (pp. 144
.
Gray, J., & Reuter, A. (1992). Transaction processing: Concepts and techniques.
Morgan Kaufmann.
Hernandez, M. J. (2022). Database design for mere mortals: A hands-on guide
to relational database design (4th ed., 25th anniversary ed.). Addison
Wesley Professional.
Karwin, B. (2022). SQL antipatterns, volume 1: Avoiding the pitfalls of database
programming. Pragmatic Bookshelf.
Karwin, B. (2026). More SQL antipatterns: Avoid common but deadly mistakes
of database optimization. Pragmatic Bookshelf.
Microsoft. (n.d.). SELECT (Transact-SQL). Microsoft Learn.
Molinaro, A., & de Graaf, R. (2020). SQL cookbook: Query solutions and
techniques for database developers (2nd ed.). O'Reilly Media.
Oracle. (2026). Oracle Database SQL language reference (Release 19).
Petrov, A. (2019). Database internals: A deep dive into how distributed data
systems work. O'Reilly Media.
PostgreSQL Global Development Group. (n.d.).
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database system
concepts (7th ed.). McGraw-Hill Education.
SQLite. (2024). SQL as understood by SQLite.
Viescas, J. L. (2018). SQL queries for mere mortals: A hands-on guide to data
manipulation in SQL (4th ed.). Addison-Wesley Professional.
Published
October 16, 2026
Categories
Copyright (c) 2026 Publica Indonesia Utama
License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
