Tanmay Modhmodhtanmay.hashnode.dev·Jan 11, 2025SQL Interview Prep - Day 6In this article, we’ll walk through solving a SQL problem where we need to calculate the percentage of "immediate" orders from the first orders of all customers. The problem requires us to identify which orders are considered "immediate" based on the...SQL
Tanmay Modhmodhtanmay.hashnode.dev·Jan 11, 2025SQL Interview Prep - Day 5In this article, we will go through an SQL interview problem that requires analyzing a table of incoming transactions. The goal is to calculate the total number of transactions, total amount, and the number of approved transactions and their respecti...SQL
BladePipebladepipe.hashnode.dev·Jan 9, 2025A Top HR Service Company Replaces its System Seamlessly with BladePipeReplacing a system in an organization can happen for many reasons: the business requires a more intelligent system to boost growth, or the organization finds a cost-effective alternative. It is not always a piece of cake. One pain point is how to min...Oracle
S.S.S DHYUTHIDHARsudheendra.hashnode.dev·Jan 9, 2025Mastering SQL Joins: Unlocking the Power of Relational DataWhat Are Joins? Imagine you want to cook a delicious recipe. You step into your kitchen, which contains: Utensils Spices A fridge full of vegetables and fruits To make the recipe, you need to combine information from all these sources. Using onl...SQL
Amuthasathya Rajendiranmysqlbasics.hashnode.dev·Jan 7, 2025Changing User passwordAfter creating a user account, the next step is learning how to change the password. Changing passwords is necessary to ensure the security of the database system. There are three methods to change the password. One of these three statements can be u...MySQL BasicsMySQL
Priyansh KhodiyarforDatazipdatazip.io·Jan 7, 2025Slow MySQL Analytics? Here’s Why and How to Fix ItThis is part of blog Series “Database to Analytics Ready Data“ If you are reading this, chances are you’re battling slow queries on MySQL every time you try to run complex analytics. It can be deeply frustrating to watch a query spin indefinitely, or...Database to Analytics Ready Dataonestack
Tanmay Modhmodhtanmay.hashnode.dev·Jan 6, 2025SQL Interview Prep - Day 3The Problem Statement Write a Query to provide the date for nth occurrence of Sunday in future from the given date Example: Given date = 01-01-2022 (Saturday).Now, lets consider ‘n’ as occurrence of Sunday in the future from the given date. Here, we ...10 likesSQL
DbVisualizerthetable.hashnode.dev·Jan 6, 2025Simplifying MySQL String Operations with SUBSTRING_INDEXString manipulation is a common requirement in database management. MySQL’s SUBSTRING_INDEX function simplifies these tasks by letting you extract substrings based on specified delimiters. This article explains how to use this function with clear exa...MySQL
Amuthasathya Rajendiranmysqlbasics.hashnode.dev·Jan 5, 2025Creating and removing users on MySQLCreating users The CREATE USER command is important in MySQL for creating new user accounts that can access the database. The database administrators use this command to define which users are authorized to connect to the MySQL server and specify the...MySQL BasicsMySQL
Amuthasathya Rajendiranmysqlbasics.hashnode.dev·Jan 4, 2025Introduction to MySQLMySQL is an open-source relational database management system (RDBMS) developed by Oracle Corporation. It uses Structured Query Language (SQL) for database management. MySQL is widely used for various applications, from small websites to large-scale ...MySQL BasicsMySQL
