The 2016 Hitchhikers Reference Guide to SQL
The 2016 Hitchhikers Reference Guide to SQL by Marcus Vannini
English | Feb. 4, 2016 | ASIN: B01BI8KANO | 53 Pages | AZW3/MOBI/EPUB/PDF (conv) | 1.39 MB
English | Feb. 4, 2016 | ASIN: B01BI8KANO | 53 Pages | AZW3/MOBI/EPUB/PDF (conv) | 1.39 MB
SQL is a universal programming language for interaction with databases. All statements here are designed to comply with SQL-89 and SQL-92, the 2 most common standards. Not all databases entirely comply with all standards, so be prepared to check for differences in the reference material for the DB you are using. This book provides a quick reference to common statements needed in database administration.
All control words (SQL specific) are capitalized for your reference. In general, SQL is not case sensitive for the control words (SELECT, DROP, UPDATE, etc.) and many DBs are not case sensitive for the table and field names, but your results may vary. A good convention is to upper case all control words, and match the case of all field names and table names, etc.
This book is designed as a reference book for people who already have a basic understanding of SQL, not complete beginners.