Data Analysis - New syllabus

Kindly let me know the playlist for the below, Also, for the below we need to use spark SQL or Hive ?

Data Analysis
Use Spark SQL to interact with the metastore programmatically in your applications. Generate reports by using queries against loaded data.
• Use metastore tables as an input source or an output sink for Spark applications - use Hive Context to access Hive tables and do analytics(filter,sort, rank etc ) on these Hive table?
• Understand the fundamentals of querying datasets in Spark
• Filter data using Spark
• Write queries that calculate aggregate statistics
• Join disparate datasets using Spark
• Produce ranked or sorted data