Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SQL for Data Analytics Using MySQL Workbench

Name: SQL for Data Analytics Using MySQL Workbench
Rating: 4.3 (84 reviews)

Learn SQL from scratch for extracting, manipulating and analysing data using MySQL database

Created byVardges Zardaryan

Last updated 10/2023

English

What you'll learn

How to use MySQL – the #1 Database Management System
How to install MySQL Workbench on Windows
How to create a database from scratch
How to write SQL queries to insert, update and delete data into database
How to write SQL queries to manipulate data
How to write complex SQL queries to obtain useful information from database
How to answer specific business questions by using SQL’s aggregate functions
How to handle complex SQL JOINS with ease
How to use sorting and filtering commands in SQL
Increase your efficiency by learning the best practices while writing SQL queries
Become a proficient MySQL Workbench user
Boost your resume by learning an in-demand skills

Course content

8 sections • 27 lectures • 2h 20m total length

Welcome to the Course2:56
Master data management and analysis with MySQL through practical SQL training, covering installation, basic to advanced queries, joins, aggregations, and data constraints.
What are SQL and MySQL?1:39
Learn sql, the standard language for relational databases, and MySQL, an open source rdbms that uses sql to access and manage data with MySQL Workbench.

Create Table and Insert Data9:16
Create a database and orders and customers tables in MySQL Workbench, define columns with appropriate data types, set primary keys, and insert sample data for analytics.
MySQL Data Types0:03
SELECT (DISTINCT) Statement7:40
Learn to use select to extract data from orders, set a default schema, and apply limit. Explore selecting specific columns and using distinct to return unique values.
WHERE Clause3:24
Use the where clause to filter data by conditions, such as state code equals California and cost of product greater than 500 dollars, in MySQL Workbench.
SQL Operators: AND, OR, NOT, IN, BETWEEN7:41
Master sql operators and, or, not, in, and between to filter orders by year or subcategory and define price ranges.
LIKE Operator4:26
Learn to use the like operator to filter data by pattern in SQL statements. Use percent and underscore wildcards to match subcategory starts, ends, or specific lengths, and verify results.
INSERT INTO and DELETE FROM Statements5:39
UPDATE SET Statement3:36
ORDER BY Statement4:02
Master the order by statement to sort query results by one or more columns in ascending or descending order, with examples sorting by customer age and cost of product.

Aggregate Functions5:53
Learn to apply aggregate functions in SQL, including min, max, count, average, and sum, with examples computing minimum and maximum product costs and total costs from orders.
MySQL Functions with Descriptions0:02
SQL Subqueries2:48
Learn how to use nested subqueries to return the full row when the cost equals the nested minimum value.
GROUP BY Statement6:06
Explore how to use the group by statement to aggregate data with functions like count and sum, producing totals such as orders by year and net profit by state.
HAVING Statement3:29
SQL JOINS (INNER, LEFT, RIGHT, FULL)7:40
Explore SQL joins by combining the students and scores tables on student I.D., using inner, left, right, and full outer joins, and understand how each returns matching or all records.
CASE Statement6:32

SQL Query - Best Practices4:08
Master best practices for SQL queries in MySQL Workbench by applying the proper keyword order (select, from, where, group by, having, order by, limit), whitespace, and selective column calls.
Comments in SQL3:08
Discover how to insert SQL comments to explain code and prevent execution, using single-line comments with -- and multi-line comments with /* and */.
Export and Import Data4:37
Export a subset of data from MySQL Workbench and import it via CSV for analysis, then create a table such as orders in november 2015 in the ABC database.
Stored Procedures14:40
Create and reuse stored procedures in MySQL Workbench to save queries, pass parameters like state and year, and quickly fetch orders or total counts with simple calls.

Requirements

No prior experience - We will start from the basics
MySQL Workbench - We will download and install it together

Description

Join to thousands of students learning SQL and gain a competitive advantage in the job market. Learn SQL from scratch for data analytics using MySQL database.

WHY WOULD YOU CHOOSE TO LEARN SQL?

SQL is the most universal and common used database language. It powers the most commonly used database engines like MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Oracle, and much more.

When you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business.

Knowing SQL can get you a promotion and make you a rock star at your company. SQL is the most sought after skill for Data Analysis roles in all the companies.

WORRIED THAT YOU HAVE NO PREVIOUS EXPERIENCE?

Not an issue. We will start from the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.

WHY TAKE THIS SPECIFIC SQL COURSE?

This course has been specially designed to make it easy for the students to learn SQL and perform data analysis on the job. In this course you'll play the role of a data analyst at a delivery company and you'll be working with real-life data sets. You will learn both technical and business thinking skills, and get important skills to get hired.

You don't need to spend months to learn SQL. As you go through the course, you'll be able to apply what you learnt immediately to your job. So whether you want to start a career as a data scientist or just grow you data analysis skills, this course will cover everything you need to know to do that.

This course will teach you how to use the SQL language in the MySQL, one of most popular database engines in the world. But these skills are also applicable to any other major SQL databases such as PostgreSQL, Microsoft SQL Server, SQLite, Oracle, Amazon Redshift, and much more.

Once we complete each and every concept in SQL, we finally have a set of practical examples, which will allow you to practice SQL queries on your own.

Author of this course has over 15 years of working experience in large financial organizations and over 5 years of experience of online and in-person trainings. He has dozens of courses on Excel, SQL, Power BI, Access, and more than 20,000 students in total. Surely, he knows what you need.

WHAT WILL YOU LEARN IN THIS COURSE?

You'll learn:

· How to use MySQL – the number one Database Management System.

· How to install MySQL Workbench on Windows.

· How to create a database from scratch.

· How to write SQL queries to insert, update and delete data into database.

· How to write SQL queries to manipulate data.

· How to write complex SQL queries to obtain useful information from the database.

· How to answer specific business questions by using SQL’s aggregate functions.

· How to handle complex SQL JOINS with ease.

· How to use sorting and filtering commands in SQL.

· Increase your efficiency by learning the best practices while writing SQL queries.

· Become a proficient MySQL Workbench user.

· Boost your resume by learning an in-demand skills.

WHAT ABOUT CERTIFICATE? DO YOU PROVIDE A CERTIFICATE?

Upon completion of the course, you will be able to download a Certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess.

So, what are you waiting for? Join today and get immediate, lifetime access to the following:

· Downloadable project files

· Practical exercises & quizzes

· 1-on-1 expert support

· Course Q&A forum

· 30-day money-back guarantee

· Digital Certificate of Completion

See you in there!

Sincerely,

Vardges Zardaryan

P.S. Looking to master the full Microsoft Excel, Power BI + SQL stack? Search for "Vardges Zardaryan" and complete the courses below to become a Data Analysis Rock Star:

1. Mastering Data Analysis in Excel

2. Mastering Data Analysis with Power BI

3. Data Analyst’s Toolbox: Excel, SQL, Power BI

4. SQL for Data Analytics Using MySQL Workbench

Who this course is for:

Anyone looking to pursue a career in data analysis, business intelligence, and market researches
Data analysts looking to continue their professional development and career advancement
Business professionals looking to improve their analytical skills and learn more tools for that
Anyone who wants to be able to answer data-related questions on their own
Students who wish to learn a new skill to develop their career

SQL for Data Analytics Using MySQL Workbench

What you'll learn

Explore related topics

Course content

Course Overview2 lectures • 5min

MySQL Installation1 lecture • 4min

Basic SQL Queries9 lectures • 46min

Intermediate Statements and Functions7 lectures • 33min

Advanced Tips and Tricks4 lectures • 27min

Practical Exercises2 lectures • 25min

Test Yourself0

Wrapping Up2 lectures • 2min

Requirements

Description

Who this course is for: