Sooner or later, you want to know when a column contains in SQL another value. In this article we’ll go over several ways you can test to see whether one value is contained within an another.

Correlated Subqueries in SQL

by essentialSQL

Comparison of a correlated sub query to a join

Cross Join Introduction – Create Row Combinations

by essentialSQL

Introduction to cross join - create row combinations

Cross-Tabulation (Pivot Tables) with MySQL

by Cale Dunlap

Example of using code-based query generation, transposition, cross-tabulation, and normalized data to produce a query result that can feed a simple chart from data which was not originally designed with reporting or charting in mind.

CRUD Operations with IndexedDB - Part 1: Creating and Clearing a Database

by Gerd Wagner

How to create and clear an IndexedDB database keeping all code in a single HTML file. Creating an IndexedDB database means first creating an empty database, and then adding records to its empty tables (or "object stores").

Database Normalization

by Gaston Verelst

Introduction After I published last week’s article somebody asked me why I stated that (in this case) the problem didn’t originate in having a function with logic, but merely having to work with a database that is not normalized. So let’s talk … Continue reading →

Database Snapshot Failed Due to Disk Space Issue

by Rohitmssqlfun

Database snapshot failed due to disk space issue

Deep Data Dive with Kusto for Azure Data Explorer and Log Analytics

by Jeremy Likness

Some ah-hah moments about Kusto

Efficiency of Subqueries and OR conditions in SQL

by Andrew Zwicker

A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.

Execute SQL Query on Mutiple SQL Servers or Databases Simultaneously

by Mohit1110

In this blog we would learn how to execute a SQL Query on multiple databases of single DB Server or on a single Database on multiple DB Servers.

Firebase Android Tutorial Part 1 – Getting Started

by Andy Point

Firebase Android Tutorial : Adding Registration and Login Hello Developers, this is our android firebase tutorial. In this tutorial we will create an android firebase app that will use firebase android login functionality. This post will help you get you up and running with integrating Firebase to a

Firebase Realtime Database By Example with Android

by Val Okafor

A complete, step by step tutorial on working with Firebase Realtime Database in Android

Fluent NHibernate - Working with Database Views

by Gilly Barr

Fluent NHibernate - Working with Database Views

Get Ready to Learn SQL Server: 17. How to Use the Intersect Operator

by essentialSQL

How to use the Intersect Operator in SQL Server

Get Ready to Learn SQL Server: 5. Filter Results Using Patterns

by essentialSQL

In this lesson, you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.

Get Ready to Learn SQL Server: 15. Combine Table Rows Using UNION

by essentialSQL

How to combine table rows using UNION in SQL Server

Get Ready To Learn SQL Server: 3. How to Filter Your Query Results

by essentialSQL

In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.

Get Ready to Learn SQL Server: 4. Query Results Using Boolean Logic

by essentialSQL

Learn more about filtering results returned from your queries using the WHERE clause

Get Ready to Learn SQL: 10. Database Second Normal Form Explained in Simple English

by essentialSQL

Database Second Normal Form explained in simple English

Get Ready to Learn SQL: 11. Database Third Normal Form Explained in Simple English

by essentialSQL

Database Third Normal Form explained in simple English

Get Ready to Learn SQL: 8. Database Normalization Explained in Simple English

by essentialSQL

Database normalization in SQL explained in simple English

Get Ready to Learn SQL: 9. Database First Normal Form Explained in Simple English

by essentialSQL

Database First Normal Form explained in simple English

Getting Started with NoSQL and MongoDB

by JonB3232

Getting Started with NoSQL and MongoDB

Getting Started with SQL Server: 1. Simple SELECT Queries

by essentialSQL

Simple SELECT queries in SQL Server

Getting Started With SQL Server: 2. Sort Your Query Results

by essentialSQL

How to sort your query results in SQL Server

How to Deploy Entity Framework Database Migrations

by Lee P Richardson

Deploy EF database migrations while avoiding security flags

How to Multicast messages with SQL Server Service Broker

by rusanu

How to Multicast messages with SQL Server Service Broker

How to Speed Up MySQL Database Performance

by Right Handed Monkey

MySQL Database Performance Diagnostics - Where to start?

How to Use SQL Variables in Queries

by essentialSQL

In this video and the following article, we’ll take you step-by-step through the process of changing a query’s filter criteria into a SQL variable, then ultimately into a stored procedure.

How to Write SQL – Understand Database Table Meanings and Relationships – Step 1

by essentialSQL

How to Write SQL – Understand Database Table Meanings and Relationships – Step 1

Introducing the WorxForUs Open Source Database & Network Helper for Android

by Right Handed Monkey

Introducing the WorxForUs Open Source Database & Network Helper for Android

Introduction to NoSQL and Polyglot Persistence

by Nikola M. Živković

Introduction to NoSQL and Polyglot Persistence

Join on tables using Fluent NHibernate

by Gilly Barr

Join on tables using Fluent NHibernate

Joins vs Subqueries SQL Puzzle

by essentialSQL

Puzzle to teach joins vs subqueries in SQL

Left Join versus Right Join Comparison

by essentialSQL

In this blog entry we discuss the difference between left join versus right join operators.

Mapping Shortest Routes Using a Graph Database

by Keyhole Software

We often model interconnected data by cramming it in and out of table structures. Why don’t we simply model interconnected data as … interconnected data?

MEAN web development #7: MongoDB and Mongoose

by Sander Rossel

The seventh in a series on MEAN web development.

Migrating a Project from Database First to Code First

by kevinfitzpatrick

Migrating a Project from Database First to Code First

Onion Architecture using MVC and Database First Approach

by Jasminder Singh

Onion architecture using MVC and database first approach

Oracle Database Table to JAVA Bean Class Converter

by Debopam Pal

Oracle Database Table to JAVA Bean Class Converter

by Debopam Pal

Oracle database table to Java Beans Class Converter

Order of Execution in SQL Explained

by essentialSQL

In this blog entry we do an overview of the order if execution in SQL.

Overview of ADO.NET

by JasonShort

ADO.NET is a set of libraries included in the .NET Framework to facilitate the communication of applications with various data storage mechanisms. These libraries form the basis for all third parties to provide database access.

Prepared Statements for Database Driven Application

by Vivek Goyal

Prepared statements for database driven application

Preventing Duplicates in the Data

by Andrew Zwicker

How to prevent duplicates in the data

Realm Database Tutorial For Android – Part 1

by Val Okafor

Realm Database Tutorial For Android – Part 1

Realm Mobile Database with Xamarin Forms Step By Step guide

by S Ravi Kumar (TechieRathore)

Whenever we talk about offline data persistence in Mobile application using a database the only database comes in our mind is SQLite as it is [...]

Redis: Replication, Part 1 – An Overview. Replication vs Sharding. Sentinel vs Cluster. Redis Topology

by setevoy4

In this post – some quick overview, a brief explanation about differences in Redis data storage, topology examples. In short terms but with links to detailed documentation and other useful posts on other resources.

Redis: Replication, Part 3 – redis-py and Work with Redis Sentinel from Python

by setevoy4

The redis-py library and work with Redis Sentinel from Python

Reducing KnpPaginatorBundle Database Queries

by Alvin Bunk

Introduction If you are not familiar with the KnpLabs KnpPaginatorBundle and how to use it with Symfony applications, you might want to read up on it. The GitHub page does say it is a Symfony 2 bundle, however, it does work perfectly with Symfony 3. Why would you use it?

RESTORE DATABASE is Terminating Abnormally

by Bryian Tan

Restore Database is terminating abnormally

Rewrite Subquery as a Join

by essentialSQL

How to rewrite a subquery as a join

Saving An Image in a SQLite Database in Your Android Application

by Cindy Potvin

Saving an image in a SQLite database in your Android application

SCALA : Connecting to a database

by Sacha Barber

This time we will proceed to look at using Scala to connect to SQL server.

Script to extract all check constraints from a database

by Mel Padden

From a utility I'm working on. Compatible with SQL-92 INFORMATION_SCHEMA views.

SQL Bill of Materials Example

by essentialSQL

Puzzle to explore a SQL BOM example

SQL Data Conversions

by essentialSQL

Learn about implicit data conversion and explicit type conversions with CAST AND CONVERT

SQL FULL Join Tutorial

by essentialSQL

In this article we look at SQL FULL JOIN examples and make a few notes of things to look for.

SQL Joins and Subqueries

by Andrew Zwicker

A discussion about SQL joins and subqueries with information about how to format join statements properly

SQLite Database

by Sam Varadarajan

An introduction to SQLite.

Storing Database Tables in JavaScript's Local Storage

by Gerd Wagner

Storing database tables in JavaScript's Local Storage

Symfony: Connecting to External Database

by Alvin Bunk

Symfony: Connecting to External Database

The Firebird Database Engine & The Frustrations of The Long Distance Database Application Developer

by Steve Naidamast

https://www.firebirdsql.org/ Author’s Notes… Though I have extensive database application development experience, I do not consider myself an expert with the Firebird Database Engine to any degree.

Top 5 Stored Procedure Performance Tips You Can Use

by essentialSQL

Top five performance tips for Stored Procedures

TSQL Split a String by Delimiter

by Shahriar Iqbal Chowdhury/Galib

TSQL split a string by delimiter

Using C# to Connect to and Query from a SQL Database

by Sander Rossel

Using C# to get data in- and out of your (relational) database

Using Membase for ASP.NET Output Caching

by andy404

Using Membase for ASP.NET Output Caching