Name: SQL Fundamentals - Level 1
Brand: codenga
SKU: sql_fundamentals_level_1
Price: 1.990000 USD
Availability: InStock
Rating: 4.4000 (3 reviews)

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.

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.

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 and how to use basic database commands.

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.

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!

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

(5 ratings)

60%

20%

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

SQL Fundamentals - Level 1

The easy way to SQL

Simple explanations and a lot of practice

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