Author: Philipp Zhenov

Philipp expertly writes articles on technical topics. He has an extensive experience with both large companies and small businesses in the field of IT, engineering and mechanical engineering.

Tutorial Guide to Spark SQL: Great Tool for a Big Data Engineer

Frameworks, Languages & Coding

Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re...
Read More

SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection

Database development, Statements

Using Structured Query Language (SQL) can seem complicated at first, but further, it will become easier and much more convenient. You only...
Read More

How to Comment MySQL Code: Best Practices

Database development, MySQL, Statements

Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when...
Read More

How to Write Complex Queries in SQL

Database development, Statements

Typical queries in the SELECT * FROM table format are sometimes not enough. When the data for a...
Read More

Hash What? Understanding Hash Indexes

Database development, Indexes

Hash indexes are an integral part of databases. If you’ve ever used a database, chances are that you have seen them in action without...
Read More

The Cartesian Product in SQL

Database development, Tables

Cartesian product in SQL is a term from the set theory of mathematics. However, we can also find this term in SQL database manuals. What...
Read More