Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

The Complete MySQL For Beginners

The practical guide to become a MySQL master | MySQL From Scratch (Downloadable SQL Scripts Included).
3.9
☆☆☆☆☆ 3.9/5
(196 reviews)
11,274 students
Created by
Ahmad Mohey

8.0

Classbaze Grade®

7.4

Freshness

6.9

Popularity

9.1

Material

Detailed Analysis »

The practical guide to become a MySQL master | MySQL From Scratch (Downloadable SQL Scripts Included).
Go to course »
Platform: Udemy
Price: check current price
Language: English
Next start: On Demand

Best MySQL classes:

Skillshare_logo_2020
Best MySQL classes on Skillshare »
Coursera Logo
Best MySQL classes on Coursera »
Pluralsight Logo
BestMySQL classes on PluralSight »
Udemy logo
Best MySQL classes on Udemy »
linkedin
Best MySQL classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

8.0 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

7.4 / 10
This course was last updated on 3/2020.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

6.9 / 10
We analyzed factors such as the rating (3.9/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

9.1 / 10
Video Score: 7.5 / 10
The average video length is 5 hours 26 minutes of 161 MySQL courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

3 articles.
43 resources.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

    Welcome to the Complete MySQL For Developers Course, The practical guide to become a MySQL master
This course will start with you from zero level experience in SQL databases, starting to level up as we are going through the course.
This course will guide you how to install MySQL on a local machine step by step and how to workwith MySQL Workbench (The main GUI that we will be using to work with MySQL Database engine) then you will learn how to create your own cloud databases on the most required cloud services providers in the market…AWS (Amazon Web Services) and Microsoft Azure.
You will learn what is meant by concepts like DBaaS and Amazon Relational Database Service (RDS)
After you learn the basic concepts of the MySQL and relational databases and how to install it on a machine and on the cloud, You will be ready to start interacting with the database engine, some of the topics this course will cover :
•How create a database and schema.
•How create and drop tables using both SQL script and easily with Workbench.
•Understand the famous terms DML, DDL, schemas, DBaaS and more.
•You will learn how to create users to access your database based on specific permissions you gave them.
•How to create different constraints.
•Create primary keys, foreign keys and composite keys.
•How to export and import a bulk of data in and out of your database.
•How to retrieve data from your database using select statement.
•How to filter data using where clause.
•How to use aggregate functions (Sum, Min, Max..etc).
•Learn how to use group by and having with aggregate functions.
•How to use case statement.
•Master data manipulation with the essentials statements (insert into, update and delete)
•How to use the keywords like between, in, distinct, exists and more.
•Understand how to create subqueries.
•How to design complex database relations.
•Cloning database tables easily.
You will be designing a small human resources database from scratch, and we will also work with the  Sakila database. Sakila is sample relational database ready for you to test and use it.  You will learn how to install Sakila database onto your database server and we are going to perform different SQL queries and statements on both HumanResources and Sakila.
With over 30 real world exercises to help you practice and learn more about almost each major topic in the course, I am going to solve all of the exercises with you while giving you some time to try to solve it on your own.
All the SQL scripts I will be using in this course are available for you to download anytime.
Give your CV a huge boost by mastering MySQL with the Complete MySQL for developers course,
Enroll now and start mastering MySQL.

What can you learn from this course?

✓ Install MySQL Database Engine and MySQL Workbench.
✓ Understand basics of cloud databases (DBAAS and Virtual Machines)
✓ Create SQL Server instances on Microsoft Azure.
✓ Create SQL Server instances on AWS (Amazon Web Services).
✓ Connect MySQL Workbench to your cloud databases.
✓ Create MySQL schema.
✓ Create and manage users in database.
✓ Work with Sakila database.
✓ Create tables using MySQL Workbench.
✓ Create tables using SQL script.
✓ Learn different data types available in MySQL.
✓ Learn how to apply different constraints.
✓ Create primary keys, foreign keys and composite keys.
✓ Design relational databases and create relationships between tables.
✓ Understand and general ERD (Entity Relationship Diagram).
✓ Import and Export data using MySQL Workbench.
✓ Work with select statement.
✓ Filter data using where clause.
✓ Work with and, or, not operators.
✓ Use like operator and wildcards.
✓ Enhance your data selection using (In and between)
✓ How to select distinct data only.
✓ How to work with union and intersect, except operators.
✓ Work with case statement.
✓ Enhancing your data selection with sql subqueries.
✓ Working with aggregate functions (Min, Max, Avg, Sum, Count)
✓ Group table records using group by keyword.
✓ Understand difference between where and having.
✓ Filter grouped records using having keyword.
✓ Integrating aggregate functions with group by and having keywords.
✓ Understand what is DML and DDL.
✓ Adding database new records using insert statement.
✓ Deleting database records using delete statement.
✓ Updating database records using update statement.
✓ Build complex SQL queries with confident.
✓ How to clone tables.

What you need to start the course?

• MySQL Community Edition (Free)

Who is this course is made for?

• Complete beginners, no prior experience is required.
• Anyone want to master MySQL and relational databases.
• Developers looking for a huge boost in CV.
• Anyone looking for a course to refresh and incredibly increase their SQL knowledge.

Are there coupons or discounts for The Complete MySQL For Beginners ? What is the current price?

The course costs $14.99. And currently there is a 25% discount on the original price of the course, which was $59. So you save $44 if you enroll the course now.
The average price is $16.0 of 161 MySQL courses. So this course is 6% cheaper than the average MySQL course on Udemy.

Will I be refunded if I'm not satisfied with the The Complete MySQL For Beginners course?

YES, The Complete MySQL For Beginners has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the The Complete MySQL For Beginners course, but there is a $44 discount from the original price ($59). So the current price is just $14.99.

Who will teach this course? Can I trust Ahmad Mohey?

Ahmad Mohey has created 5 courses that got 2,859 reviews which are generally positive. Ahmad Mohey has taught 36,222 students and received a 4.2 average review out of 2,859 reviews. Depending on the information available, we think that Ahmad Mohey is an instructor that you can trust.

Learn everything about

Ahmad Mohey

Software Developer & Instructor
      Hello there! My name is Ahmad Mohey I’m a senior full stack developer. I have been developing applications for the last 10 years and I hope more years of creative developing to come. I have been developing applications for oil and gas industry and the financial and human resources departments for many companies.
I love to learn about new technologies and what’s new in the world of development as it’s growing rapidly, I love to help people learn and solve their problems. I believe, we all shall share our knowledge and pass it to each others.
The path to become a developer or a programmer is never easy but it is not that hard, You just need to keep going and do not quit and always think of any skill you have now, remember that you did not master it from the first time, you had to keep trying to master it.
Far from the software world I love photography and you can check my photographs on my page on facebook or 500px website, I am passionate about learning management and emotional intelligence and I attended many courses about management, negotiations and leadership.
I love traveling a lot,I love to see new places, cities, countries, cultures and people if I were to choose one thing to continue doing the rest of my life I would choose traveling. 
One last thing and I think it might be relevant for me being a developer, is that I love computer games maybe that’s why I love programming :) . I hope one day I will make my own games.
Finally thanks for your time reading about me.
Browse all courses by on Classbaze.
Ahmad Mohey's full profile and courses »
Go to class »

8.0

Classbaze Grade®

7.4

Freshness

6.9

Popularity

9.1

Material

Detailed Analysis »

The practical guide to become a MySQL master | MySQL From Scratch (Downloadable SQL Scripts Included).
Go to course »
Platform: Udemy
Price: check current price
Language: English
Next start: On Demand

Classbaze recommendations for you

Database Design

Database Design and MySQL

Database Design, MySQL Fundamentals and more advanced programming concepts. Learn how to program banks, libraries, etc.
4.4
★★★★★ 4.4/5
62,934 students

Other courses by ​Ahmad Mohey

Go to class »