Shalon N. Ngiginjeri-ngigi.hashnode.dev路Feb 4, 2025The Basics of Relational DatabasesTypes of databases Relational databases (SQL) - data is stored in structured tables with columns and rows defined by schemas. Examples: PostgreSQL, MySQL, SQLite Why pick a relational database: If you have structured data with strong relationships...1 likeSoftware Engineering FundamentalsDatabases
Vivek Bhandarivivekbhandari.hashnode.dev路Jul 2, 2024Understanding the Mongoose Aggregation PipelineAggregation pipelines in MongoDB, particularly when using Mongoose, provide a powerful and flexible way to process and transform data. Each stage in the pipeline operates on the data, passing the transformed data to the next stage. This allows for co...MongoDB
OBULIPURUSOTHAMAN Kobulipurusothaman.hashnode.dev路Apr 17, 2024Structured Query Language(sql)STRUCTURED QUERY LANGUAGE(SQL) Table of Contents 1 Introduction to SQL 1.1 Data Definition Language (DDL) 1.2 Data Manipulation Language (DML) 2 Introduction to SQL Server 2.1 SQL Server Management Studio 2.1.1 Create a new Database 2.1.2 Queries 3 ...41 likes路44 readsSQL
Asfia Aimanasfiaaiman.hashnode.dev路Feb 29, 2024Maximizing Laravel Query Execution Efficiency: Unleashing Speed and PrecisionIntroduction In the dynamic realm of web development, speed is paramount. A rapid Laravel website not only captivates users but also propels you ahead of the competition. This guide serves as your compass for optimizing Laravel queries, ensuring your...laravel queries
Ukagha Promisebackendbro.hashnode.dev路Jun 9, 2023Introduction to Databases - SQLIntroduction We shall learn about databases and SQL in this article. This article provides readers with a fundamental overview of databases and SQL. This article is the first part of the database - SQL series. Prerequisites Basic computing knowledge...131 readsdatabase
Rukayat Balogunrukayat-balogun.hashnode.dev路Aug 12, 2022Database roles and access controlDatabase roles are used to manage database access permissions. A database role is an entity that contains information that define the following: Can you login? Can you create Database? Can you write to tables ? Secondly, it defines what the client ...28 readsDatabases
Yahaya Yusufomolluabii.hashnode.dev路Jun 11, 2022How to use Prepared Statement In JDBCHello and welcome to yet another article. This article serves as a continuation and completion of part-1. If you have no knowledge of JDBC I do advise you read part-1 first then come back to learn to use prepared statement. Prepared statement general...7 likes路50 readsJava