Black Friday Deals are here!     |        50% discount for all courses     |        Start learning just for 1$

1d 23h
user menu
avatar

MySQL Fundamentals - Level 1

4.67

(3 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
What you get
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 - how it works

No subscriptions
You pay for the individual courses. Select the programming language you want to learn and get a lifetime access for a single payment
30 days of Money-back guarantee
You have a generous 30-day return period. No questions asked.
Revisit the course at any time
You get a lifetime access to the course. You can review the material at any time.
Feedback
Shot us a message and get a response from a real person.
Learning paths
Codenga won't leave you on your own when you complete the course. You can continue your learning path with other courses.
Support
Every Codenga course has its curriculem manager that looks after the learning material and is ready to help you if you have any questions.

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.67

(3 ratings)

67%
33%
0%
0%
0%

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%
$1.00
$1.99
timer
1d 23h left
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
timer
-50% 1d 23h left
$1.00
$1.99