Get job ready skill with Career Paths     |       Start learning for free!

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 - Level 1

4.56

(9 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
👀 You are not alone: You and 11 users are watching this course.
Description
What you get
Syllabus
Reviews
FAQ

The easy way to learn SQL

Our world is driven by data. And to understand the data you need to speak its language. This course will teach you how to use SQL to read and manipulate data. You will quickly learn all fundamental concepts of SQL in a very approachable way.

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. You will be doing tasks that require you to write a lot of SQL code.

You will master topics like SELECT queries, WHERE clauses, inserting data, updating data, using SQL functions, and more. You will be able to easily track your progress and review any part of the material at any moment. You will also earn the certificate of completion at the end of the course.

description_image1

What will you 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.

description_image2

Learn at your own pace

We are always busy with our daily chores. That is why we created a system that will allow you to learn at your own pace. Just 15 minutes a day will advance your skills in the right direction. Have more/less time to spend? No problem - you can progress throughout the course as quickly or as slowly as you want. You can also review the previously learned material at any moment.

Our system will track your progress - so you will always know what topics need some more work. And remember that you have lifetime access to your course.

Why you should learn SQL

Our world is driven by data. That's why data related skills are so in demand. SQL is the most common 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.

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.56

(9 ratings)

67%
22%
11%
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.
Free
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
👀 You are not alone: You and 11 users are watching this course.
Free