This book is primarily intended for a training or educational environment in a College, University, or technical school. It has two specific goals: The first one is to train the student on Access SQL from its most basic statements to the level of a skilled professional. The second and equally important is to expose the student to the usage of SQL in the business world. That is why all the examples have a business purpose such as inventory replenishment, order reporting, shipping calculations, customer segmentation, cycle-time calculations and a myriad of other business related topics. As...

This book focuses on SQL for analytics and it is primarily intended for a training or educational environment in a College, University, or technical school. It contains SQL code that will be used by a professional data analyst or data scientist to convert data to information. Given the importance of SQL not only in operational databases but also in data warehouses, online analytical processing cubes (OLAP), data mining, reporting applications and even in Hadoop distributions with Hive, one understands that SQL is a must have tool in the belt of any data professional irrespective of data...

This book focuses on SQL for analytics and it contains SQL code that will be used by a professional data analyst or data scientist to convert data to information. Given the importance of SQL not only in operational databases but also in data warehouses, online analytical processing cubes (OLAP), data mining, reporting applications and even in Hadoop distributions with Hive, one understands that SQL is a must have tool in the belt of any data professional irrespective of data technology or operational platform. This book is not intended for database (DBAs) or system administrators (SAs) and as...