Sql Popcorn English 2009

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.