The book first exposes the readers to important features, functions and commands of SQL and then focuses on solving SQL queries in a step-by-step manner. It provides a number of SQL query examples and encourages the readers to try out various SQL queries to understand the underlying concepts. The book discusses the different real-life SQL queries related to a banking transaction system, publication management system, transport management system, employee information system, sales tracking system, teaching activity system, patient diagnostics system, and an automobile sales monitoring system, in order to acquaint the readers with more and more complex aspects of SQL.
This book Useful for computer science students.
Chapter 1 Sql—brief Overview
Chapter 2 Banking Transaction Information System
Chapter 3 Publication Management System
Chapter 4 Training Management System
Chapter 5 Transport Management System
Chapter 6 Employee Information System
Chapter 7 Sales Tracking System
Chapter 8 Teaching Activity Information System
Chapter 9 Patient Diagnostics Information System
Chapter 10 Automobile Sales Monitoring System
Appendix A: Script Of Tables Used
Appendix B: Frequently Used Sql Commands