MySQL for Beginners: Learn SQL Queries for Data Analysis

Learn how to Write Queries for Data Analysis and Data Analytics using SQL in MySQL Database: Includes lots of Exercises

If you want to learn how to write SQL queries quickly then you have come to the right place.

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.

Course Content

  • Introduction –> 1 lecture • 2min.
  • SQL Statement Fundamentals –> 23 lectures • 1hr 53min.
  • Grouping Data –> 6 lectures • 39min.
  • Logical Operators –> 6 lectures • 21min.
  • Joins and Integrity Constraints –> 6 lectures • 33min.

MySQL for Beginners: Learn SQL Queries for Data Analysis

Requirements

  • No previous technical knowledge required.

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.