Stefano Meloccaro – Medium

Stefano Meloccaro

Stefano Meloccaro

Ace Your SQL Interview: Top 9 Must-Know Questions and Answers

SQL interview questions, especially if done during a live session, can be challenging; however, knowing in advanced which are the most…

Jul 8

Ace Your SQL Interview: Top 9 Must-Know Questions and Answers

Jul 8

Stefano Meloccaro

Data Warehouse Schemas Explained: Star, Snowflake, Galaxy

In the world of SQL and data warehousing, organizing and structuring data for efficient querying and reporting is paramount. Three of the…

Jul 4

Data Warehouse Schemas Explained: Star, Snowflake, Galaxy

Jul 4

Stefano Meloccaro

OLTP vs OLAP: An Introduction to Database Systems

A relational database is a system for storing and managing data organized into tables. Within this framework, there are two primary types…

Jun 26

OLTP vs OLAP: An Introduction to Database Systems

Jun 26

Stefano Meloccaro

PowerBI Dashboard Design: 5 Tips to Improve the UX

Creating a Power BI dashboard involves more than just compiling accurate data; it requires thoughtful design that enhances the user…

Jun 6

PowerBI Dashboard Design: 5 Tips to Improve the UX

Jun 6

Stefano Meloccaro

Introduction to a relational database (SQL)

A relational database is a collection of data elements with predefined relations between them. These elements are represented in the…

Jul 31, 2020

Introduction to a relational database (SQL)

Jul 31, 2020

Stefano Meloccaro

SQL’s components — DDL, DML, DCL and TCL

Although the vendors of relational database management system have their own implemented version of the SQL language, exist anyway an…

Jul 16, 2020

SQL’s components — DDL, DML, DCL and TCL

Jul 16, 2020

Stefano Meloccaro

Stefano Meloccaro

Ex-Amazon BI Engineer. Writing about data analytics, tech trends, and business intelligence. Follow for insights and industry advice. 🚀

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams