Buff up your resume/CV and become interview-ready by learning real-world SQL in this course.
This SQL course has been taken by fine marketing and product folks at Google, Facebook, Amazon, Lyft, and Udemy.
Your Story:
Buff up your resume/CV and become interview-ready by learning real-world SQL in this course.
This SQL course has been taken by fine marketing and product folks at Google, Facebook, Amazon, Lyft, and Udemy.
Your Story:
Bill was looking to move into a more analytical role and saw SQL as a requirement in the job listings he saw. He wanted to add "SQL" as a skill to his resume/CV with a clean conscience and back it up if any questions arose in the interview. But getting there would take forever. Better to just "fake it til' you make it"... right?
Joe was working in a marketing position at a small company. He had a bunch of creative ideas but sometimes felt like he was shooting in the dark and guessing at what customers were doing. If only he had some insights about user behavior so he could be a more data-driven marketer. But data analysis is only for technical folks… right?
Our Story:
David and Pete joined Udemy with little to no technical experience. But after a lot of trial and error, headaches, and help from their friends, they got good enough to uncover unique insights for themselves, their team, and their company using SQL. They were able to discover interesting things about user behavior, create dashboards to track and measure progress on team goals, pull data for the exec team to use in investor pitch decks, and get data driven about decisions they made. They've since helped many team members buff up their data analysis skills and helped students land jobs.
What You'll Learn:
If you have no technical background, don't be afraid. We've distilled our knowledge and experience using SQL into a short course so that by the end, you'll have the raw skills to do some real data analysis for your company using SQL - a language virtually EVERY company uses. Note: this courses teaches you real-world SQL - not just the theory in abstract, but real skills you can use to get more data-driven in your current job.
How This Course is Structured:
In this course we'll be pretending we're a real business (i.e. Blockbuster) so the stuff you learn will be easy to apply to your own situation/company. No abstract/theoretical mumbo jumbo.
We'll go through queries a real business would run while also teaching you the raw skills undergirding those queries so you can adapt those skills to create custom queries for your own specific purposes
To reinforce learning, we have exercises and quizzes scattered throughout the course so you can learn by doing
We'll have a bonus section where new lectures will be added occasionally (including student-requested lectures, more advanced topics, strategies for getting unstuck, etc.)
We'll be actively involved in the discussion board answering any questions you might have. Don't be afraid to ask.
A Note About Pedagogy:
We know what it's like to buy a book, feel good about yourself, never finish it and have nothing to show for it. We don't want that to happen with this course. We want this to be a course you'll actually finish. We believe half of learning is motivation and engagement, so we've tried extra hard to make this course fun, relevant, entertaining, and punchy - no frills, no dragging things out, just the good stuff. Heck, you might even find yourself skipping a party to spend time with your new best friends (i.e. us).
FAQs:
Do I need to purchase any software to take this course? Nope. Everything we use to do data analysis with MySQL is completely free. We'll walk you through the installation and set-up of any software we'll be using.
Can I take this course with Linux? The set-up and installation lectures we've created are for Windows and Mac, and we don't currently have specific installation lectures for Linux.
Is this about MySQL? Yes - we'll be using MySQL, but what you learn can be applied to pretty much all the variants of SQL (PostgreSQL, SQL Server, etc)
If you're watching this in September 2022, you can win one of two $50 Amazon gift cards we're giving away. To be eligible to win:
1. Share your learning plan to finish this course in the Q&A section of this lecture
2. Finish the course within the next 3 weeks
We'll DM winners by the end of October.
In this lecture we will take the first step to getting started!
We will be downloading an AWESOME (and free) text editor called Sublime Text.
http://www.sublimetext.com/
This is just a short quiz to reinforce a couple of the points that we made in the last lecture.
In this lecture we go over the basic outline of a SQL query.
A SQL query is made up of three main sections and phrases. They are SELECT, FROM, WHERE
BRAINBUSTER:
We will be showing you the query and answer for that brainbuster in the next lecture. Good luck!
Here are a couple questions about the structure of a SQL query.
So in the last lecture we showed you a way to cheat and see the number of results that you were getting from a query. For example we wanted to know how many actors/actresses we had in our database so we ran a query and looked at the number of rows the result had. However, there is a faster, better and cleaner way to do that. That is to use the COUNT() function.
The count function will simply tell you how many items meet the requirements that you set forth in the query.
COUNT() and GROUP BY are very commonly used in conjunction in queries. This will allow you to break the COUNT up by another dimension. For example if we wanted to see the number of movies in each store, we would GROUP BY store_id and then COUNT(film_id).
Now let's have you practice!
BRAINBUSTER
This quiz will check your answers from the brainbusters and information from the previous lectures.
NOTE: You may have noticed that we changed the "Advanced Brainbuster" question to ask about ratings per price instead of ratings per store. The reason for this is because to get ratings per store, you'll need to learn a new concept (one we cover in a future lecture). To not overwhelm you, we changed it to ratings per price which you should be able to do with the knowledge you've attained thus far!
Buuuut, for those of you who worked hard to figure out the original question, the query would have been as follows for "ratings per store":
SELECT
i.store_id, f.rating, count(f.film_id)
FROM
film f, inventory i
WHERE
f.film_id = i.film_id
GROUP BY 1,2
;
BRAINBUSTER:
[Figure out for every film, how many actors in each in film, and how many of that movie we have in inventory]
Make sure to take this quiz before you try solving the brainbuster!
BRAINBUSTER
BRAINBUSTER
BRAINBUSTER
BRAINBUSTER
We learned how to connect tables, this lecture goes into more advanced ways to do that.
See the link below from Kissmetrics for further reading on Cohort Analyses.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.