Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

MySQL Basics to Beyond: Understanding SQL For Beginners

Name: MySQL Basics to Beyond: Understanding SQL For Beginners
Rating: 4.4 (35 reviews)

Learn MySQL with an experienced teacher to guide you. Over 130 practice exercises included! No experience necessary!

Created byJoshua Paech

Last updated 10/2020

English

What you'll learn

Get set-up with MySQL
Discover what SQL is and what it is used for
Learn and practice SQL queries
Understand how to solve real world problems with SQL
Avoid common SQL mistakes
Create and modify your own databases

Course content

10 sections • 82 lectures • 9h 49m total length

Introduction6:39
Setting up MySQL (Windows)13:16
Setting up MySQL (Mac)6:54
Intro to MySQL Workbench5:13
Installing the sample databases5:45
Install and configure the sample databases by downloading world and sakila, extracting them, and executing their schema and data SQL scripts in MySQL Workbench.

Filtering with criteria (=, or, and)9:47
EXERCISES: Filtering with criteria (=, or, and)0:58
EXERCISES: Filtering with criteria (=, or, and) SOLUTIONS6:24
Filtering with criteria (<, >, between)6:42
Explore filtering with the where clause using greater than, less than, greater than or equal to, and between, with examples on independence year and population, plus sorting by name.
EXERCISES: Filtering with criteria (<, >, between)0:51
EXERCISES: Filtering with criteria (<, >, between) SOLUTIONS5:56
Filtering with criteria (not)15:49
EXERCISES: Filtering with criteria (not)1:20
EXERCISES: Filtering with criteria (not) SOLUTIONS10:30
Filtering with criteria (in)4:21
Learn to use the in keyword to filter by multiple values, like continents in a list, and combine with other criteria such as surface area to refine SQL queries.
END OF SECTION 3 REVIEW5:43

Filtering with wildcards (LIKE with %)10:43
Use the where clause with the like operator and % wildcards to pattern-match text, combining conditions and noting case insensitivity and numeric range options.
EXERCISES: Filtering with wildcards (LIKE with %)0:37
EXERCISES: Filtering with wildcards (LIKE with %) SOLUTIONS4:21
Filtering with wildcards (LIKE with _)4:55
EXERCISES: Filtering with wildcards (LIKE with _)0:28
EXERCISES: Filtering with wildcards (LIKE with _) SOLUTIONS3:40
Matching NULL fields2:51
END OF SECTION 4 REVIEW0:49

Mathematical operations11:12
EXERCISES: Mathematical operations0:37
EXERCISES: Mathematical operations SOLUTIONS5:31
Order by with mathematical operations6:14
Aggregate functions (COUNT)7:03
EXERCISES: Aggregate functions (COUNT)0:38
EXERCISES: Aggregate functions (COUNT) SOLUTIONS3:00
Aggregate functions (AVG, SUM)9:32
Master aggregate functions in SQL by using avg and sum to compute averages and totals, format with commas and zero decimals, and use aliases, rounding, and distinct.
EXERCISES: Aggregate functions (AVG, SUM)0:58
EXERCISES: Aggregate functions (AVG, SUM) SOLUTIONS5:34
Aggregate functions (MIN, MAX)6:29
END OF SECTION 5 REVIEW1:07

Grouping data (GROUP BY)16:16
EXERCISES: Grouping data (GROUP BY)1:39
EXERCISES: Grouping data (GROUP BY) SOLUTIONS9:14
Grouping data with criteria (HAVING)8:29
Discover how the having clause filters groups after a group by using aggregate functions like count and average, with the proper order of where, group by, having, and order by.
EXERCISES: Grouping data with criteria (HAVING)1:32
EXERCISES: Grouping data with criteria (HAVING) SOLUTIONS8:35
Master grouping data by language, districts, and government forms using having, with avg, sum, and max, plus where and order by to filter and sort results.
END OF SECTION 6 REVIEW0:57
Practice end-of-section review with 11 queries on group by and having using the Australian Birds database; download questions and solutions and try before checking answers, see you in section seven.

Types of joins8:49
Inner joins22:24
EXERCISES: Inner joins2:16
EXERCISES: Inner joins SOLUTIONS16:23
Explore inner join solutions across country, language, and city tables, including official languages, counts by country, capitals starting with A, and southern european city populations.
Left and Right joins11:21
Self joins7:52
Explore self joins by pairing records in the same country table with aliases and an inner join on head of state, then remove duplicates via alphabetical name comparison.
EXERCISES: Left, right and self joins4:41
EXERCISES: Left, right and self joins SOLUTIONS14:59
Selecting from three or more tables13:03
Learn how to join three tables in sql to list each country with its capital city and official languages, using inner joins and left or outer joins.
EXERCISES: Selecting from three or more tables1:34
EXERCISES: Selecting from three or more tables SOLUTIONS3:43
END OF SECTION 7 REVIEW8:19
Master multi-table joins in sql using the sakila database, linking films, actors, and the film actor table, plus inventory and rentals, with aggregates and where clauses.

Selecting from multiple tables using subqueries24:19
EXERCISES: Selecting from multiple tables using subqueries3:23
EXERCISES: Selecting from multiple tables using subqueries SOLUTIONS12:10
Combining query results with UNION11:21
Learn how to combine two queries with union in MySQL, ensure matching column counts, alias columns, and note that duplicates are dropped by default (use union all for duplicates).
EXERCISES: Combining query results with UNION1:20
Practice the union operator by combining queries to show continents and regions in a column named areas. Add a second column area type to indicate continent or region, including duplicates.
EXERCISES: Combining query results with UNION SOLUTIONS5:15
END OF SECTION 8 REVIEW5:28

MySQL data types12:51
Primary and foreign keys11:51
Creating simple tables16:05
Create simple pet store tables in MySQL, including pets, staff, and customers with primary keys, and preview foreign keys in the upcoming sales table within the Pet Dash Store schema.
Creating tables with foreign keys7:47
EXERCISES: Creating tables2:10
EXERCISES: Creating tables SOLUTIONS6:34
Create an ice cream schema with two tables. Define stock as code varchar(10) primary key; define sales as id auto-increment with a foreign key to stock(code) and default quantity 1.
Inserting records15:28
Updating records7:49
Deleting records and tables9:01
EXERCISES: Inserting. updating and deleting1:16
EXERCISES: Inserting. updating and deleting SOLUTIONS11:09

Requirements

Just a computer. We'll download, install and set up the required software together.

Description

Do you want to learn SQL by starting at the very start?

Do you want to be able to confidently write SQL queries to analyse and make sense of data?

Do you want to get started but don't even know what software you need?

Have you tried to learn SQL but got lost along the way?

Or are you a developer who needs to add SQL to their skillset?

This course is for you.

With a student-centred approach, this course will give you the skills and confidence in SQL and MySQL that you need.

I am a qualified and experienced IT educator with over a decade of teaching experience.

I understand students, so when creating this course I focused on two things:

clear and logical explanations
plenty of opportunities for you to practice what we are learning.

You will not just be watching videos of me typing in SQL queries. After every technique is explained, you will learn by doing.

This course includes over 130 practice exercises with full solutions, fully explained.

It is also fully captioned so you can learn without needed your sound turned on.

What are other students saying about the course?

"Excellent and well prepared materials. Exercises are a MUST in my opinion and this course fulfills this criteria for me."

"Having the exercises and solutions explained is a huge help. Thank you!"

"Well explained."

"If anyone wants to learn MySQL from scratch, then you are in the right place."

"Teaching methodology with examples is just enough to understand for a person who will be starting from very scratch . You are the best."

Why learn SQL?

SQL is one of the most in-demand IT skills worldwide. SQL is necessary for web development, app development, writing applications or games, database administration, ecommerce and more. It's a great way to improve your employability, advance your career and boost your earnings potential.

Does the course cover SQL or MySQL?

MySQL is the most popular variant of SQL and it is what we will use in this course. However, the majority of everything that we learn will be directly transferrable to other SQL products such as Oracle, SQLite, Postgres or SQL Server.

Do I need to have SQL set up on my computer to take this course?

No! I will step you through downloading MySQL, MySQL Workbench and the required sample databases. It's all free and easy to use.

What if I need help?

I am highly responsive to any questions you may have along the way. In addition to this, you can join the Code Lift Off course group on Facebook to discuss what you are learning.

Let's go!

After completing this course, you will be able to confidently write SQL queries on any database as well as create databases from scratch.

You will have a solid understanding of how the different SQL commands work, and how to approach various real world problems.

Enough talk, let's go! Sign up and we'll get started!

Who this course is for:

Beginners interested in learning SQL
Students needing a better understanding of the SQL class they are taking
Developers looking to add SQL database knowledge to their skills

MySQL Basics to Beyond: Understanding SQL For Beginners

What you'll learn

Explore related topics

Course content

Getting set up5 lectures • 38min

Basic SQL5 lectures • 41min

Filtering with criteria11 lectures • 1hr 8min

Filtering with wildcards8 lectures • 28min

Mathematical and aggregate operations12 lectures • 58min

Grouping7 lectures • 47min

Selecting from more than one table (Joins)12 lectures • 1hr 55min

Combining queries with subqueries and union7 lectures • 1hr 3min

Creating, updating and deleting data11 lectures • 1hr 42min

EXTRA topics4 lectures • 28min

Requirements

Description

Who this course is for: