Name: SQL Fundamentals - Level 3
Brand: codenga
SKU: sql_fundamentals_level_3
Price: 4.990000 USD
Availability: InStock
Rating: 4.333333333333333 (2 reviews)

This course will teach you how to read and write advanced SQL queries. You will master relationships, JOIN commands, views, conditional expressions and much more.

The course provides a treasure trove of exercises that give you an opportunity for hands-on practice. You will be practicing every concept you learn through the course.

You will learn how to use primary and foreign keys.
You will master relationships.
You will learn how to use JOIN clauses.
You will master CASE statements.
You will learn how to use the UNION operator.
You will learn how to create views.
You will learn how to work with the LIKE operator.

There are dozens of exercises in every Codenga course. You will find five types of exercises: Multiple choice, Blocks ordering, Fill in the blanks, LiveCode and TrueCode.They will test different aspects of your knowledge. You will be tasked with writing code, finding errors, choosing optimal solutions for a given problem and more.

Every chapter starts with a short presentation written in a simple, plain language. Its purpose is to introduce new concepts and techniques. Then you are tasked with the exercises. You can go back to the presentation at any time. You can also make an unlimited number of attempts when it comes to solving exercises.

It all boils down to a simple, yet very effective learning method:
1. Learn the theory
2. Practice with exercises
3. Repeat until you feel confident with your skills

If you are looking to pursue a career in any data-related field you should keep your SQL skills sharp. We live in a data-driven world. Data is literally everywhere.

If you ever considered a career as DataScientis, BI Professionals or Data Analyst then SQL is a must. Keep developing your skills and pursue a successful career.

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

Primary Key and Foreign Key

(9 exercises)

You will learn the difference between a primary key and a foreign key.

Primary Key and Foreign Key

Primary Key and Foreign Key - Quiz

Primary Key and Foreign Key - Practice

Ch. 2

Relationships

(10 exercises)

In the world of databases we deal with the relationships between tables. Let’s learn about them.

Relations

Relationships - quiz

Relationships - practice

Ch. 3

Joins

(11 exercises)

In this step, we will show you how to read data from more than one table. You will learn how to combine tables.

Joins - an introduction

Joins - quiz

Joins - practice

Ch. 4

Subqueries

(8 exercises)

A subquery is a SELECT query embedded in a SELECT statement. Let’s get to work!

Subqueries - an introduction

Subqueries - quiz

Subqueries - practice

What people are saying about this course?

4.33

(3 ratings)

34%

66%

Reviews:

I am very happy with the course! I look forward to more

Dmytro Pichlavich

May 26, 2022

I am very happy with the course! I look forward to more

Dmytro Pichlavich

May 26, 2022

Is this review helpful?

Good for learning basic things in SQL.

Arkadiusz Nowak

May 26, 2022

Good for learning basic things in SQL.

Arkadiusz Nowak

May 26, 2022

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

$4.99

SQL Fundamentals - Level 3

Level up your SQL knowledge!

What you will learn with this course

How does it work

Keep developing your SQL skills

Codenga - an experience you will enjoy

Check the course curriculum

What people are saying about this course?

Reviews:

Have any questions?

You may also be interested in these courses

SQL Fundamentals - Level 1

SQL Fundamentals - Level 2

SQL Fundamentals - Exercises