database management

Understanding a SQL Schema

The article describes the basics of a database schema, the advantages of using schemas, and covers how to create, modify, and delete them in the SQL Server database.

(more…)

How to download and install SQL Server Express edition?

The article covers a step-by-step guide describing how to install a SQL Server Express edition on the computer. MS SQL Server Express 2019 is a free version of Microsoft’s SQL Server relational database management system used to develop databases and SQL queries, manipulate data, and perform database-related tasks that do not require large volumes of database storage.

(more…)

MySQL SELECT Statement Basics

The article covers the basic syntax of a MySQL SELECT statement and provides examples that show how to use a MySQL SELECT statement to retrieve data from tables.

(more…)