Data Analytics: SQL for newbs, beginners and marketers

Dominate data analytics, data science, and big data.

What Will I Learn?

• Know how to answer all of their marketing-related questions using a SQL query
• Understand what a relational database is
• How to install SQL on Mac, Linux, or Windows
• How to create a table
• How to import data into a table
• How to query a table
• How to insert into, update, and delete from a table
• Speed things up using indexes
• Join tables together to merge data
• Aggregate data using count, sum, and average
• Determine where in the sales funnel customers are being lost
• Chart your year over year revenue
• Group and sort sales by location
• Use SQL on Spark
• Install Spark
• Create a Spark cluster on AWS EC2

Take this course