Related resources for Relational
  • Types of Keys in SQL10/1/2024 6:09:16 AM. In SQL, keys play a crucial role in maintaining data integrity and defining relationships between tables. Common types include the Primary Key, which uniquely identifies records; the Foreign Key, link
  • How to Decide Between Relational Database and NoSQL Databases?9/30/2024 7:12:38 AM. Choosing between relational databases and NoSQL databases involves understanding their key differences, strengths, and weaknesses. Relational databases excel in structured data and ACID compliance, ma
  • Introduction to SQL Server & Its History9/2/2024 7:10:06 AM. Learn how to create, manage, and query databases using SQL Server, with a focus on essential concepts like database design, data storage, and SQL queries. Perfect for beginners aiming to build a stron
  • Understanding the SQL Query Execution Order7/22/2024 4:41:19 AM. SQL (Structured Query Language) is essential for interacting with relational databases, and mastering its intricacies can significantly enhance your data querying skills. One of the fundamental aspect
  • SQL Command Types6/28/2024 9:08:22 AM. SQL, or Structured Query Language, is essential for managing data in relational databases (RDBMS). It enables tasks like retrieving, updating, inserting, and deleting data. SQL commands are categorize
  • Database Options in Google Cloud Platform (GCP)6/11/2024 9:07:16 AM. GCP offers diverse database services tailored for various needs, from relational databases like Cloud SQL and AlloyDB for structured data to NoSQL options like Firestore and Cloud Bigtable for large,
  • Working With Stored Procedures Using Entity Framework: Part 15/16/2024 8:32:00 AM. Learn how to leverage Entity Framework for interacting with stored procedures in your .NET applications. This tutorial explores integrating stored procedures into your data access layer, optimizing da
  • Primary Key in SQL: Syntax, Usages, and Example5/14/2024 11:46:09 AM. A primary key in SQL uniquely identifies each record in a database table. It ensures data integrity and efficient data retrieval. Defined using the CREATE TABLE or ALTER TABLE commands, a primary key
  • Entity Framework Code First Example4/24/2024 1:24:22 PM. Explore an Entity Framework Code First example to understand database modeling in C#. This tutorial demonstrates object-relational mapping (ORM) techniques, using .NET Framework to create entity class
  • Zero To Hero In MS SQL Server - Part One4/19/2024 10:51:18 AM. This is part one of Zero To Hero Series in MS SQL Server. This is mainly focused for beginners who are into MS SQL Server and also for experienced who want to fresh up for interviews and daily technic
  • New Features Of Entity Framework Core 2.03/7/2024 8:53:53 AM. Entity Framework Core is a lightweight and extensible version of Entity Framework. It is based on an ORM (Object-Relational Mapper) which enables us to work with databases using .NET objects. This art
  • Practical Introduction to Entity Framework: Day 63/6/2024 10:40:13 AM. In this article, you will Explore Day 6 of our Practical Introduction to Entity Framework series, diving deeper into database integration. Learn essential concepts, including object-relational mapping
  • Practical Introduction To Entity Framework: Day 13/6/2024 10:29:58 AM. In this article, we will discover the fundamentals of Entity Framework in this practical introduction. Learn about ORM concepts, database operations, and CRUD operations through hands-on examples.
  • Working with SQL Lite Database in Asp.NET Core Web API 1/21/2024 1:32:23 PM. SQLite is a self-contained, serverless, and zero-configuration relational database management system (RDBMS). It is a lightweight, open-source, and embedded database engine that does not require a sep
  • API Development Using Dapper and Microsoft Asp.NET Core Web API 12/24/2023 4:38:11 PM. ASP.NET Core is a powerful framework for building web applications, and "Dapper" is a popular micro ORM (Object-Relational Mapping) that works well with ASP.NET Core for database operations.
  • Dapper vs Entity Framework Core vs ADO.NET: Which One Should You Choose?12/1/2023 6:33:12 AM. Dapper vs Entity Framework Core vs ADO.NET: Which One Should You Choose?
  • What is the difference between SQL and NoSQL?8/24/2023 10:54:21 AM. The choice between SQL and NoSQL depends on factors like the nature of the data, scalability needs, query patterns, and the specific requirements of the application you're building. SQL databases
  • Object Relational Mapping (ORM) Using NHibernate - Part 5 - A of 88/4/2023 11:39:30 AM. This is Part 5A of the article series, which concentrates on Many-to-Many Entity Association with a commonly used example but the model and code is a little different.
  • What is a Relational Database (RDBMS)8/3/2023 5:39:53 AM. Relational databases represent data in a tabular form consisting of rows and columns. In this article, we'll learn the basics of relational database management systems (RDBMS) and how data is repr
  • Object Relational Mapping (ORM) Using NHibernate - Part 7 of 88/1/2023 10:07:25 AM. In this seventh article and its client code, we will demonstrate that the classes we have put forth to incorporate the shipping functionality will allow shipment items of an order to be shipped in par
  • Object Relational Mapping (ORM) Using NHibernate - Part 8 of 88/1/2023 5:52:48 AM. In this article we clear the question from the end of the first article, How do we manage a persistent object across sessions? .
  • Object Relational Mapping (ORM) Using NHibernate - Part 6 of 87/31/2023 9:23:39 AM. We will discuss one of four ways of mapping inheritance hierarchies in Nhibernate; the way which gives maximum support for inheritance and polymorphism (the main benefit of capturing an inheritance he
  • Object Relational Mapping (ORM) Using NHibernate: Part 5 - B of 87/31/2023 6:39:06 AM. The idea here is to apply the Many-To-Many entity association in the E-Commerce scenario used, for example, throughout this article series.
  • Object Relational Mapping (ORM) Using NHibernate - Part 4 of 87/31/2023 6:00:05 AM. Here in this article the intent is to eliminate the nulls introduced in the database by correctly mapping the association between PaymentApprovedOrder and Item as optional One-To-Many.
  • Object Relational Mapping (ORM) Using NHibernate - Part 2 of 87/31/2023 5:41:13 AM. Object-Relational Mapping (ORM) is a programming technique that allows developers to interact with a relational database using object-oriented programming paradigms. It bridges the gap between the obj
  • Object Relational Mapping (ORM) Using NHibernate - Part 1 of 87/31/2023 5:28:18 AM. To establish the ideas of Object Relational Mapping Internals, Nhibernate fundamentals, Intemediate and Advanced coding concepts using NHibernate more clearly (for me and hopefully to readers).
  • What Is The Difference Between DBMS And RDBMS?7/28/2023 7:13:36 AM. DBMS (Database Management System) and RDBMS (Relational Database Management System) are both software systems used to manage and organize databases. The main difference between the two lies in the way
  • Object Relational Mapping (ORM) Using NHibernate - Part 3 of 87/28/2023 7:00:28 AM. Firstly in part 1 of this article series, it had been shown that in ORM, while mapping a one-to-one association between objects to their corresponding tables, the primary key of one table is posted as
  • What Is The Difference Between Relational And Non-Relational Database7/27/2023 10:15:20 AM. Relational databases and non-relational databases, also known as NoSQL databases, represent two fundamentally different approaches to storing and organizing data. Understanding the key differences bet
  • Supercharge Your Database: How Pivot in SQL Can Help You 7/25/2023 8:22:45 AM. Are you looking to supercharge your database? Learn how you can use Pivot in SQL Server to take your database to the next level. Pivot can help you optimize your database performance, improve data an
  • Introduction on SQL+6/2/2023 11:06:06 AM. In this article, we will delve into the world of SQL+ and explore its capabilities, advantages, and real-world applications. We will provide code snippets and examples to illustrate the power of SQL+
  • What are the Most Popular Relational Databases (2023)3/20/2023 12:53:14 AM. Relational database management systems are the most popular form of database management systems (DBMS) that includes Oracle, SQL Server, MySQL, and DB2. Here is a list of the most popular RDBMS in the
  • XML Data Type In SQL Server1/30/2023 7:31:44 AM. In this article, we will read about XML data type and also some advantages and limitations of XML data type over relational data types.
  • Ingest Data To Azure SQL Database Using Azure Databricks8/16/2021 2:02:09 PM. In this tutorial, We are going to discuss about how to connect to Azure SQL Database using Azure Databricks.
  • Getting Started With MongoDB For Beginners4/22/2021 2:04:51 PM. MongoDB has been developed since 2007 by MongoDB. This company was then working on a Cloud computing system, widely distributed data computing, similar to the service Google's Google App Engine. I
  • Connecting the MVC Application Using EntityFramework DB-First Approach: Part 32/10/2021 9:37:51 AM. The article is an attempt to overcome the confusion related to how to use EntityFramework with MVC application in a very simple way.
  • Getting Started With Entity Framework2/5/2021 6:31:38 AM. In this article you will learn about Entity Framework. Entity Framework is an ORM tool. ORM stands for Object Relational Mapper, as the name specifies it maps our business models with db types.
  • Operators In R11/28/2020 12:12:41 PM. In this article, we will learn about the various operators provided by the R language.
  • View Relational Data in a DataGrid10/30/2020 12:38:08 AM. This article explains you how easy is reading a database and displaying in a grid using DataSet.
  • Write Relational Data to an XML File10/29/2020 2:38:19 AM. This article shows you how you can write data from a database to an XML file using DataSet.
  • Mapping Objects to Relational Databases10/28/2020 2:45:52 AM. The application generates C# Class files for each table in a relational database. I have used Mysql and ODBC.NET for this project. The application only supports MySQL right now.
  • Views In Snowflake5/18/2020 10:56:16 AM. In this article you will learn about Views in Snowflake.
  • Entity Framework Core And Its Data Modelling Approaches3/19/2020 9:16:53 AM. In this article, you will learn about Entity Framework Core and its Data Modelling Approaches.
  • Intro To Pattern Matching - Covers C# 92/24/2020 2:44:43 AM. In this article you will learn about Pattern Matching: Covers the proposals for C# 9.
  • Precedence and Associativity of Relational Operators in TypeScript10/1/2019 1:42:08 AM. In this article I am going to explain how precedence and associativity of relational operators works in TypeScript.
  • Data Architecture - Choosing The Right Database 9/23/2019 11:54:01 PM. This article describes basic design considerations and addresses necessary architectural concerns while choosing the right database for the Enterprise.
  • Understanding Foreign Key Through GUI In SQL Server2/18/2019 11:03:10 AM. In this video tutorial, we will learn how we can create a Foreign Key in a child table referencing its parent table. And, we will try to understand the concept of foreign keys through GUI.
  • SQL Server And Relational Database - Part Two8/7/2018 9:03:13 AM. The server name is important because it is the server where you’re developing the database. If you’re working locally then by default here you’ll see your server name which is installed in your machin
  • SQL Server And Relational Database - Part One7/31/2018 5:02:19 AM. In this article, we will discuss SQL Server And Relational Database.
  • Essential Features Of TablePlus - The Best GUI Tool To Manage Relational Databases5/25/2018 10:08:35 AM. TablePlus helps you to be more efficient while working with multiple relational databases. You can connect to the server, create a new database, manipulate and save your data at a fast speed, high-end
  • Object-Relational Mapper For SQLite3 In Node.js12/7/2017 11:14:44 PM. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database developme
  • Working with Relational Data in ADO.NET10/20/2012 4:32:46 AM. Working with hierarchal data was not that easy with the previous version of ADO.
  • An introduction to Matisse, a post-relational database for .NET - Part 110/20/2012 3:29:44 AM. When it comes to database for .NET, there are several options in addition to the well known ones such as SQL Server or MySQL. One of them is Matisse, a post-relational database by Matisse Software.
  • Abstract Factory Pattern12/3/2011 11:23:19 PM. In this article I would like to explain the Abstract Factory pattern. This pattern is essential for learning the Factory Method and Bridge patterns.
  • Silverlight 4 LINQ to SQL Classes in VS 20107/14/2011 5:30:03 AM. LINQ to SQL is an ORM (stands for Object Relational Mapper/Mapping), which provides a data access layer for the application.
  • CRUD Operations on Relational Data (Multiple table) using RIA with Silverlight 43/3/2011 2:28:52 AM. Relational/Hierarchical data and CRUD operation against them using RIA Service with a real time example.
  • Real Life SQL and .NET: Part II2/8/2006 5:55:26 AM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part IV2/8/2006 5:45:43 AM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.