What you'll learn:
How to write commonly used SQL queries using SELECT
Fundamentals of SQL
SQL Best Practices
Data Analysis
How to join data tables - includes both inner and outer joins
How to group data using GROUP BY
SQL operators
Aggregate Functions
Requirements
No previous technical knowledge required
Description
If you want to learn how to write SQL queries quickly then you have come to the right place.
What makes this course unique are the following features:
1. I get straight to the point - no messing around or time wasted padding out lectures.
2. Purely focused on writing SQL queries for data analysis rather than on creating and managing database tables.
3. Lots of visual diagrams to help you understand key concepts.
3. Lots of challenges where you get to write SQL queries. In addition, the solution to every challenge is provided and I walk through the solutions as well.
4. At under 4 fours in length this is a course you will actually finish! And you will get 30 SQL coding challenges which are spread throughout the course. In addition, we will go through the solution to every challenge in a practical demo lecture.
This course focuses on the fundamentals of the SQL language and I go everything step-by-step with lots of visual examples along the way. Also included in this course, are the conceptual steps of how a query gets evaluated. This provides a visual of how things are working, so that when you are confronted with your own real-life SQL challenges, you will have the skills to arrive at the best solution.
IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases or tables. Our goal in this course is purely on writing queries for database analysis using MySQL and MySQL Workbench.
Who this course is for
Students interested in learning Structured Query Language (SQL)
Aspiring Data Analysts
Job-seekers
Application Developers
Web Developers
Homepage

https://www.udemy.com/course/mysql-for-beginners-learn-sql-queries-for-data-analysis/