Complete SQL Bootcamp for Data Science, Analytics, Marketing
What you'll 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
Requirements
- You should you how to open a terminal / command line shell. All the examples will be done here.
Description
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.
Who this course is for:
- 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
Instructor
- 4.7 Instructor Rating
- 160,858 Reviews
- 550,022 Students
- 36 Courses
The Lazy Programmer is a seasoned online educator with an unwavering passion for sharing knowledge. With over 10 years of experience, he has revolutionized the field of data science and machine learning by captivating audiences worldwide through his comprehensive courses and tutorials.
Equipped with a multidisciplinary background, the Lazy Programmer holds a remarkable duo of master's degrees. His first foray into academia led him to pursue computer engineering, with a specialized focus on machine learning and pattern recognition. Undeterred by boundaries, he then ventured into the realm of statistics, exploring its applications in financial engineering.
Recognized as a trailblazer in his field, the Lazy Programmer quickly embraced the power of deep learning when it was still in its infancy. As one of the pioneers, he fearlessly embarked on instructing one of the first-ever online courses on deep learning, catapulting him to the forefront of the industry.
Beyond the realm of education, the Lazy Programmer possesses invaluable hands-on experience that has shaped his expertise. His ventures into online advertising and digital media have yielded astounding results, propelling click-through rates and conversion rates to new heights and boosting revenues by millions of dollars at the companies he's worked for. As a full-stack software engineer, he boasts intimate familiarity with an array of backend and web technologies, including Python, Ruby on Rails, C++, Scala, PHP, Javascript, SQL, big data, Spark, and Redis.
While his achievements in the field of data science and machine learning are awe-inspiring, the Lazy Programmer's intellectual curiosity extends far beyond these domains. His fervor for knowledge leads him to explore diverse fields such as drug discovery, bioinformatics, and algorithmic trading. Embracing the challenges and intricacies of these subjects, he strives to unravel their potential and contribute to their development.
With an unwavering commitment to his students and a penchant for simplifying complex concepts, the Lazy Programmer stands as an influential figure in the realm of online education. Through his courses in data science, machine learning, deep learning, and artificial intelligence, he empowers aspiring learners to navigate the intricate landscapes of these disciplines with confidence.
As an author, mentor, and innovator, the Lazy Programmer leaves an indelible mark on the world of data science, machine learning, and beyond. With his ability to demystify the most intricate concepts, he continues to shape the next generation of data scientists and inspires countless individuals to embark on their own intellectual journeys.