Interested in learning SQL? Not sure where to start? You've come to the right place! We are both analysts using SQL on a regular basis to extract and organize business-critical information. In this course, we'll cover what we consider to be core SQL knowledge to operate in a day-to-day business environment. After this course, you'll be able to extract and organize data (think joins, ordering, filtering) to gain meaningful insights, setting you up to become your company's in-house SQL wizard.
In this course, we will teach you the following:
*This course is an excellent resource for beginners to hit the ground running. Intermediate to advanced users should check other Udemy options, or return back when we release a more advanced option
Here we're going to go over the components of SQL queries.
In this lecture, we go over a basic query.
This lecture goes over a basic query with multiple selected items.
Basic query using an aggregate function.
Basic query using ORDER BY
Basic query using WHERE and HAVING clauses.
Basic query using join.
Query using join, a little more complicated than Example 6.
Second part of a query using join that is a little more complicated than Example 6.
Query using string operand LIKE.
Business example, uses Google Sheets to create bar chart.
Business example using functions not previously mentioned to format end result.
Further resources and my contact information!
Hi! My name is Erik. I currently work as an analyst at Google. I have a strong interest in data visualization and analysis, so the content I publish here will be more or less related to that.
Feel free to reach out via email with any questions, hope you find the courses useful!
I'm a 2014 graduate of the University of Michigan, with my BS in Industrial and Operations Engineering. Upon graduation, I spent about 8 months at The Dow Chemical Company where I optimized chemical production on reactor assets. I am Pebble Tech as a Product Analyst. I also have created & manage a data-centric blog in efforts to learn some new tools for analysis and further refine my skills.