This book presents the basics of SQL and teaches how to use it to create, modify and maintain a database in practical situations.
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.
KEY FEATURES
• More than 150 well-balanced solved problems to help students learn query-solving techniques.
• A number of real-life examples to show relevant application of the procedures discussed.
• Self-test exercises including objective type questions at the end of each chapter for reinforcement of concepts through practice.
The book is useful for the students of BSc/MSc (Computer Science), BCA/MCA, BBA/MBA and BE/BTech (Computer Science and Engineering, and Information Technology) for their courses in database management systems.
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.
KEY FEATURES
• More than 150 well-balanced solved problems to help students learn query-solving techniques.
• A number of real-life examples to show relevant application of the procedures discussed.
• Self-test exercises including objective type questions at the end of each chapter for reinforcement of concepts through practice.
The book is useful for the students of BSc/MSc (Computer Science), BCA/MCA, BBA/MBA and BE/BTech (Computer Science and Engineering, and Information Technology) for their courses in database management systems.
