Complete SQL Bootcamp for Data Science, Analytics, Marketing

Complete SQL Bootcamp for Data Science, Analytics, Marketing, available at $54.99, has an average rating of 4.6, with 32 lectures, based on 2051 reviews, and has 13178 subscribers.

You will learn about 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 database table using SQL 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 This course is ideal for individuals who are This course is for not only marketers but anyone who wants to be able to answer data-related questions on their own or Students who want a different approach to learning SQL or Professionals who are exposed to data but can't yet leverage its power or Developers who build web-applications but don't yet know how to use a database backend or Product managers who want to make data-driven decisions It is particularly useful for This course is for not only marketers but anyone who wants to be able to answer data-related questions on their own or Students who want a different approach to learning SQL or Professionals who are exposed to data but can't yet leverage its power or Developers who build web-applications but don't yet know how to use a database backend or Product managers who want to make data-driven decisions.

Enroll now: Complete SQL Bootcamp for Data Science, Analytics, Marketing

Summary

Title: Complete SQL Bootcamp for Data Science, Analytics, Marketing

Price: $54.99

Average Rating: 4.6

Number of Lectures: 32

Number of Published Lectures: 31

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 31

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

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 database table using SQL
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

Who Should Attend

This course is for not only marketers but anyone who wants to be able to answer data-related questions on their own
Students who want a different approach to learning SQL
Professionals who are exposed to data but can't yet leverage its power
Developers who build web-applications but don't yet know how to use a database backend
Product managers who want to make data-driven decisions

Target Audiences

This course is for not only marketers but anyone who wants to be able to answer data-related questions on their own
Students who want a different approach to learning SQL
Professionals who are exposed to data but can't yet leverage its power
Developers who build web-applications but don't yet know how to use a database backend
Product managers who want to make data-driven decisions

It is becoming ever more important that companies make data-driven decisions.

With big data and data science on the rise, we have more data than we know what to do with.

One of the basic languages of data analytics is SQL, which is used for many popular databases including MySQL, Postgres, SQLite, Microsoft SQL Server, Oracle, and even big data solutions like Hive and Cassandra.

I’m going to let you in on a little secret. Most high-level marketers and product managers at big tech companies know how to manipulate data to gain important insights. No longer do you have to wait around the entire day for some software engineer to answer your questions – now you can find the answers directly, by yourself, using SQL!

In this course, The Complete SQL Bootcamp for Data Science, Analytics, and Marketing, 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.

Once you know all the SQL commands we will start doing advanced examples – answering questions marketers and business people often have, like where are customers dropping off in our sales funnel? And which of our locations has the highest revenue?

In the last section, we’ll do Advanced SQL queries on Spark, the big data framework that is the successor to MapReduce and also runs on top of Hadoop. I will teach you how to install Spark, create a cluster very quickly on Amazon EC2, and run SQL queries, allowing you to apply everything you learned up until this point in a big data environment.

Do you want to know how to optimize your sales funnel using SQL, look at the seasonal trends in your industry, and run a SQL query on Hadoop? Then join me now in my new class on SQL! Dominate data analytics, data science, and big data!

TIPS (for getting through the course):

Watch it at 2x to learn twice as fast!
Take handwritten notes. This will drastically increase your ability to retain the information.
Ask lots of questions on the discussion board. The more the better!
Write code yourself, don’t just sit there and look at my code.

Course Curriculum

Chapter 1: Why you should stop depending on engineers and learn SQL

Lecture 1: Introduction and Outline

Lecture 2: How to Succeed in this Course

Chapter 2: Survey of SQL databases and Installation of SQLite

Lecture 1: Overview of SQL databases

Lecture 2: Installing SQLite on Mac, Linux, and Windows

Lecture 3: Visual Walkthrough of Windows Installation

Chapter 3: What is a relational database? Basic commands

Lecture 1: What’s a relational database?

Lecture 2: How to load the data used in this class

Lecture 3: Basic commands

Lecture 4: Querying a table

Lecture 5: Creating a table

Lecture 6: Importing Data on Windows

Lecture 7: Modifying a table’s structure

Lecture 8: Drop Columns

Lecture 9: Suggestion Box

Chapter 4: Indexes and speed comparison

Lecture 1: Speeding things up with indexes

Lecture 2: Index Example in the Console

Chapter 5: Modifying a table's data

Lecture 1: Insert / Update / Delete

Lecture 2: What is CRUD?

Chapter 6: Joining tables

Lecture 1: Joining or Merging tables together

Lecture 2: Joins in the console

Chapter 7: Aggregating, grouping, and sorting. Real marketing queries.

Lecture 1: Count, Distinct, Sum, Min, Max, Avg

Lecture 2: Group by, Sort, Limit

Lecture 3: Funnels, YOY revenue, and Sales by Location

Chapter 8: Advanced: SQL on Spark (Optional)

Lecture 1: Spark SQL

Lecture 2: Create your own Spark cluster on Amazon EC2

Chapter 9: Further Knowledge, Practice and Exercises

Lecture 1: How to load the extra dataset (tab-separated tables)

Lecture 2: The "IN" Keyword

Lecture 3: The "BETWEEN" Keyword

Lecture 4: Interview Question-Style Exercises

Chapter 10: Appendix / FAQ

Lecture 1: How to Succeed in this Course (Long Version)

Lecture 2: BONUS

Instructors

Lazy Programmer Inc.
Artificial intelligence and machine learning engineer

Rating Distribution

1 stars: 22 votes
2 stars: 44 votes
3 stars: 192 votes
4 stars: 876 votes
5 stars: 917 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu