Azure SQL Database Web Application

Project Overview

This project involves setting up an Azure SQL Database and connecting it to a simple web application. The goal is to practice basic SQL queries and understand the integration between Azure SQL Database and web applications, such as ASP.NET or Node.js.

The Employee Management System

Tools & Technologies Used

• Azure SQL Database: A managed database service provided by Microsoft Azure.
• ASP.NET / Node.js: Choose one for developing the web application.
• SQL: For querying the database.
• GitHub: A web-based platform that uses Git for version control and collaboration. It allows developers to host their projects, share code, and manage issues and pull requests.
• Azure Data Studios: A tool that enables data you to manage SQL Server and Azure SQL Database efficiently.
• Visual Studio Code: A popular code editor that provides support for various programming languages, debugging tools, and extensions.

Steps

Setup Instructions

1. Create an Azure SQL Database:

   • Log in to your Azure Portal.
   • Click on Create a resource > Databases > SQL Database.
   • Fill in the required fields (Database name, Server, etc.).
   • Configure the pricing tier based on your needs.
   • Click Review + Create and then Create.

2. Configure Firewall Settings:

   • Go to your SQL Database resource in the Azure Portal.
   • Click on Set server firewall.
   • Add your client IP address to allow access.

3. Connect to the Database:

   • Use SQL Server Management Studio (SSMS) or Azure Data Studio to connect to your database using the server name, database name, and authentication method (SQL authentication recommended).

4. Create Tables and Insert Data:

   • Run basic SQL commands to create tables and insert sample data.