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 3

4.5

(2 ratings)

Master advanced SQL techniques

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

Level up your SQL knowledge!

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.

description_image1

What you will learn with this course

  • point

    You will learn how to use primary and foreign keys.

  • point

    You will master relationships.

  • point

    You will learn how to use JOIN clauses.

  • point

    You will master CASE statements.

  • point

    You will learn how to use the UNION operator.

  • point

    You will learn how to create views.

  • point

    You will learn how to work with the LIKE operator.

description_image2

How does the course work?

You can complete the course anytime, anywhere. All you need is access to the internet. After logging in, you can set your own course schedule. Then all you have to do is consistently keep passing the theory and practice by solving the exercises.

You can learn at any rate, and you can repeat each part of the material as many times as you like. The course is available on your user account without any time limits. After passing all the material, you will receive a certificate confirming your newly acquired knowledge.

Keep developing your SQL 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.

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

Average rating

4.5

(2 ratings)

50%
50%
0%
0%
0%

Reviews:

DP

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?

AN

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?

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.
$9.99
dot30 days of Money-back guarantee
dotGet help at the every stage of learning
dotRegular updates
Unlimited accessUnlimited access
exercises110 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
$9.99