Nahidnahidislam.hashnode.dev·11 hours agoDatabasesWhat is Data? Data is a collection of a distinct small unit of information. It can be used in a variety of forms like text, numbers, media, bytes, etc. it can be stored in pieces of paper or electronic memory, etc. What is Database? A database is an ...DiscussDatabases
Gokil Pgokilp.co·Jul 22, 2024SQL BeginnerDatabase A database is an organized collection of structured information or data, typically stored electronically in a computer system. Let me provide you with more details: Definition: A database consists of data that is logically organized and effi...DiscussMySQL
Aditya Gadhaveadityag7678.hashnode.dev·Jul 21, 2024Understanding SQL Commands: Types and ExamplesWhat is SQL Commands ? SQL commands are instructions. It is used to communicate with the database. It is also used to perform specific tasks, functions, and queries of data. SQL can perform various tasks like create a table, add data to tables, dro...Discuss·1 likeHTML5
Aditya Gadhaveadityag7678.hashnode.dev·Jul 20, 2024SQL Explained: Essential Guide for BeginnersWhat is SQL? SQL is a short-form of the structured query language, and it is pronounced as S-Q-L or sometimes as See-Quell. This database language is mainly designed for maintaining the data in relational database management systems. It is a speci...DiscussHTML5
Aditya Gadhaveadityag7678.hashnode.dev·Jul 19, 2024Comprehensive Guide to DatabasesWhat is Data? Data is a collection of a distinct small unit of information. It can be used in a variety of forms like text, numbers, media, bytes, etc. it can be stored in pieces of paper or electronic memory, etc. Word 'Data' is originated from ...DiscussHTML5
Muhammad Abubakarabubakarwebdev.hashnode.dev·Jul 17, 2024How Databases Organize Data on Disks: A Simplified GuideBefore going to the actual database organization part, you first need to understand some prerequisites more clearly. Disk Block: When data is stored on disk-based storage devices, it is stored as blocks of data. You can say a "disk block" is the smal...Discussinternels
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
Vishad Patelvishad.hashnode.dev·Jul 16, 2024Find Average SalaryProblem Statement: Write a query to find the average salary of the employees for each department. Save the new average salary as 'Average_salary'. Return the columns 'department_id', 'department_name', and 'Average_salary'. Return the result order...DiscussSQL Problems & Solution with Different ApproachSQL
Vishad Patelvishad.hashnode.dev·Jul 14, 2024Find employees who earn less than the average department salaryTechieBytes Solutions, a prominent technology firm specializing in software development and IT services, emphasizes innovation and fair employee compensation. As a data analyst at TechieBytes Solutions, you're tasked with identifying disparities in s...DiscussSQL Problems & Solution with Different Approachdatalemur sql
YagneshwarChinniyagneshwarchinni.hashnode.dev·Jul 10, 2024What Every Web Developer Should Know About Managing DatabasesCharacteristics of relational/non-relational data. Knowledge of NoSQL databases. Knowledge of web storage. Following are some of the best databases you must learn 🟧Relational databases: Within the tables, data is stored in rows and columns. The ...Discusswebdevelopment