close
Cart icon
User menu icon
User icon
Lightbulb icon
How it works?
FAQ icon
FAQ
Contact icon
Contact
Terms of service icon
Terms of service
Privacy policy icon
Privacy Policy

SQL Fundamentals - Exercises

5

(1 rating)

Test and complete your knowledge of the foundations of SQL. Solve over 140 types of tasks and see what you really know.

poster_image
dot30 days of Money-back guarantee
dotGet help at the every stage of learning
dotRegular updates
Unlimited accessUnlimited access
exercises169 exercises
Support from Codenga TeamSupport from Codenga Team
Works on mobile devicesWorks on mobile devices
Instant feedbackInstant feedback
Certificate of completionCertificate of completion
guardian photo
Support for this course is provided by:
Marek – SQL Curriculum Manager
Description
How it works
Syllabus
Reviews
FAQ

A real test of your skills

  • point

    Test and develop your SQL knowledge by solving over 140 tasks.

  • point

    Perform multiple LiveCode exercises requiring you to write complete queries.

  • point

    Verify your knowledge of SQL fundamentals in a wide range from SELECT to advanced filtering and grouping methods.

  • point

    Practice query syntax and logic for working with data.

If you have already mastered the basics of SQL, this course is a great opportunity to test and reinforce your knowledge. You will find a whole bunch of very different tasks and no theory.

description_image1

Complete coverage of the foundations of SQL

The assignments in this course will test your knowledge in the complete foundations of SQL. You will perform many exercises involving SELECT queries. You will test your ability to filter queries using WHERE. You will practice your knowledge of techniques such as grouping and summarizing. You will recall how we create tables, how we add constraints to columns, how we edit data, and the structure of tables. In addition, you will test your knowledge of key database operations..

description_image2

Challenging and diverse tasks

Assignments range from relatively simple to exercises requiring you to write complex queries from scratch. With this course you will practice both the syntax and logic of working with SQL.

Summary of an important milestone

Surely you have some important reason that made you learn SQL. Whatever your motivation, this course will give you a summary of a very important step. It will give you the confidence that you know how to solve SQL-based database problems in practice. Upon completion of the course, you will earn a certificate attesting to your skills.

description_image2

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
Basic queries with condition pt. 1
(15 exercises)
We’ll start with the basic queries with limits which can help us retrieve a portion of rows from the table.
Exercises
Practice
Ch. 2
Basic queries with condition pt. 2
(20 exercises)
We proceed with the basic queries. It’s time for another portion of tasks.
Exercises
Practice
Ch. 3
Pattern and range matching
(16 exercises)
It’s time for another chapter. We will create queries that utilize pattern matching.
Exercises
Practice
Ch. 4
Sorting and functions
(17 exercises)
Another dose of tasks will concern sorting and SQL functions.
Exercises
Practice

What people are saying about this course?

Average rating

5

(1 ratings)

100%
0%
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.
$4.99
dot30 days of Money-back guarantee
dotGet help at the every stage of learning
dotRegular updates
Unlimited accessUnlimited access
exercises169 exercises
Support from Codenga TeamSupport from Codenga Team
Works on mobile devicesWorks on mobile devices
Instant feedbackInstant feedback
Certificate of completionCertificate of completion
guardian photo
Support for this course is provided by:
Marek – SQL Curriculum Manager
$4.99