Sql Queries For Mere Mortals

Description over the last several decades, sql has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using sql now totals in the millions. If you are accessing corporate information from the internet or from an internal network, you are probably using sql. This new edition of sql queries for mere mortals helps new users learn the foundations of sql queries, and is an essential reference guide for intermediate and advanced users. The accompanying cd contains five sample databases used for the example queries throughout the book in four different formats: microsoft sql server 2000 and later, microsoft access 2000 and later, mysql version 5.0 and later, and sql scripts that can be used with most other implementations of the language. For sale in indian subcontinent only the best book available to help new users learn the foundations of sql queries, the building block of all modern database systems one of the few books that focuses on generic sql, and not one particular vendor's version of sql updated with hundreds of new examples compliant with the latest databases, including mysql written in a clear, jargon-free, easy-to-understand style contains a foreword from keith hare, the convenor of the international sql standards committee part i: relational databases and sql what is relational? ensuring your database structure is sound a concise history of sql part ii: sql basics creating a simple query getting more than simple columns filtering your data part iii: working with multiple tables thinking in sets inner joins outer joins unions subqueries part iv: summarizing and grouping data simple totals grouping data filtering grouped data part v: modifying sets of data updating sets of data inserting sets of data deleting sets of data in closing appendices appendix a: sql standard diagrams appendix b: schema for the sample databases appendix c: dat