MySQL

Understanding Views in SQL

Learn about the concept of views in SQL, and how they work. Read on to see clear …

Working with SQL Cursors

In SQL cursors serve as a pointer that enables application programming language to deal …

Connecting to a MySQL Database in .NET

Learn how to connect to a MySQL database from a .NET application.

Adding Data to a Cloud Firestore Database

Learn how to add data to a NoSQL Cloud-based database (Firebase Firestore) from a …

Introduction to Firebase

If you are doing a mobile or web-based app that need scalable access to a scalable, …

Understanding Query Execution in Relational Database System Architecture

What happens behind the scene in a modern relational database management system when a …

A Quick Look at SQL Server Numeric Functions

If you are wanting to manipulate numeric data with mathematically, then you will wan …

Query Performance Optimization in MySQL

Discover a few optimization points to ponder upon while designing a better query in …

Understanding Schema Optimization in MySQL

Optimizing Schemas for your data can involve trade-offs. Delve into the intricacies of …

Using Five Types of JOIN in MySQL

Learn how to use the different types of joins available in a MySQL database.

Planning for SAP HANA Deployments in Public Cloud Environments

Learn about the factors that should be taken into account if you are considering …

Database Tools and Extensions for Visual Studio 2019

In this article, you will explore tools and extensions that can be used with Visual …

Polling and Survey Data Transparency

Polls and surveys are increasing in use. If you are a DBA, developer, or data …

Ten SQL Commands You Should Be Using

Most developers, regardless of their skill level would know the commands for the basic …

Database Development in an Open Source World

Open source database tools are found in many categories, including engine, modeling, …