Data Analysis and Databases

Dive into the world of databases, data engineering, data analysis, and more. Discover how to extract insights, build robust systems, and make data-driven decisions.


  • Restoring a Backup in SQL Server Management Studio

    Restoring a Backup in SQL Server Management Studio

    Before I write tutorials on SQL, the first step is showing…

  • Correlation and Causation When Analyzing Data

    Correlation and Causation When Analyzing Data

    In most statistics or data analysis books (at least the ones…

  • A Style Guide for SQL Development and Data Analysis

    A Style Guide for SQL Development and Data Analysis

    A lot of people without technical backgrounds are learning SQL for…

  • Measures of Central Tendency Simply Explained

    Measures of Central Tendency Simply Explained

    When we are trying to get insights from the data, one…

  • Review of the Google Data Analytics Professional Certificate

    Review of the Google Data Analytics Professional Certificate

    This is a great certificate on all levels. I really like…

  • Beware of Misleading Graphs

    Beware of Misleading Graphs

    With little knowledge of statistics or data visualization people would notice…

  • Where to Start in Data Science, Data Analysis, and Business Intelligence

    Where to Start in Data Science, Data Analysis, and Business Intelligence

    Believe it or not, a lot of data analysis can be…

  • What Is the Difference Between Database, Database Management System, and Database System?

    What Is the Difference Between Database, Database Management System, and Database System?

    The importance of the distinction depends on the context. For example,…