Name: SQL Fundamentals - Level 2
Brand: codenga
SKU: sql_fundamentals_level_2
Price: 4.990000 USD
Availability: InStock
Rating: 4.666666666666667 (2 reviews)

This course will vastly improve your SQL skills. You will learn many useful techniques for querying and manipulating data. If you completed the SQL Level 1 course you should know what to expect - a lot of tasks and practical, hands-on exercises. You will have unlimited possibilities to review any part of the course. And you will also earn a certificate of completion at the end of the course.

From the very beginning you will be learning new, very important skills. You will master many advanced techniques like aggregating data, adding constraints or working with primary keys. Try it and see how quickly you can expand your data management skills.

You will learn everything you need to know at this stage of your road to SQL mastery.

You will learn how to group and aggregate data.
You will learn how to deal with null values.
You will master HAVING and BETWEEN clauses.
You will learn how to work with primary keys and constraints.
You will learn how to alter the structure of the table.

There are dozens of exercises in every Codenga course. You will find five types of exercises: Multiple choice, Blocks ordering, Fill in the blanks, LiveCode and TrueCode.They will test different aspects of your knowledge. You will be tasked with writing code, finding errors, choosing optimal solutions for a given problem and more.

Every chapter starts with a short presentation written in a simple, plain language. Its purpose is to introduce new concepts and techniques. Then you are tasked with the exercises. You can go back to the presentation at any time. You can also make an unlimited number of attempts when it comes to solving exercises.

It all boils down to a simple, yet very effective learning method:
1. Learn the theory
2. Practice with exercises
3. Repeat until you feel confident with your skills

If you want to succeed as a data scientist, web developer or data engineer you have only one choice - keep working on your SQL related skills. This course will help you to make the next, very important step towards data-literacy. Stick with it and keep making progress.

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

BETWEEN, IN

(12 exercises)

We will start by mastering the techniques that will allow you to precisely filter the query results. Let’s start with two useful operators: BETWEEN and IN

How does BETWEEN work?

BETWEEN - exercises

How does IN work?

IN - exercise

Let's add a negation with NOT

BETWEEN and IN - exercises

Time for practice - choosing from the range

Ch. 2

NULL - empty values

(9 exercises)

In practice, we often find empty rows in the table. Usually, for some reason, the values were not completed. Now you will learn how to deal with this situation.

NULL - what is it?

NULL - exercises

NULL - let's add a negation

NULL - another set of exercises

NULL - practice

Ch. 3

Grouping

(8 exercises)

Another important technique is grouping related data. This allows us to create various summaries.

How does grouping work?

Grouping - first exercises

Grouping - details

Grouping - more exercises

Ch. 4

Agregation

(11 exercises)

The grouping and examples from the previous chapter are just the beginning of SQL capabilities. Now we will develop this topic and we’ll try to extract various useful information from our table.

Aggregation - an introduction

Summation and groups - exercise

Let's calculate the average amount in the group

Group Average - Exercise

Let's add rounding

Aggregation - a set of exercises

What people are saying about this course?

4.67

(3 ratings)

67%

33%

Reviews:

Most helpful

The initial explanations are very good and not too long. This is more of a 'learn by example' approach which works very well. The interactive practice with multiple choice, fill in the blanks and in...Read more

Mohamed Shaheedullah

Mar 3, 2022

Mohamed Shaheedullah

Mar 3, 2022

Is this review helpful?

I found a few mistakes in the texts, but thanks to the feedback they quickly corrected them. Overall a good course!

Wayne Jackson

Jun 28, 2021

I found a few mistakes in the texts, but thanks to the feedback they quickly corrected them. Overall a good course!

Wayne Jackson

Jun 28, 2021

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

$2.50

$4.99

The lowest price in 30 days!

SQL Fundamentals - Level 2

The second step of your SQL journey

Beyond the basics

What you will learn with this course

How does it work

Why you should expand your knowledge of SQL

Codenga - an experience you will enjoy

Check the course curriculum

What people are saying about this course?

Reviews:

Have any questions?

You may also be interested in these courses

C Fundamentals - Level 1

SQL Fundamentals - Level 1

PHP Fundamentals - Level 1