Name: MySQL Fundamentals - Level 1
Brand: codenga
SKU: mysql_fundamentals_level_1
Price: 3.99 USD
Availability: InStock
Rating: 4.75 (2 reviews)

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.

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.

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.

You will learn how to write SELECT queries with WHERE clauses
You will learn how to use keywords AND, OR, NOT
You will master adding data to the database
You will learn how to work with NULL type values
You will master updating and deleting data
You will learn the most important MySQL functions COUNT, AVG, SUM
You will learn how to select values from a given range

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.

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.

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?

4.75

(4 ratings)

75%

25%

Reviews:

Іван Сабат

5.0

Nov 30, 2022

Confirmed by purchase

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

Is this review helpful?

Anna Gałek

5.0

Nov 22, 2021

Confirmed by purchase

Great course!

Is this review helpful?

Have any questions?

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.

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

Can i still use the course having completed it?

Yes! You get unlimited, lifetime access to the course.

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.

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.

Support for this course is provided by:

Marek – SQL Curriculum Manager

$3.99

MySQL Fundamentals - Level 1

MySQL is everywhere

Straightforward theory and lots of exercises

What you will learn with this course

Learn at your own pace

Why it is worth to know MySQL

Codenga - an experience you will enjoy

Check the course curriculum

What people are saying about this course?

Reviews:

Have any questions?