In this course, SQL for marketers, we’ll start from the basics – installing SQL onto your Mac, Linux, or Windows machine and explaining what a relational database is. Next, we’ll look at basic tasks like creating tables and loading data into those tables. We will look at a wide variety of SQL commands and I will show you how to speed things up using indexes.
By end of this course you will learn about Advanced SQL queries on Spark, the big data framework that is the successor to MapReduce and also runs on top of Hadoop.
Participant will learn to:
Introduction to SQL
Relational database & Basic Commands
Indexes and Speed Comparison
Modifying a table's data
Joining Tables
Aggregating, grouping & sorting; the real marketing queries
Advanced SQL on Spark
Practice, & Exercises