Master SQL for job interviews and become a pro in data analysis and business intelligence. Join our fun and easy SQL Bootcamp today!
This course is your ticket to mastering SQL! Learn how to work with data, answer business questions, and use advanced techniques in big data—all while having fun!
Master SQL for Job Interview Preparation, Data Analysis, Big Data, and Business Intelligence
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.
Understand what a relational database is
How to install SQL on Mac, Linux, or Windows
How to create a table
3 Lectures
9 Lectures
2 Lectures
3 Lectures
4 Lectures
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...
Well made course. Thanks to Lazy Programmer for this great learning opportunity! Videos are easy to follow and instructor is very good at making short content, that makes you absorb everything fast.
Excellent introductory course to SQL!
Lazy Programmer is an absolutely amazing teacher. With a master of engineering degree, I've had the opportunity to learn from a lot of different professors over time. I can say with confidence that very rarely have I seen such a clear, concise, and pedagogical teacher.
Its good im learning. thank you so much
Good as a introductory course. But there are certain situations where the tutor is going fast and does not explain the concepts. Like for example, he used Count(*) before the actual Count(*) lecture.
Best place to start learning SQL practically.
This is a well-structured course on SQL with hands-on assignments to work on. The lessons were delivered in a detailed and concise way which helped me to master the course. Thank you Lazy Programmer!
Very superficial stuff. To cover 90% of the course just ask ChatGPT the following 3 questions: 1. What is a relationan database? 2. How to install SQLite? 3. What are main operations you can perform with SQL? The response will have about 500 words.
Good course for the foundation, easily build more advanced knowledge from this course.
Your email address will not be published. Required fields are marked *
Alexander V.
A good refresher course. However, it only suits for beginners. I wish it included advanced topics like CTEs, self joins, pivoting, etc. Also, Spark is covered very superficially. It should be either removed or properly explained with context, session, RDDs VS Data Frames, Transformations, etc.