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

1d 22h
user menu
avatar

SQL Fundamentals - Level 2

4.5

(2 ratings)

Gain more experience with SQL. Learn new data management techniques and expand your career prospects.
poster_image
dot30 days of Money-back guarantee
dotGet help at the every stage of learning
dotRegular updates
Unlimited accessUnlimited access
exercises149 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

The second step of your SQL journey

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.

Beyond the basics

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.

description_image1

What you will learn with this course

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

  • point

    You will learn how to group and aggregate data.

  • point

    You will learn how to deal with null values.

  • point

    You will master HAVING and BETWEEN clauses.

  • point

    You will learn how to work with primary keys and constraints.

  • point

    You will learn how to alter the structure of the table.

description_image2

Learn at your own pace

We all have limited time for learning. That’s why we divided this course into short, easily digestible pieces. You can learn a new concept by spending at most 15 to 20 minutes per day. And there is nothing preventing you from learning at a faster or slower pace. You can simply learn at the tempo that is most convenient for you. You can also track your progress and review the previously learned material. And don’t forget that you will have unlimited, lifetime access to the course.

Why you should expand your knowledge of SQL

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.

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
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.
What can we summarize?
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?

Average rating

4.5

(2 ratings)

50%
50%
0%
0%
0%

Reviews:

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?

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 22h left
dot30 days of Money-back guarantee
dotGet help at the every stage of learning
dotRegular updates
Unlimited accessUnlimited access
exercises149 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 22h left
$1.00
$1.99