Skip to main content
Taught by Tech Leads

Master pipelines, cloud & AI to become an operational Data Engineer.

DataScientist.fr

SQL

SQL, the essential language whenever you need to query data. We cover queries and their building blocks — filters, joins, aggregations, subqueries, window functions — then everything that separates a query that works from a query that holds in production: indexes, execution plans, volume. Articles offer reproducible tutorials on PostgreSQL and other relational engines, plus the interview questions that come up most often, with the expected reasoning rather than only the answer. Strong SQL mastery remains one of the highest-ROI skills for a data profile.

List of articles

P
Data Scientist
Python
Big Data
SQL

Python Pandas: Reading and Writing Tabular Data - Interactive Tutorial

Discover how to master the art of manipulating, cleaning, and visualizing tabular data with the powerful pandas library in this ultimate guide, ideal for data scientists and analysts looking to get the most out of their data.

Romain DE LA SOUCHÈRE

Romain DE LA SOUCHÈRE · septembre 16, 2026 · 5 min

Image de l'article Beginner's Guide to DAX | Power BI Tutorial
Data Scientist
Big Data
SQL

Beginner's Guide to DAX | Power BI Tutorial

Discover how the DAX language can transform your data analyses with Power BI through this comprehensive beginner's guide, enriched with practical examples and advanced tips to master essential concepts and optimize your decision-making models.

Hamza GUEREHOUNE

Hamza GUEREHOUNE · septembre 22, 2025 · 15 min

Image de l'article The 4 product components of LlamaIndex: Parsing, Extraction, Knowledge Management & Agent Framework (2025 Guide)
Artificial Intelligence
LLM
Docker
Cloud
SQL

The 4 product components of LlamaIndex: Parsing, Extraction, Knowledge Management & Agent Framework (2025 Guide)

Guide 2025: Everything You Need to Know About LlamaParse, LlamaExtract, Knowledge Management, and LlamaIndex's Agent Framework. Features, Use Cases, Strengths, Limitations, and Modular Choices.

Romain DE LA SOUCHÈRE

Romain DE LA SOUCHÈRE · mai 23, 2025 · 10 min

Image de l'article Essential SQL Commands for Developers
SQL

Essential SQL Commands for Developers

Discover the essential SQL commands that every developer should master to effectively manage databases.

Romain DE LA SOUCHÈRE

Romain DE LA SOUCHÈRE · septembre 20, 2024 · 9 min

Image de l'article How to optimize your SQL queries using database indexes
Big Data
SQL

How to optimize your SQL queries using database indexes

Discover how to optimize your SQL queries and improve the performance of your databases through indexing. Learn about the different types of indexes, their creation, and their effective use through practical case studies.

Romain DE LA SOUCHÈRE

Romain DE LA SOUCHÈRE · septembre 20, 2024 · 3 min