Name: SQL Fundamentals - Level 1
Brand: codenga
SKU: sql_fundamentals_level_1
Availability: InStock
Rating: 4.5556 (3 reviews)

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.

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.

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

You will master basic SELECT queries.
You will learn how to use the WHERE clause.
You will learn how to sort the results.
You will master SQL functions.
You will learn how to insert, update and remove data.
You will learn how to create SQL tables.

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.

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.

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?

4.56

(9 ratings)

67%

22%

11%

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?

Most 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?

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

👀 You are not alone: You and 11 users are watching this course.

Free

SQL Fundamentals - Level 1

The easy way to learn SQL

Simple explanations and a lot of practice

What will you learn with this course?

Learn at your own pace

Why you should learn SQL

Codenga - how it works

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 2

PHP Fundamentals - Level 1