Back to Home

Zubair Idris Aweda

SQL Joins – LEFT Join, RIGHT Join, and INNER Join ExplainedSQL Joins – LEFT Join, RIGHT Join, and INNER Join Explained

sql

Brandon Southern - AnalyticsMentor.io

The Problem with SQL Sub-queries & Better OptionsWhile sub-queries are very helpful and aren’t inherently bad, they tend to be overused and many times a more optimal and preferable solutions exists in the form of a common table expressions (CTE) or a temporary (temp) table. By using a CTE or a temp table, your code become easier to read, more modular, reduces duplicated code (which reduces bugs), and can even increase performance.

sql

guide

Ritesh Gupta

Master Data Science with This Comprehensive Cheat SheetComprehensive Cheat Sheet for Data Science: Numpy, Pandas, Python, R, ML, DL, NLP, Stats, SQL, PySpark, Plotly, Seaborn, git, Excel, Tableau, and PowerBI

sql

python

excel

guide

Ajay Kulkarni

Why SQL is beating NoSQL, and what this means for the future of dataAfter years of being left for dead, SQL today is making a comeback. How come? And what effect will this have on the data community?

sql

DHH

Conceptual compression means beginners don’t need to know SQL — hallelujah!It used to be a fundamental requirement that you learned an extensive amount of SQL before you were able to start working on database-backed applications.

sql

guide

Seattle Data Guy

What Is Trino And Why Is It Great At Processing Big DataIn this article, we outline what Trino is, why people use it and some of the challenges people face when deploying it.

sql

data-engineering

Luisprooc

Top 29 SQL Query Optimization Techniques You Must Know! 🚀By the end of this article, you’ll have the tools and knowledge you need to make your database applications run faster and more efficiently than ever before.

sql

guide

Peng Jing

Presto SQL Pre-validation Rules and Optimisation TipsThe newly launched Query Pre-Validation System by Presto introduces a comprehensive approach to enhancing query efficiency and saving valuable user resources. With this groundbreaking feature in place, all queries submitted to Presto undergo meticulous validation using a set of predefined rules. If you meet the validation error, do not worry, here are the definitions and suggestions according to the each validation rule.

data-suite

sql

Atakan Korez

Advanced SQL Techniques You Should KnowStructured Query Language (SQL) is a widely used tool for managing and manipulating data in databases. Basic SQL queries can be simple and easy to learn, but mastering advanced SQL techniques can take your data analysis and management skills to the next level.

sql