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 SQL Server and Apache Webserver + PHP together in Containers. We will run the containers first with Dockercompose, then with Amazon Container Service (ECS), and later we will run them with the Kubernetes yaml files by using Helm on the Elastic Kubernetes Service (EKS).

We will enter Microsoft SQL Server data and then query them.

We will troubleshoot in the containers (in Microsoft SQL Server and Webserver). We will examine together the 6 problems and solutions I encountered while setting up Microsoft SQL Server, one by one.

Finally, we will write a Jenkins pipeline, to make them automatically deploy and update in the CI/CD lifecycle.

For Microsoft SQL Server, we will first prepare Dockerfiles and then create two Docker containers from them. One holds a Microsoft SQL database, and the other holds a web server (Apache) with a pre-defined PHP script in order to test the Database. We will…