Open access peer-reviewed Edited Volume

SQL Programming in Practice

Duc-Man Nguyen

Duy Tan University

Dr. Nguyen Duc Man is a member of the DSA-Da Nang Software Association, Vietnam. He was awarded the Award for Excellent effort in Training and Management by the Duy Tan University, Vietnam for several years in a row, and received the Certificate of Merit for Excellent effort in Training and Management by the Ministry of Education and Training, Vietnam. His current research interests are software testing, mobile testing, test automation, test case generation, context-driven testing, and ML for testing.


Van-Loi Nguyen

University of Danang

Dr. Van-Loi Nguyen received his Master of Engineering in Computer Science from the University of Danang, Vietnam in 2010, and a Ph.D. degree from Soongsil University, Korea, in 2017. He is currently a lecturer at the Vietnam - Korea University of Information and Communication Technology, the University of Danang. He has over 18 years of experience teaching and researching programming, databases, machine learning, information retrieval, multimedia, and artificial intelligence.


Database Classification Types of Databases SQL Basic Drop Statement Aggregate Functions Conversion Function Date Function Mathematical Functions User-Defined Types User-Defined Functions String Data Type Pivoting Data in SQL

Register your interest in contributing to this book

Collaborate with our community and contribute your knowledge.

About the book

Nowadays, all types of businesses ranging from the smallest e-com stores to the biggest corporations, use data to run operations. There are billions of bytes of data getting generated every minute. However, raw data doesn’t come in that handy on its own. There are many data management tools and applications. SQL or Structured Query Language is one of the programming languages which is used to communicate with the databases for the creation, deletion, and retrieval of data from it. The ability to use SQL will help you get more out of your data than just reading it. It can be used for ad-hoc data analysis and reporting and more extensive projects involving multiple tables and complex applications.

SQL is worth learning because it’s a programming language that’s in demand in the tech industry and in other sectors that need technology. Most software developers who know SQL earn respectable salaries. Learning SQL can not only enhance your skills, but it can also give you a better understanding of the applications you work with daily. In this book, we will go through the details of SQL and how to use it effectively. The goal of this book is to have many practical application examples that will help learners easily acquire and self-study SQL.

Publishing process

Book initiated and editor appointed

Date completed: May 3rd 2022

Applications to edit the book are assessed and a suitable editor is selected, at which point the process begins.

Chapter proposals submitted and reviewed

Deadline for chapter proposals: May 31st 2022

Potential authors submit chapter proposals ready for review by the academic editor and our publishing review team.

Register for the book

Approved chapters written in full and submitted

Deadline for full chapters: July 30th 2022

Once approved by the academic editor and publishing review team, chapters are written and submitted according to pre-agreed parameters

Full chapters peer reviewed

Review results due: October 18th 2022

Full chapter manuscripts are screened for plagiarism and undergo a Main Editor Peer Review. Results are sent to authors within 30 days of submission, with suggestions for rounds of revisions.

Book compiled, published and promoted

Expected publication date: December 17th 2022

All chapters are copy-checked and typesetted before being published. IntechOpen regularly submits its books to major databases for evaluation and coverage, including the Clarivate Analytics Book Citation Index in the Web of ScienceTM Core Collection. Other discipline-specific databases are also targeted, such as Web of Science's BIOSIS Previews.

About the editor

Duc-Man Nguyen

Duy Tan University

1. Name: Nguyen Duc Man Office: Room 601, 254 Nguyen Van Linh, Danang, Vietnam Tel: +84-2363 650 403 (Ext 601) Mobi: 0904 235 945 Email: 2. Education: BSc. Information Technology Duy Tan University, Vietnam 1999 MSc. Computer Science Danang University, Vietnam 2009 PhD. Computer Science Duy Tan University, Vietnam 2020 3. Academic experience: Duy Tan University, Vietnam Teaching Lecturer 2004- Present FT 4. Non-academic experience: HSD Corporation, Ho Chi Minh, Vietnam Analysis, Design and Code, DB Design Software Developer 1999-2001 FT Duy Tan Software Center, Vietnam Team leader, Planning, A&D Project Lead 2001-2003 FT 5. Certifications or professional registrations: - Certificate for completion of Train the Trainer courses (Software Capstone Project, Requirements Engineering, Software Architecture, Software Project management, software Process and Quality management, Software Integration Practices). Institute of Software Research, Carnegie Mellon University, USA. (2010, 2014, 2016, 2017, 2018, 2019). - 7 Professional Development Hours for participation in the Fundamentals of Program Assessment Workshop, ABET Symposium (2017) - 7 Professional Development Hours for participation in the Self-Study Development Workshop ABET Symposium (2017) - 14 Professional Development Hours for participation at the 2017 ABET Symposium, ABET Symposium (2017) - Software Testing and Automation Conference. VISTACON 2011, Ho Chi Minh, Vietnam (2011). - Fagan Software Inspection Method. ECCI Group, Vietnam (2011). - HP Train the Trainer courses: HP QTP, LoadRunner, Quality Center (2011). 6. Membership in professional organizations: - Member of DSA-Da Nang Software Association, Vietnam. 7. Honors and awards: - Awards for Excellent effort in Training and Management. Duy Tan University, Vietnam (2003, 2006, 2007, 2008, 2009, 2010, 2012). - Certificate of Merit for Excellent effort in Training and Management. Ministry of Education and Training, Vietnam (2008- 2009, 2010- 2011, 2013- 2014). - Certificate of Merit of the People Committee of Da Nang. Danang, Vietnam (2011-2012). 8. Service activities: - Institutional service: • Students’ Awards Committee • Faculty Development Committee • Scholarship Committee • Faculty Council 9. Publications and presentations from the past five years: 1. Cheng, Y. H., Chang, P. C., Nguyen, D. M., & Kuo, C. N. (2020). Automatic Music Genre Classification Based on CRNN. Engineering Letters, 29(1). 2. Huynh, Q. T., Pham, L. T., Ha, N. H., & Nguyen, D. M. (2020). An Effective Approach for Context Driven Testing in Practice—A Case Study. International Journal of Software Engineering and Knowledge Engineering, 30(09), 1245-1262. 3. Nguyen, D. M., Huynh, Q. T., Ha, N. H., & Nguyen, T. H. (2020). Automated test input generation via model inference based on user story and acceptance criteria for mobile application development. International Journal of Software Engineering and Knowledge Engineering, 30(03), 399-425. 4. Nguyen, D. M., Do, H. N., Huynh, Q. T., Vo, D. T., & Ha, N. H. (2018, August). Shinobi: A Novel Approach for Context-Driven Testing (CDT) Using Heuristics and Machine Learning for Web Applications. In International Conference on Industrial Networks and Intelligent Systems (pp. 86-102). Springer, Cham. 5. Hoang-Nhat, D. O., NGUYEN, D. M., HUYNH, Q. T., & Nhu-Hang, H. A. (2018). One2Explore-Graph Builder for Exploratory Testing from a Novel Approach. 6. Nguyen, M. D., Huynh, T. Q., & Nguyen, T. H. (2016, November). Improve the Performance of Mobile Applications Based on Code Optimization Techniques Using PMD and Android Lint. In International Symposium on Integrated Uncertainty in Knowledge Modelling and Decision Making (pp. 343-356). Springer, Cham. 7. Bao Le Nguyen, Nguyen Duc Man, Minh Nguyen Cong and Luong Vo Van (2013). Difficulties in the Operation of an International Program in Vietnam. FICAP-1 Proceedings, BrownWalker Press, 2013, ISBN-13: 9781612337043. 8. Duc Nguyen Duc Man, Tien Vu Truong, Nguyen Bao Le (2013). Deployment of Capstone Projects in Software Engineering Education at Duy Tan University as Part of a University-wide Project-based Learning Effort. Learning and Teaching in Computing and Engineering (LaTiCE), IEEE Computer Society -CPS, 2013, E-ISBN :978-0-7695-4960-6 (pp. 184 -191). 9. Gia Nhu Nguyen, Nhat Tan Tran, Thanh Trung Nguyen and Nguyen Duc Man (2014). The Benefits of CDIO for ABET Preparation from a Hands-on Study in Vietnam. Proceedings of the 10th International CDIO Conference. Barcelona 10. Vu T Truong, Bao N Le, Man N Duc, Thang M Nguyen (2014). Accessing the Maturity of Teamwork Capabilities through CDIO Projects. Proceedings of the 10th Annual International CDIO Conference. Universitat Politècnica de Catalunya, Barcelona, Spain. 11. Phuong A Pham, Man D Nguyen, Long Q Nguyen, Thang M Nguyen, Bao N Le (2014). Learning Computer Programming In Cdio’s Team Settings. Proceedings of the 10th Annual International CDIO Conference. Universitat Politècnica de Catalunya, Barcelona, Spain. 12. Vo, Q. N., Tran, N. P., Van Dat Ngo, V. H. T., Huynh, Q. T., Ha, N. H., & Nguyen, D. M. LEVERAGE THE BLOCKCHAIN TECHNOLOGY TO MANAGE SMART CONTRACT IN ASSET TRADING. Kỷ yếu Hội nghị KHCN Quốc gia lần thứ XII về Nghiên cứu cơ bản và ứng dụng Công nghệ thông tin (FAIR); Huế, ngày 07-08/6/2019 DOI: 10.15625/vap.2019.00032 13. Ha, N. H., Nguyen, D. M., Liu, C. A., Van Van, T., Nguyen, A. D., & Huynh, Q. T. AN EMPIRICAL STUDY OF THE IMPACT OF THE MPOS SYSTEM ON THE PROCESS CHANGE OF RESTAURANTS. Kỷ yếu Hội nghị KHCN Quốc gia lần thứ XII về Nghiên cứu cơ bản và ứng dụng Công nghệ thông tin (FAIR); Huế, ngày 07-08/6/2019 DOI: 10.15625/vap.2019.00032 14. Nguyễn Thanh Hùng, Nguyễn Đức Mận, Huỳnh Quyết Thắng (2019), Thử Nghiệm Đánh Giá Áp Dụng Một Số Kỹ Thuật Kiểm Thử Để Nâng Cao Độ Tin Cậy Cho Ứng Dụng Di Động Trong Môi Trường Phát Triển Linh Hoạt. Section on Information and Communication Technology (ICT) - No. 13, Journal of Science and Technique - Le Quy Don Technical University - No. 199, ISSN 1859-0209 15. Huỳnh Quyết Thắng, Nguyễn Đức Mận, Nguyễn Thị Bảo Trang, Nguyễn Thị Anh Đào (2016). Kỹ thuật kiểm thử hồi qui hiệu quả cho phát triển ứng dụng di động. Kỷ yếu Hội nghị khoa học công nghệ quốc gia lần thứ IX, ngày 4-5/8/2016 - "Nghiên cứu cơ bản và ứng dụng Công nghệ thông tin" (FAIR 2016), trang 255-265. Nhà xuất bản Khoa học tự nhiên và Công nghệ. ISBN 978-604-913-472-2 10. Recent professional development activities: - Coordinator and Assistant Director of ACM/ICPC Asia Regional Contest, Danang, Vietnam (2013). - Participated in the 7th National Conference on Fundamental and Applied IT Research (2014). - Attended the 7 Professional Development Hours the Fundamentals of Program Assessment Workshop (2017). - Participated in the 12th National Conference on Fundamental and Applied IT Research (2019). - INISCOM 2018, INISCOM 2019, KSE 2019, CITA2021, CITA2022 - Attended the CDIO Regional Meeting - Asia-Pacific (2019).

View profile

Book chapters authored 0

Books edited 0

Introducing your Author Service Manager

Ms. Zrinka Tomicic

As an Author Service Manager, my responsibilities include monitoring and facilitating all publishing activities for authors and editors. From chapter submission and review to approval and revision, copyediting and design, until final publication, I work closely with authors and editors to ensure a simple and easy publishing process. I maintain constant and effective communication with authors, editors and reviewers, which allows for a level of personal support that enables contributors to fully commit and concentrate on the chapters they are writing, editing, or reviewing. I assist authors in the preparation of their full chapter submissions and track important deadlines and ensure they are met. I help to coordinate internal processes such as linguistic review, and monitor the technical aspects of the process. As an ASM I am also involved in the acquisition of editors. Whether that be identifying an exceptional author and proposing an editorship collaboration, or contacting researchers who would like the opportunity to work with IntechOpen, I establish and help manage author and editor acquisition and contact.

Ask a question

Book will be abstracted and indexed in