Apache Spark is one of the fastest growing technology in BigData computing world. It support multiple programming languages like Java, Scala, Python and R. Hence, many existing and new framework started to integrate Spark platform as well in their platform e.g. Hadoop, Cassandra, EMR etc. While creating Spark certification material HadoopExam technical team found that there is no proper material and book is available for the Spark SQL (version 2.x) which covers the concepts as well as use of various features and found difficulty in creating the material. Therefore, they decided to create full length book for Spark SQL and outcome of that is this book. In this book technical team try to cover both fundamental concepts of Spark SQL engine and many exercises approx. 35+ so that most of the programming features can be covered. There are approximately 35 exercises and total 15 chapters which covers the programming aspects of SparkSQL. All the exercises given in this book are written using Scala. However, concepts remain same even if you are using different programming language. Covers in detail concepts like <br> <br>- Heart of Spark SQL : Catalyst Optimizer <br>- Bringing Spark Close the bare metal : Project Tungsten <br>- Setting up Spark 2.x Environment <br>- Data set and DataFrame API <br>- Various Customizations <br>- Spark 2.0 Web UI Access <br>- Spark SQL Accelerators : Encoders <br>- Spark SQL Performance Improvements (Caching and Check pointing) <br>- Joins and RelationalGroupedDataset <br>- Spark SQL functions Standard, Windows, Statistical etc <br>- Dataset Actions and Transformation <br> <br>This book is written keeping audience who are working in following area <br>- Data Engineering <br>- Data Analytics <br>- Business Intelligence <br>- Data scientists <br>- Spark Developer <br>- Java and Python developer