Vishad Patelvishad.hashnode.dev·Jul 23, 2024Mastering SQL Window Functions: A Beginner's GuideIntroduction SQL window functions are powerful tools for performing complex calculations across a set of table rows that are related to the current row. Unlike regular aggregate functions, which collapse rows into a single output, window functions ma...DiscussSQL Problems & Solution with Different ApproachWINDOW-FUNCTION
Aditya wakaleadityawakale.hashnode.dev·Jul 22, 2024How to Host MySQL Database for Free on TiDB Cloud (No Credit Card Required!)Hey everyone!! If you're like me and have been searching for a reliable way to host your MySQL database for free, then you know how challenging it can be to find a solution that offers good storage, multiple connections, and doesn't require a credit ...DiscussDatabase hosting
FAIZAN QURESHImyarticals.hashnode.dev·Jul 18, 2024What is SQL? A Beginner's GuideWhat is SQL? SQL stands for Structured Query Language SQL lets you access and manipulate databases SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) i...DiscussSQL Server
SANTOSH SINGHsantoshsingh.hashnode.dev·Jul 17, 2024Understanding Database Normalization: A Beginner's GuideDatabase normalization is a crucial concept in the realm of database design. It is a process that organizes data to minimize redundancy and improve data integrity. If you're new to this concept, don't worry! In this post, we’ll break down the basics ...Discuss1NF
Mritunjay Kumarcodecomponents.hashnode.dev·Jul 12, 2024SQL Server TutorialsSQL Server is a database management system developed by Microsoft for storing and retrieving data as requested by other software applications. Database: A database is a collection of related data. For example, a university database includes informati...Discuss·63 readsORDBMS
Haiman Sherhaimanshercloud.hashnode.dev·Jul 10, 2024Amazon RDS Explained: Complete Beginner's GuideAmazon Relational Database Service (RDS) is a fully managed database service designed to simplify the process of setting up, operating, and scaling relational databases in the cloud. It supports various popular database engines, including MySQL, Post...Discussrds
Aman Singhamanlearn.hashnode.dev·Jun 19, 2024Learn SQL and Databases: Basic Concepts ExplainedWhy Databases Matter ? "Databases keep everything organized and easy to find data for Everyone." Databases make sure everything is in the right place so you can find what you need fast. They help businesses keep track of customer information and tran...Discuss·1 likedata
Sridhar Ksridharblogs.hashnode.dev·Jun 17, 2024Introduction to Data and Database FundamentalsIntroduction to Data In today's digitalized world, data plays a major role as it is considered to be a company's asset. Data is information about people, places, animals, and things that is stored, retrieved, and used by computers or other digital sy...Discuss·1 likeDatabases
Brigita Private Limitedbrigita.hashnode.dev·Jun 13, 2024The Top 5 Essential Skills In MySQL To Boost Performance.MySQL is a popular and advanced open-source relational database management system (RDBMS). It handles everything from small personal projects to large enterprise applications to provide robust performance. It's an appropriate choice for web developme...Discussapp development
DIPEN PATELdoodle.hashnode.dev·May 23, 2024My One Week Journey of System DesignSup everyone! I am Dipen Patel, and I've been diving into the fascinating world of system design for the past week. Today, I want to share what I've learned throughout this one-week journey through this blog. Here a showcase the Project which was Con...Discuss·10 likes·50 readsSystem Design