Name: MySQL fundamentals - Level 2
Brand: codenga
SKU: mysql_fundamentals_level_2
Price: 3.99 USD
Availability: InStock

At this stage you know MySQL basics already. Time to push forward and take another step towards developing your skills with one of the most popular database systems. Familiarity with MySQL can come in handy if you’re planning on going into developing web applications in the future.

Thanks to the practical exercises you will effortlessly master new techniques of working with databases. You can verify your newly acquired knowledge by solving dozens of tasks that we have prepared for the course. This effective way of learning will allow you to get a solid grasp on joins, data aggregation and the UNION operator, among many others. On top of that, in the course you will get to know many MySQL built-in functions and learn how to use the CASE instruction. This course will provide you with practical abilities that you will be using every step of the way in your work with MySQL.

What INNER JOIN is and how to use it
What LEFT JOIN is and how to use it
What RIGHT JOIN is and how to use it
Using the UNION operator
Data grouping
Using the HAVING clause
Using the CASE instruction
The extensive set of built-in MySQL functions

The course is jam-packed with practical examples, problems to solve and exercises. It’s truly the best way to gain the skills and practical experience that will prove useful in everyday work.

A surprisingly large amount of dynamic web applications implement databases like MySQL. This also happens to be the database system that WordPress and countless online stores are based on. That in itself constitutes a good reason to expect some questions about MySQL if you plan to interview for a back-end developer.

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

Aliases, comments

(8 exercises)

Aliases and comments can prove very useful when working with databases. Here you’re going to learn how to apply those elements in practice. Let’s get started!

Comments

Aliases

Aliases, comments - quiz

Aliases, comments - LiveCode

Ch. 2

Joins: INNER JOIN

(8 exercises)

Relational databases allow you to combine multiple tables together. Let’s get into the next stage and learn more about it.

Joins: INNER JOIN

Joins: INNER JOIN - quiz

Joins: INNER JOIN - LiveCode

Ch. 3

Joins: LEFT JOIN

(8 exercises)

Ahead of you is the LEFT JOIN and its secrets. Come on in!

Joins: LEFT JOIN

Joins: LEFT JOIN - quiz

Joins: LEFT JOIN - LiveCode

Ch. 4

Joins: RIGHT JOIN

(8 exercises)

Here comes another join - the RIGHT JOIN. Let’s go right ahead.

Joins: RIGHT JOIN

Joins: RIGHT JOIN - quiz

Joins: RIGHT JOIN - LiveCode

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 2

Why pick this course?

What you will learn with this course

Exercises, tasks, practice

Going further into MySQL? Worth it!

Codenga - an experience you will enjoy

Check the course curriculum

Have any questions?