ISBN 9788120339224,Sql Popcorn

Sql Popcorn





PHI learning Pvt Ltd

Publication Year 2009

ISBN 9788120339224

ISBN-10 8120339223


Number of Pages 228 Pages
Language (English)

Computer programming

SQL (Structured Query Language) is a widely used database computer language designed for data retrieval and administration, report generation, database object creation and manipulation, and database access control management. Whether it is Oracle, Sybase, MS Access or DB2, this database language is used in all relational database management systems. 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.