We will see multiple SQL features to select data, filtering data, aggregating data, and set operations

What you will learn

Selecting data from mulitiple tables

Filter data with different techniques

Aggregate data and use the built-in functions

Use set operations

Description

This course will teach you many SQL options to select, filter, and aggregate data. We also see some set operation features.

This course is designed for people who have basic database knowledge and some experience working with some kind of relational database tool. It can be on SQL Server, MySQL, PostgreSQL or Oracle. I strongly believe in short and simple courses that can get you ready in few hours as opposed to days and that’s why I made sure this course to be less or equal to 2hrs.

We will not cover basic database operations like insert, update, delete and select data.

This course requires:

  • Basic computer skill
  • Basic understanding of database concepts

Who this course is for:


Get Instant Notification of New Courses on our Telegram channel.


  • Developers who want to advance their SQL skill
  • IT Student who wants to have practical experience
  • People who are changing career to database development/administration

Who is teaching this course:

My name is Bereket Wolde and I started working database development for more than 15 years. I am also a certified SQLΒ Server developer.

However, if you ever get stuck or need something that I don’t cover in this course then feel free to reach out to me or add a comment on the course we will reach out to you at the earliest.

Join me today and I’ll see you inside!

English
language

Content

Introduction

Introduction
Setup database
Practice what you learned in this section

Selecting data from multiple tables

Section introduction
INNER JOIN
SQL Alias
RIGHT OUTER JOIN
LEFT OUTER JOIN
FULL OUTER JOIN
Sub-queries
CASE
Asking for your feedback
Practice what you learned in this section

Filtering data

Section introduction
TOP N
DISTINCT
IN and NOT IN
NULL and NOT NULL
LIKE
BETWEEN and NOT BETWEEN
Asking for your feedback
Practice what you learned in this section

Aggregating data

Section introduction
GROUP BY
COUNT
SUM
MIN and MAX
HAVING
Practice what you learned in this section

Set operations

Section introduction
UNION and UNION ALL
INTERSECT
Asking for your feedback
Practice what you learned in this section

Conclusion

Wrap up