All Posts

Our very personal blog posts.

We split our posts in two main categories: Embedded Systems web

SQL

2026

Views148 Tutorials

A Friendly Guide to Advanced SQL

Some advanced SQL concepts like window functions and common table expressions (CTEs).

Petar Vasilev —

June 16, 2026

SQL web english

We use cookies

This website uses cookies in order to enhance the overall user experience.

Customize

Essential cookies

There are some cookies that we have to include in order for certain web pages to function. For this reason, they do not require your consent.

mitkov_systems_cookie_consent

1 year

Used to store the user's cookie consent preferences.
mitkov_systems_session

2 hours

Used to identify the user's browsing session.
XSRF-TOKEN

2 hours

Used to secure both the user and our website against cross-site request forgery attacks.
locale

1 year

Stores user's language preference.
_GRECAPTCHA

25 weeks 5 days

Used by Google reCAPTCHA to distinguish between humans and bots.

More details

Analytics cookies

We use these for internal research on how we can improve the service we provide for all our users. These cookies assess how you interact with our website.

_ga

2 years

Main cookie used by Google Analytics, enables a service to distinguish one visitor from another.
_ga_T8J4X572LN

2 years

Used by Google Analytics to persist session state.
_gid

1 day

Used by Google Analytics to identify the user.
_gat

1 minute

Used by Google Analytics to throttle the request rate.

More details