Introduction

Course structure

Community

In this short module, we'll take a look at how this course's platform works and learn how to get the most out of it. And also get information about our community.

Databases and DBMS

Relational databases

Key-value databases

Document-oriented databases

Database types

Structure of relational databases

Introduction to SQL

This module is designed to give you a basic understanding of databases and fill in potential gaps. Also in this module, we will get acquainted with the terminology of relational DBMS.

Fundamentals

Literals

Function usage

Duplicate elimination, DISTINCT

Basic SQL Query Syntax

Operators IS NULL, BETWEEN, IN

Operator LIKE

Conditional WHERE operator

Sorting, ORDER BY operator

Aggregate functions

Operator HAVING

Grouping, GROUP BY operator

In this module we will learn how to write our first SQL queries, deal with such important concepts as conditional selection, sorting and data grouping.

Basis of selection I

INNER JOIN

OUTER JOIN

Multi-table queries, JOIN operator

Selection limit, operator LIMIT

Subqueries with one row with one column

Subqueries with multiple rows and one column

Multi-column subqueries

Correlated Subqueries

Subqueries

Common Table Expressions, WITH

Combining queries, operator UNION

Conditional function IF

Conditional logic, CASE statement

We continue to write increasingly complex select queries: we learn how to get data from several tables, write subqueries, and get acquainted with a common table expression.

Basis of selection II

Adding data, INSERT operator

Updating data, UPDATE operator

Deleteing data, DELETE operator

In the previous modules, we learned how to write select-only queries, it's time to fool around more seriously: we get acquainted with adding, updating, and deleting records.

Data manipulation

Numeric data type

Date and time

Working with data types

Type conversion functions

Partitions in window functions

Sorting within a window

Window frames in window functions

Types of window functions

Window functions

Let's start learning more advanced SQL topics and delve into the ones we've already covered.

Advanced SQL

Creating and deleting databases

Creating and deleting tables

String data type

Data types for table columns

VIEW Statements

SQL Indexes

It's time to work not only with ready-made databases, but also learn how to create your own.

Databases and tables