SQL for Beginners: Learn SQL for Data Analysis using MySQL

SQL for Beginners: Learn SQL for Data Analysis using MySQL, available at $59.99, has an average rating of 4.45, with 43 lectures, based on 38 reviews, and has 117 subscribers.

You will learn about 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 This course is ideal for individuals who are Students interested in learning Structured Query Language (SQL) or Aspiring Data Analysts or Job-seekers or Application Developers or Web Developers It is particularly useful for Students interested in learning Structured Query Language (SQL) or Aspiring Data Analysts or Job-seekers or Application Developers or Web Developers.

Enroll now: SQL for Beginners: Learn SQL for Data Analysis using MySQL

Summary

Title: SQL for Beginners: Learn SQL for Data Analysis using MySQL

Price: $59.99

Average Rating: 4.45

Number of Lectures: 43

Number of Published Lectures: 43

Number of Curriculum Items: 43

Number of Published Curriculum Objects: 43

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Students interested in learning Structured Query Language (SQL)
Aspiring Data Analysts
Job-seekers
Application Developers
Web Developers

Target Audiences

Students interested in learning Structured Query Language (SQL)
Aspiring Data Analysts
Job-seekers
Application Developers
Web Developers

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the Course!

Lecture 2: Overview of Popular Relational Database Management Systems (Optional Lecture)

Chapter 2: SQL Statement Fundamentals

Lecture 1: Understanding the Foundations of SQL

Lecture 2: SELECT Statement

Lecture 3: Software Installation (Windows)

Lecture 4: MacOS Installation and set up Course Databases

Lecture 5: Overview of the Course Challenges

Lecture 6: SELECT Challenges

Lecture 7: Solutions to the SELECT Challenges

Lecture 8: SELECT DISTINCT

Lecture 9: SELECT DISTINCT Challenges

Lecture 10: Solutions to the SELECT DISTINCT Challenges

Lecture 11: Row Ordering – ORDER BY

Lecture 12: LIMIT Clause

Lecture 13: ORDER BY Challenges

Lecture 14: Solutions to the ORDER BY Challenges

Lecture 15: WHERE Clause – Three-valued Logic

Lecture 16: Replacing Nulls in Queries

Lecture 17: WHERE Clause – Comparison Operators

Lecture 18: WHERE Clause Challenges

Lecture 19: Solutions to the WHERE Clause Challenges

Lecture 20: Introduction to Collations and Pattern Matching

Lecture 21: Pattern Matching – Part 2

Lecture 22: Pattern Matching Challenges

Lecture 23: Solutions to the Pattern Matching Challenges

Lecture 24: MySQL Data Types

Chapter 3: Grouping Data

Lecture 1: Introduction to Aggregate Functions

Lecture 2: GROUP BY and Aggregate Functions

Lecture 3: HAVING Clause

Lecture 4: Logical Query Processing Order in MySQL

Lecture 5: GROUP BY Challenges

Lecture 6: Solutions to the GROUP BY Challenges

Chapter 4: Logical Operators

Lecture 1: AND Operator

Lecture 2: OR Operator

Lecture 3: Operator Precedence

Lecture 4: IN Operator

Lecture 5: Logical Operator Challenges

Lecture 6: Solutions to the Logical Operator Challenges

Chapter 5: Joins and Integrity Constraints

Lecture 1: INNER JOIN

Lecture 2: LEFT OUTER JOIN and RIGHT OUTER JOIN

Lecture 3: Integrity Constraints

Lecture 4: Join Challenges

Lecture 5: Solutions to the Join Challenges

Instructors

Daniel Tait
Database Instructor

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 2 votes
4 stars: 13 votes
5 stars: 22 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu