Build your future, learn coding!     |        50% OFF courses and career paths     |        Limited Time Only

close
Cart icon
User menu icon
User icon
Lightbulb icon
How it works?
FAQ icon
FAQ
Contact icon
Contact
Terms of service icon
Terms of service
Privacy policy icon
Privacy Policy

MySQL Fundamentals - Level 1

4.75

(4 ratings)

Learn all about the database system that makes countless web applications work.

poster_image
dot30 days of Money-back guarantee
dotGet help at the every stage of learning
dotRegular updates
Unlimited accessUnlimited access
exercises154 exercises
Support from Codenga TeamSupport from Codenga Team
Works on mobile devicesWorks on mobile devices
Instant feedbackInstant feedback
Certificate of completionCertificate of completion
Support for this course is provided by:
Marek – SQL Curriculum Manager
Description
How it works
Syllabus
Reviews
FAQ

MySQL is everywhere

You'll find MySQL-based databases literally everywhere. They can run thousands of online stores, CMS systems and other data-driven applications. Mastering the fundamentals of this system is one of the best investments if you want to develop backend applications.

Straightforward theory and lots of exercises

With this course you will easily start working with MySQL databases. With easy to understand theory and numerous exercises, you'll quickly master the most important concepts. At each step you will solve practical tasks that will verify your knowledge. So as usual for Codenga - minimum theory and a lot of practice. At the end of the course you will take an exam, which will be the ultimate test of your skills and you will receive a certificate of completion.

description_image1

What you will learn with this course

With this course you will learn the most important concepts and techniques for working with MySQL databases. You will master what you need to build a solid foundation for further development.

  • point

    You will learn how to write SELECT queries with WHERE clauses

  • point

    You will learn how to use keywords AND, OR, NOT

  • point

    You will master adding data to the database

  • point

    You will learn how to work with NULL type values

  • point

    You will master updating and deleting data

  • point

    You will learn the most important MySQL functions COUNT, AVG, SUM

  • point

    You will learn how to select values from a given range

description_image2

Learn at your own pace

We know that the time you can spare for learning is limited. That is why we have prepared a system that allows you to easily adjust the pace of learning to your abilities. You can complete the course in small steps, you can go through any amount of material at once, you can also return to previously completed stages without any limitation. Let's not forget that the course is available on your account without any time limits.

Why it is worth to know MySQL

A huge number of dynamic web applications use MySQL. For example, the popular WordPress or countless online stores are based on this database system. For this reason, knowledge of MySQL is often required when applying for a job as a back-end developer. Wanna learn more about MySQL? Check out our article about the key advantages of MySQL databases.

description_image2

Codenga - an experience you will enjoy

Learn interactively
We teach with graphics, repetition and short explanations. All in the comfort of your own browser.
Enjoy the learning
We strive to make every course enjoyable. In the words of a Codenga user: "it doesn't get boring."
Learn fast
"Love the lessons and the interactive methods. Learning will be very fast compared to other study methods."
Complete every course easily
We have come up with some things that should help you to complete every course. Try them and see if they work for you.
Got stuck? There is a support!
Every Codenga course has its curriculum manager that looks after the learning material and is ready to help you if you have any questions.
30 days of Money-back guarantee
You have a generous 30-day return period. No questions asked.

Check the course curriculum

Ch. 1
Introduction - SELECT
(12 exercises)
You are about to learn about the MySQL database management system. We will show you the possibilities you have never dreamed of. Let’s begin our course!
Introduction - SELECT
SELECT - quiz
SELECT - practice
Ch. 2
WHERE
(8 exercises)
You are already familiar with SELECT clauses. Selecting columns from a table is no mean feat. In this step, you will learn how to control the rows selected from a table. The WHERE clause will come to our aid.
WHERE
WHERE - quiz
WHERE - practice
Ch. 3
AND, OR, NOT
(9 exercises)
In this step, you will learn how you can combine conditions in the WHERE clause.
AND, OR, NOT
AND, OR, NOT - quiz
AND, OR, NOT - practice
Ch. 4
ORDER BY
(9 exercises)
You should associate the ORDER BY keyword with the ability to sort data. We'll show you how to do that.
ORDER BY
ORDER BY - quiz
ORDER BY - practice

What people are saying about this course?

Average rating

4.75

(4 ratings)

75%
25%
0%
0%
0%

Reviews:

A great course to learn or refresh the basics of the MySQL database.

Іван Сабат

Nov 30, 2022

A great course to learn or refresh the basics of the MySQL database.

Іван Сабат

Nov 30, 2022

Is this review helpful?

AG

Great course!

Anna Gałek

Nov 22, 2021

Great course!

Anna Gałek

Nov 22, 2021

Is this review helpful?

Have any questions?

minusplus
How does the course work?
Every Codenga course is full of structured knowledge and practical exercises. You start with the basics and you incrementally learn new skills.
minusplus
How much time do i need to complete the course?
Buying this course you get the lifetime access. You can learn the new skills at your own pace. You can also review the material as many times as you want
minusplus
Can i still use the course having completed it?
Yes! You get unlimited, lifetime access to the course.
minusplus
Do i need any prior experience to start the course?
Codenga course are great for beginner programmers. Start with the Level 1 course if it's your fist contact with programming.
minusplus
Do i need any software to use the course?
The only thing you need is a device with an internet access. No other tools or software necessary.
-50%
$2.00
$3.99

The lowest price in 30 days!

dot30 days of Money-back guarantee
dotGet help at the every stage of learning
dotRegular updates
Unlimited accessUnlimited access
exercises154 exercises
Support from Codenga TeamSupport from Codenga Team
Works on mobile devicesWorks on mobile devices
Instant feedbackInstant feedback
Certificate of completionCertificate of completion
Support for this course is provided by:
Marek – SQL Curriculum Manager
$2.00
$3.99

The lowest price in 30 days!