Tutorial Guide to Spark SQL: Great Tool for a Big Data Engineer
Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re...
SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection
Using Structured Query Language (SQL) can seem complicated at first, but further, it will become easier and much more convenient. You only...
How to Comment MySQL Code: Best Practices
Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when...
How to Write Complex Queries in SQL
Typical queries in the SELECT * FROM table format are sometimes not enough. When the data for a...
Hash What? Understanding Hash 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...
The Cartesian Product in SQL
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...
