English | March 5, 2018 | ASIN: B07B8JB244 | 102 Pages | PDF | 2 MB
SQL is the language of data, and therefore the intermediary language for those who straddle the line between technology and business. Every business application needs a database and SQL is the key to working with these databases. Nick Harrison's SQL Queries Succinctly will show you how to craft queries in SQL, from basic CRUD statements and slicing and dicing the data, to applying filters and using aggregate functions to summarize the data. You will look at solving common problems, navigating hierarchical data, and exploring the data dictionary.
SQL is the language of data. Data is the language of business because every business runs off data. We can say that SQL is the language of business, or at least it is the intermediary language for those of us who straddle the line between technology and business.
It's hard to imagine a business application without a database. Whether you are dealing with Online Transaction Processing (OLTP), Online Analytical Processing (OLAP), or ad hoc queries, SQL is the key to getting data into and out of the database. To the uninitiated or even the casual user, SQL can seem like magic. SQL is a fourth-generation language (4GL). This means that, unlike most programming languages, we don't tell the database how to do what needs to be done. We describe what needs to be done and leave the database to decide how best to do what we requested.