IImt Collegeiimgroupofcolleges.hashnode.dev·an hour agoIntroduction to Data StructuresIntroduction to Data Structures In computer science, data structures are a fundamental concept that refers to the way data is organized, stored, and manipulated within a computer system. They allow for efficient data access and modification, enabling...Discussdata structures
ParasforEssential Tech Guidetech-essentials.hashnode.dev·an hour agoKey Components of Data Science Every Professional Should Master by 2025Data science is more than just a trending field; it is the cornerstone of innovation, problem-solving, and decision-making in the modern world. As we approach 2025, the demand for skilled data science professionals grows across industries. But what d...DiscussData Science
esProc Desktopesproc-desktop.hashnode.dev·7 hours ago#101 - Deduplication of Row-Based Data - by Whole RowProblem description & analysis: There is a data table: Task: Find out the whole-row data that are not duplicate and the first duplicate whole-row data. Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group(ID,Name,Gender,Birthday...Discuss·10 likesexcel
DolphinDBdolphindb.hashnode.dev·8 hours agoQuick Guide to a Unified Batch-Stream Computing Platform1. Overview This tutorial describes how to build a DolphinDB-based computing platform that supports both batch and stream processing with high extensibility and compatibility. The platform allows for the calculation of minute-level factors from high-...DiscussDatabases
Gabriela CaldasforByte-sized Journeybyte-sizedjourneys.hashnode.dev·10 hours agoDesigning Data Pipelines for Success: Best Practices for Scalability and Data QualityIn today’s world, businesses need accurate and readily available insights to stay competitive. Data engineering plays a crucial role in creating the infrastructure that makes this possible. From building efficient data pipelines to ensuring data qual...Discussdata-engineering
Shreyansh Guptashreyanshgupta.hashnode.dev·20 hours agoData types in MySQLIn this article, we are going to take a look at the different data types in MySQL databases. First of all let's take a look at our goals while designing schema. We want our schema to be - Small - e.g. don't use a BIGINT when a TINYINT would do. Sim...DiscussMySQL
Allan WANJIKUblog.allanwanjiku.tech·a day agoUnderstanding MySQL Triggers: Syntax and Usage ExamplesA trigger is a predefined program that executes automatically when an INSERT, UPDATE, or DELETE operation happens in a specified table. For example, you can create a MySQL trigger that executes automatically when a row is deleted. There are several t...DiscussMySQL
Gourav KumarforKeploy Tech Blogkeploy-blog.hashnode.dev·Nov 20, 2024Docker Containers: Enabling SSL for Secure DatabasesWhy Enable SSL for Databases? Security is critical for any application, especially when dealing with sensitive data like financial records or user information. Databases such as MongoDB and PostgreSQL communicate over the network, making them vulnera...DiscussDocker
esProc Desktopesproc-desktop.hashnode.dev·Nov 20, 2024#100 — Deduplication of Row-Based Data — by Key ColumnProblem description & analysis: There is a data table: Task: Find out the data that are not duplicates and the first duplicate data in the Name column. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).group(Name).(~(1))",A1:D7) The ...Discuss·10 likesexcel
Emma GenesenforSQLite Cloudsqlitecloud.hashnode.dev·Nov 19, 2024Release Notes: Introducing Database Studio in SQLite CloudFollow along with updates and improvements made to SQLite Cloud on LinkedIn and Hashnode. Welcome to our monthly release notes! In this edition, we’re bringing you some major updates to the SQLite Cloud dashboard. Database Studio We’re excited to ann...DiscussSQLite
