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

1d 23h
user menu
avatar

SQL Fundamentals - Level 1

4.4

(5 ratings)

Learn how to query and manipulate data with SQL.

poster_image
dot30 days of Money-back guarantee
dotGet help at the every stage of learning
dotRegular updates
Unlimited accessUnlimited access
exercises154 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 easy way to SQL

Our world is driven by data and to understand the data you need to understand its language. This course will teach you how to use SQL to read and manipulate data. Starting from scratch you will quickly learn all fundamental concepts of SQL in a very easy and approachable way. And you will be amazed by how quickly you can progress in a short amount of time.

Simple explanations and a lot of practice

This course is full of simple, clear explanations and offers you an opportunity to do a lot of practice. During the course you will be doing a lot of tasks that require you to write a real SQL code. You will master topics like SELECT queries, WHERE clause, inserting data, updating data, using SQL functions and much more. You will be able to easily track your progress and review any part of the material at any point of time. You will also earn the certificate of completion at the end of the course.

description_image1

What you will learn with this course

You will learn everything you need to know at the beginning of your SQL journey.

  • point

    You will master basic SELECT queries.

  • point

    You will learn how to use the WHERE clause.

  • point

    You will learn how to sort the results.

  • point

    You will master SQL functions.

  • point

    You will learn how to insert, update and remove data.

  • point

    You will learn how to create SQL tables and how to use basic database commands.

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 learn SQL

In order to become data-literate you need to know how to work with data. SQL is an industry standard data management language. It is so widespread that it will allow you to work in almost any IT field: from web development to data science. Learning SQL can be the best thing you can do to advance your career. Try it for yourself!

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
SELECT Query
(11 exercises)
You will start learning SQL with the most basic query that extracts data from the database.
Queries - what is this?
SELECT - first exercises
SELECT - useful techniques
SELECT - next exercises
Conventions
First query - practice
Ch. 2
WHERE clause
(8 exercises)
Now you learn how to filter the results of the SELECT query. You will be able to select data that meet only a specific criterion.
WHERE - how it's working
WHERE - first exercises
Some useful techniques
More exercises
Ch. 3
WHERE - useful techniques
(11 exercises)
Now you will learn more about SQL. We will talk about creating even more precise queries.
Complex conditions
Conditions - a few exercises
The NOT operator
Exercises - we use the NOT operator
WHERE NOT - practice
WHERE - final exercise
Ch. 4
Pattern matching
(9 exercises)
Now you will learn an extremely useful technique that will allow you to select rows that match a specific pattern. Thanks to it you will get even more possibilities to create queries.
LIKE operator - how it works?
LIKE - exercises
What else can be done with LIKE?
LIKE - next exercises

What people are saying about this course?

Average rating

4.4

(5 ratings)

60%
20%
20%
0%
0%

Reviews:

I am satisfied with the completion of course. This is the best interactive course online for absolute SQL beginners. Summarizing the course was clear and to the point!

Wayne Jackson

Jun 25, 2021

I am satisfied with the completion of course. This is the best interactive course online for absolute SQL beginners. Summarizing the course was clear and to the point!

Wayne Jackson

Jun 25, 2021

Is this review helpful?

The course is a little short, but I don't think that's a downside. The course is fun because most of it is filling in missing blanks, which you can also take logically. Cool, really cool.

Rabia Arshad

Jun 25, 2021

The course is a little short, but I don't think that's a downside. The course is fun because most of it is filling in missing blanks, which you can also take logically. Cool, really cool.

Rabia Arshad

Jun 25, 2021

Is this review helpful?

Bite sized lessons and a bunch of varius exercises helped me to understand SQL basics. It's the first course that was so easy to understand.

Kate M

Jun 24, 2021

Bite sized lessons and a bunch of varius exercises helped me to understand SQL basics. It's the first course that was so easy to understand.

Kate M

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