SQL Practitioner's Guide: Patterns, Guidance & Tips for Oracle & SQL Server
| Author | : | |
| Rating | : | 4.89 (974 Votes) |
| Asin | : | B00R8F6GOE |
| Format Type | : | |
| Number of Pages | : | 510 Pages |
| Publish Date | : | 2017-12-15 |
| Language | : | English |
DESCRIPTION:
"Introduction to sql by examples" according to Subodh Krishna Chauhan. I like the SQL Practitioner's Guide because it provides an introduction to SQL Queries with examples and explanation. It is a good jump start for application developers to understand concepts on database design, data storage, manipulation and retrieval. The later part of the book also speaks about common issues developers may encounter like date manipulation and formatting, sql injection, ANSI standards, and XML.I wish the aut
Based on years of real-world experience with Oracle and SQL Server RDBMS, this example-rich book is a great getting started guide with tips that may be useful even to those who have some years of experience in the field. Also discusses options for modeling inheritance relationally and ways to generate primary key values.. Covers, with an emphasis on ANSI standards, the SELECT statement including joins, unions, aggregate and analytic functions, common table expressions, and hierarchical queries