Installation of the PostgreSQL database is the first step to move one step ahead towards the open source world of the database. pgAdmin and PostgreSQL are both interconnected with each other by the core system of which is installed inside the machine.

the loading time of a particular analytics report was ridiculously slow for a big Enterprise customer. Since I am part of the Data platform, a flag was immediately raised and I got involved in debugging the issue.

There are a couple of different approaches with different benefits / drawbacks to choose from; let’s lay it out for the Internet Citizens! There’s a summary of pros and cons down below if you’re in a hurry.

Learn how to perform basic operations (GET/PUT/DELETE/UPDATE) on items into DynamoDB using AWS-SDK, Serverless Framework and AWS Lambda.

Learn how to use PostgreSQL in this full course. PostgreSQL is a general-purpose and object-relational database management system. It is the most advanced open-source database system widely used to build back-end systems.

MySQL Tutorial for beginners - Learn MySQL for web development

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

Naming convention is a set of rules for choosing the character sequence to be used for identifiers which denote variables, types, functions, and other entities in source code and documentation.

In an effort to make my team write better SQL, written by non-developers and code reviews, and gathered common mistakes and missed optimization opportunities in SQL.