Working with Database-MSSQL Server (1): Introduction to Microsoft SQL Server and Explanation of what we will do in this series of articles.

In the Working with Database series, firstly, we will examine Relational Database Management Systems; Microsoft SQL Server, MySQL, PostgreSQL, and MariaDB, then Amazon RDS as a SQL database. Then, We will examine MongoDB and Amazon DynamoDB as Non-relational management systems (they are commonly referred to as NoSQL databases). We will do all the subjects practically (Hands-on) and step by step.

Relational databases store data in tables. Tables can grow large and have a multitude of columns and records. Relational database management systems (RDBMSs) use SQL (and variants of SQL) to manage the data in these large tables.

Non-relational (NoSQL) databases use a data model that has a different structure than the rows and columns table structure used with RDBMS. NoSQL databases are different from each other. There are four kinds of this database: document databases, key-value stores, column-oriented databases, and graph databases. (1)

Firstly, we will start the article series with a Relational Database Management System: Microsoft SQL Server 2022. We will run Microsoft…