• EXPLAIN and ANALYZE in Postgres

    In PostgreSQL, the EXPLAIN command is used to analyze the execution plan of a query. When you run the EXPLAIN command followed by a SELECT statement, PostgreSQL will return information about how the query will be executed by the database engine, including the order in which tables will be scanned, the types of joins that will be used, the methods for retrieving data, and the estimated cost of each step.

  • Types of SQL Joins

    In SQL, a join is a way to combine data from multiple tables based on a related column between them. This allows you to query data from multiple tables in a single statement. In this article, we will explore the different types of joins in SQL.

  • Bookstore Database Schema

    In this post we will design a schema to be used in a bookstore software or an online store selling books.

  • Movie Catalog Database Schema

    Today we are going to create a database schema for a movie catalog. It could be used for a web-site like IMDB or a desktop software to catalog movies.

  • Welcome to Jekyll!

    You’ll find this post in your _posts directory. Go ahead and edit it and re-build the site to see your changes. You can rebuild the site in many different ways, but the most common way is to run jekyll serve, which launches a web server and auto-regenerates your site when a file is updated.