DEV Community: Ifeoma Usonwa Nwafor

Introduction to SQL: A Beginner's Guide to Creating, Reading, Updating, and Deleting Data

Ifeoma Usonwa Nwafor — Tue, 03 Nov 2026 08:40:43 +0000

Introduction

Have you ever wondered how applications store user information, how banks manage customer records, or how online stores keep track of products, prices, and orders?

Behind many of these systems is a database, and one of the most widely used languages for working with relational databases is SQL (Structured Query Language).

I recently completed a short course on Introduction to SQL, where I learned fundamental SQL queries for creating tables, retrieving information, inserting records, modifying existing data, deleting records, and applying constraints.

As part of my learning journey in technology, I want to share these fundamentals in a simple, practical way for anyone taking their first steps into databases, data analysis, software development, or cloud computing.

Let's get started!

1. What is SQL?

SQL stands for Structured Query Language. It is a language used to communicate with relational database management systems (RDBMS) such as:

MySQL
PostgreSQL
Microsoft SQL Server
SQLite
Oracle Database

SQL allows us to create database structures, store information, retrieve records, update data, and manage how information is organized.

For example, imagine a school database containing students' names, ages, and identification numbers. Instead of keeping this information in separate documents, we can organize it in a database table and use SQL to manage it efficiently.

2. Why is SQL useful?

SQL is an important skill across several areas of technology and business.

Data analysis: Analysts use SQL to retrieve, filter, and organize data to discover trends and generate reports.

Software development: Developers use SQL to store and retrieve application data, such as customer accounts, orders, and transactions.

Cloud computing: Cloud engineers work with managed database services such as Azure SQL Database, Amazon RDS, and Google Cloud SQL.

Business operations: Organizations use databases to manage employees, inventory, customer records, and financial information.

Data management: SQL makes it possible to maintain structured information, enforce data rules, and modify records without manually editing every entry.

Learning SQL provides a foundation for understanding how modern applications and data-driven systems work.

3. Understanding database tables

A relational database organizes data into tables. A table contains columns and rows.

For example, a table called students could contain the following information:

id	name	age
1	Ada	22
2	Chidi	25
3	Amaka	20

Here:

id, name, and age are columns.
Each student's information represents a row.
INTEGER is a data type used for whole numbers.
TEXT is a data type used for text values.

Now let's explore the SQL commands used to create and manage a table like this.

4. Creating a table with CREATE TABLE

The CREATE TABLE statement creates a new table in a database.

CREATE TABLE students (
    id INTEGER,
    name TEXT,
    age INTEGER
);

Let's break it down:

CREATE TABLE tells the database to create a new table.
students is the table name.
id INTEGER creates a column for whole numbers.
name TEXT creates a column for text.
age INTEGER creates a column for whole numbers.
The parentheses contain the column definitions.

The semicolon (;) marks the end of the SQL statement.

Why is this useful?

Before storing information, we need a structure that defines how the data will be organized. Creating a table establishes that structure.

5. Retrieving data with SELECT

Once information has been stored in a table, we can retrieve it using SELECT.

To display all columns and rows from the students table, we write:

SELECT * FROM students;

The asterisk (*) means all columns.

If we only want students' names, we can specify the column:

SELECT name FROM students;

To retrieve both names and ages:

SELECT name, age
FROM students;

We can also filter results using WHERE:

SELECT *
FROM students
WHERE age = 22;

This returns only records where the student's age is 22.

Why is this useful?

The SELECT statement is essential when searching databases for specific information. For example, a business could retrieve customer details, find products, or generate reports from stored records.

6. Adding records with INSERT INTO

The INSERT INTO statement adds new records to a table.

For example:

INSERT INTO students (id, name, age)
VALUES (1, 'Ada', 22);

Here:

INSERT INTO students identifies the table.
(id, name, age) specifies the columns receiving data.
VALUES provides the information to insert.
'Ada' is enclosed in single quotes because it is text.

We can add another student:

INSERT INTO students (id, name, age)
VALUES (2, 'Chidi', 25);

Each statement inserts one new record.

Why is this useful?

Applications use insert operations whenever new information needs to be saved, such as registering a user, recording an order, or adding a new employee.

Note: These examples assume the table is empty. If an existing record already uses the same ID, the insert may fail when a uniqueness constraint is enforced.

7. Modifying a table with ALTER TABLE and ADD COLUMN

Sometimes, our database needs additional information that was not included when the table was first created.

For example, we may decide to store students' email addresses.

We can add a new column using:

ALTER TABLE students
ADD COLUMN email TEXT;

Let's understand the statement:

ALTER TABLE modifies an existing table's structure.
students identifies the table.
ADD COLUMN adds a new column.
email TEXT defines the new column and its data type.

Existing records will generally have NULL in the new column until a value is provided, depending on the database and column definition.

Why is this useful?

Database requirements change as applications grow. ALTER TABLE allows us to extend a table's structure without recreating the entire table.

The exact syntax and supported alterations can vary between database systems.

8. Updating existing records with UPDATE, SET, and WHERE

The UPDATE statement changes data already stored in a table.

Suppose Ada's age changes from 22 to 23. We can update her record with:

UPDATE students
SET age = 23
WHERE id = 1;

Let's break it down:

UPDATE students identifies the table to modify.
SET age = 23 assigns a new value to the age column.
WHERE id = 1 identifies the record to update.

The WHERE clause is particularly important because it helps target the correct record.

What happens if we leave out WHERE?

UPDATE students
SET age = 23;

This statement can update the age of every row in the table.

Always check your conditions before running an update, especially in a production database.

Why is this useful?

Businesses frequently update customer information, employee details, product prices, and order statuses. The UPDATE statement makes these changes possible.

9. Deleting records with DELETE FROM

The DELETE FROM statement removes records from a table.

For example, to delete the student whose ID is 2:

DELETE FROM students
WHERE id = 2;

Here, DELETE FROM students identifies the table, while WHERE id = 2 identifies the record to remove.

Important: Omitting the WHERE clause can delete every row in the table.

DELETE FROM students;

This removes all records but ordinarily leaves the table itself in place.

To remove the table structure entirely, a different command, DROP TABLE, is used.

Why is this useful?

Deleting data helps maintain accurate records, remove obsolete information, and support data-retention policies. In real applications, deletion should be handled carefully because it may be difficult to recover deleted records without backups or transaction support.

10. Understanding SQL constraints

Constraints are rules applied to table columns to help maintain accurate and reliable data.

Without constraints, a database might allow missing names, duplicate identifiers, or values that do not meet the requirements of the application.

Here are some common SQL constraints.

PRIMARY KEY

A primary key uniquely identifies each record in a table.

CREATE TABLE students (
    id INTEGER PRIMARY KEY,
    name TEXT,
    age INTEGER
);

Each student must have a unique ID. A primary key cannot contain duplicate values or NULL.

NOT NULL

The NOT NULL constraint prevents a column from accepting NULL values.

CREATE TABLE students (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    age INTEGER
);

This requires every inserted student record to include a non-NULL name.

UNIQUE

The UNIQUE constraint prevents duplicate values in a column or combination of columns.

CREATE TABLE students (
    id INTEGER PRIMARY KEY,
    email TEXT UNIQUE
);

This helps prevent multiple records from sharing the same non-NULL email address. How NULL values are handled by unique constraints can vary by database system.

CHECK

The CHECK constraint enforces a condition on the data.

CREATE TABLE students (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    age INTEGER CHECK (age >= 0)
);

This prevents the database from accepting a negative age when the constraint is enforced.

DEFAULT

The DEFAULT constraint supplies a value when an insert does not specify one.

CREATE TABLE students (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    status TEXT DEFAULT 'active'
);

If a record is inserted without specifying status, the database uses 'active'.

Why are constraints useful?

Constraints help enforce data integrity at the database level. They reduce the risk of invalid or inconsistent records and support more reliable applications.

11. Putting the commands together

Let's combine what we have learned into a simple workflow.

-- 1. Create the table
CREATE TABLE students (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    age INTEGER CHECK (age >= 0)
);

-- 2. Insert a record
INSERT INTO students (id, name, age)
VALUES (1, 'Ada', 22);

-- 3. Retrieve all records
SELECT * FROM students;

-- 4. Update a record
UPDATE students
SET age = 23
WHERE id = 1;

-- 5. Retrieve a specific record
SELECT *
FROM students
WHERE id = 1;

-- 6. Delete a record
DELETE FROM students
WHERE id = 1;

This example demonstrates a basic database lifecycle: creating a table, inserting information, reading it, updating it, and deleting it.

The comments beginning with -- are explanatory notes and are not executed as SQL statements.

12. Best practices when learning SQL

As you continue practising SQL, keep these principles in mind:

Use meaningful names. Choose clear table and column names that describe the data they contain.
Understand your data types. Select appropriate types for numbers, text, dates, and other values.
Use constraints. Define rules that prevent invalid or duplicate data where appropriate.
Be careful with UPDATE and DELETE. Verify your WHERE conditions before executing changes.
Practise with sample data. Experiment in a local database before working with important information.
Learn transactions and backups. These concepts help protect data when changes go wrong.
Keep learning. Explore filtering, sorting, aggregate functions, joins, indexes, and database security as your confidence grows.

Conclusion

Learning SQL has introduced me to an important part of how information is stored, organized, and managed in modern technology.

Understanding commands such as CREATE TABLE, SELECT, INSERT INTO, ALTER TABLE, UPDATE, and DELETE FROM provides a practical foundation for working with relational databases. Learning constraints also shows why data quality and integrity matter.

For anyone interested in data analysis, software development, cloud computing, or DevOps, SQL is a valuable skill to develop. Databases are a fundamental part of many applications, and knowing how to interact with them helps us better understand the systems we build and support.

This is another step in my journey of learning, practising, and sharing knowledge as I grow in technology.

My next step: Continue practising SQL and explore more advanced concepts, including filtering with ORDER BY, summarizing data with aggregate functions, and combining tables using JOIN.

If you are also learning SQL, I would love to hear from you in the comments:

Which SQL command did you find easiest to understand, and which one took you the longest to learn?

Let's keep learning and growing together!

#SoftwareDevelopment #LearningInPublic

Learn how to create, configure, and connect to your first Linux virtual machine in Microsoft Azure through a practical, step-by-step tutorial.

Ifeoma Usonwa Nwafor — Wed, 28 Oct 2026 08:01:04 +0000

Linux virtual machines play an important role in cloud computing. They provide flexible, scalable, and cost-effective environments for running web applications, databases, APIs, development environments, and other business-critical workloads.

Understanding how to create and configure a Linux virtual machine is a valuable foundational skill. It provides practical experience with cloud infrastructure, operating system administration, networking, security, and remote server access. These skills also form the foundation for more advanced practices such as infrastructure automation, containerization, continuous integration and continuous delivery (CI/CD), and cloud infrastructure management.

What You Need Before You Start

An Azure account
A terminal (PowerShell for Windows, or the built-in Terminal for macOS/Linux)

Step 1
-Open your Azure account ,locate the search terminal and type virtual machine
-click on create

Step 2

Create a resource group(choose a name for the new vm)
Select the region you want to operate from.
Select an Image and size. At the Admin Account section
select password, create a new one.
select inbound ports as HTTPS (80) and SSH (22)

-Go to monitoring broad and disable it, this is done to keep your work private.

click on review and create.

click on Go to resource

On the Native SSH page click on VM access (check access)- this allows you certify your IP address is up and running, make sure to copy the IP address and keep aside.

STEP 3

Open the powershell program - paste the SSH command (IP address)
Respond yes to the pop up question .
Fill the password you created while setting up your VM(virtual machine)

To update the VM type sudo apt update
To have admin rights type sudo su, then apt install nginx to install the program, then type yes.

You have successfully created a virtual machine on linux.

Whether you are a company looking to deploy reliable services or a beginner working toward a career in cloud engineering, learning to create a Linux virtual machine in Microsoft Azure is an important step toward understanding how modern cloud infrastructure works.

Overcoming the 'Git Scares': A Friendly Beginner's Guide to Open Source. Part 1

Ifeoma Usonwa Nwafor — Wed, 09 Sep 2026 17:47:29 +0000

Entering open source can feel daunting. The sheer fear of running the wrong command in your terminal, breaking a codebase, or looking inexperienced stops many capable developers from making their very first contribution. This is the "Git Scares"—and every engineer has felt it.

This guide eliminates that barrier. Instead of throwing you into complex codebases and messy bug fixes, Part 1 walks you through the cleanest, zero-risk way to submit your first Pull Request: adding your name to CONTRIBUTORS.md in an active community repository (PinpointPro).

By the end of this tutorial, you will have completed the full professional Git lifecycle—forking, cloning, branching, committing, pushing, and opening a Pull Request—without the risk of breaking production.

What You Need Before You Start

A free GitHub account
Git installed on your computer (Download Git)
A terminal (Git Bash or PowerShell for Windows, or the built-in Terminal for macOS/Linux)
A simple text editor (Notepad, VS Code, or Vim)

Take a breath, open your terminal, and let’s make your first contribution!

STEP 1

Fork the Repository on GitHub

Forking gives you a space you fully own — you can experiment, commit, and break things without touching the original project. We are working with a repository from [https://github.com/raphgm/pinpointpro] .Forking also creates a personal copy of the PinpointPro repository under your own GitHub account, with its full commit history.

-1. Open your browser and go to: https://github.com/raphgm/pinpointpro
-2. Click the 'Fork' button in the top-right corner
-3. Leave all settings as default and click 'Create fork'
-4. GitHub will redirect you to your fork at: https://github.com/YOUR_USERNAME/pinpointpro

STEP 2

Configure Your Git Identity

Without this, Git cannot create a commit — it will error and ask you to configure your identity first. Your email must match your GitHub account so your commits are correctly linked to your GitHub profile and appear in your contribution graph.

USE

git config --global user.name "Your Name"
git config --global user.email "you@example.com"
git config --list

STEP 3

Clone Your Fork to Your Machine

All Git commands must run from inside the repository folder. The clone creates a full local copy — including commit history — so you can work offline.

USE

git clone https://github.com/YOUR_USERNAME/pinpointpro.git
cd pinpointpro

STEP 4

Wire Up the Upstream Remote

Add the Upstream Remote -The upstream remote lets you pull those changes before branching — preventing stale-branch conflicts.

git remote add upstream https://github.com/raphgm/pinpointpro.git

Verify Both Remotes Exist -Never assume a command worked — always verify. A misconfigured remote is one of the most common sources of failed pushes and unexpected PR targets.

git remote -v

Sync Your Fork with Upstream -Fetches all new commits from the upstream repo, then merges them into your local main branch so your fork is fully up to date.

USE

git fetch upstream
git checkout main
git merge upstream/main

STEP 5

Create Your Feature Branch

Feature branches isolate every piece of work from main. If your PR is rejected, nothing is affected. If a colleague opens a PR at the same time, there's no conflict. This is non-negotiable in every professional engineering team.

USE

git checkout -b feature/yourname-add-contributor
git branch

STEP 6

Choose Your Contribution & Make It

Open the file:
mac/linux: vi CONTRIBUTORS.md
windows (Git Bash): notepad CONTRIBUTORS.md
windows (PowerShell): notepad .\CONTRIBUTORS.md
Append this block at the very bottom :
Your Full Name
GitHub: @your-username
Contribution:
Date: YYYY-MM-DD

USE

git diff CONTRIBUTORS.md

Shows the differences between your working files and the last commit

STEP 7

Stage & Commit Your Work

Stage Your Changed Files-Staging lets you craft precise, single-purpose commits , intentional staging produces a clean, auditable commit history.

_USE _

git add CONTRIBUTORS.md
git status

to confirm what is staged
- Commit with Conventional Commits Format -Records a permanent, labelled snapshot of your staged changes in the repository's history.

USE

git commit -m "docs(contributors): add @yourname - Project name"
git log --oneline -3

to verify your commits

STEP 8

Push & Open a Pull Request

Push Your Feature Branch to Your Fork - Uploads your local branch to your fork on GitHub. A local commit can be lost; a pushed commit is durable and shareable.

USE

git push -u origin feature/yourname-add-contributor

Open the Pull Request on GitHub- Formally proposes your branch for review and merge into the original repository's main branch.

USE
-After pushing, GitHub prints a URL — click it, or navigate to:
https://github.com/raphgm/pinpointpro/compare
-Configure the PR -head repository: YOUR_USERNAME/pinpointpro | compare: your-branch-name
-Write a clear PR title matching your commit message format. Example -docs(contributors): add @yourname - Phase 2 Project
-In the PR description, explain:

What you changed
Why it improves the project
How you tested it (if applicable)
-Click 'Create pull request'
- Confirm Your PR Is Open and Awaiting Review - Always verify the end state of every action. A PR that was never submitted cannot be reviewed or merged. -Your PR should show: 'Open — 1 review required

STEP 9

Create the README File - README.md documents what this project is and how to reproduce it — the first thing anyone sees when they open the repo.

USE

touch README.md

Document What You Did -A good README captures what was learned and which commands prove it, so it doubles as both documentation and a portfolio artifact.

USE

printf '# PinpointPro Git Flow Contribution\n\nForked, cloned, and contributed to a real open-source repo using the full Git Flow lifecycle.\n\n## Commands Covered\n\n```

bash\ngit clone https://github.com/YOUR_USERNAME/pinpointpro.git\ngit remote add upstream https://github.com/raphgm/pinpointpro.git\ngit fetch upstream\ngit checkout -b feature/yourname-add-contributor\ngit add CONTRIBUTORS.md\ngit commit -m "docs(contributors): add @yourname"\ngit push -u origin feature/yourname-add-contributor\n

```\n' >> README.md

Check Status and Stage Your Changes -Always check git status before committing so you know exactly what you're about to save

USE

git status
git add .

Commit Your Work

USE

git commit -m "docs: add README for PinpointPro Git Flow lab"

Push to GitHub

USE

git push -u origin feature/yourname-add-contributor

🎉 You Just Beat the "Git Scares"!
Look at that: you forked, cloned, branched, committed, pushed, and officially submitted a Pull Request to an open-source project.

The hardest step in open source is rarely writing the code—it’s getting past the fear of hitting Enter in the terminal for the very first time. You’ve now mastered the exact Git lifecycle used by professional engineering teams every single day.

💬 Share Your Win!
Drop your GitHub handle or your PR link in the comments below so we can celebrate your first contribution together!

Hit any roadblocks or get an unexpected terminal message? Comment with what went wrong—I'm actively checking the comments to help troubleshoot.

If this guide made Git feel a little less intimidating, don't forget to heart ❤️ and bookmark 🦄 the post so other beginners can find it.

Stay tuned for Part 2, where we'll dive into finding "Good First Issues," reading project issue trackers, and resolving your very first merge conflict!

Deploying Scalable Virtual Machines on AWS Using Amazon EC2: A Beginner’s Guide.

Ifeoma Usonwa Nwafor — Fri, 27 Feb 2026 12:43:30 +0000

Cloud computing has transformed how individuals and organizations deploy computing resources, and one of its core components is the virtual machine. A virtual machine (VM) is a software-based computer that runs operating systems and applications just like a physical server, but within a cloud environment. On the Amazon Web Services (AWS) platform, virtual machines are provisioned through Amazon Elastic Compute Cloud (Amazon EC2), which provides secure and resizable compute capacity in the cloud. EC2 allows users to scale resources up or down based on demand, making it ideal for startups, developers, and enterprises. By leveraging AWS infrastructure, users benefit from flexibility, cost-efficiency, and high availability. This guide introduces beginners to the fundamental concepts and practical steps involved in deploying scalable virtual machines using Amazon EC2.

To create an EC2 instance

On your AWS home page search for EC2
Click on the dashboard

-click on Launch Instances

- Select Name and Tag , click on add tag.

-select ubuntu or amazon linux

-scroll down to key pair, click on add ,create a name and click on create

-leave all other sections as default
-click on launch image

*go back to the dashboard and click connect *

-click on instance and click connect

The EC2 / virtual machine is set and ready for use.

“Provisioning a Virtual Machine in Microsoft Azure: A Practical Guide”

Ifeoma Usonwa Nwafor — Fri, 27 Feb 2026 11:01:31 +0000

A virtual machine (VM) is a software-based emulation of a physical computer that runs an operating system and applications using virtualized hardware resources. Creating a virtual machine on the Microsoft Azure Portal or AWS platform allows users to deploy and manage scalable computing resources without purchasing physical hardware. Some key components of a VM include virtual CPU (vCPU), memory (RAM), virtual storage disks, network interfaces, and a hypervisor that manages resource allocation.
Virtual machines are needed to support flexible development, testing, remote work, and workload isolation while optimizing infrastructure costs. For professionals, VMs provide scalability, disaster recovery options, secure environments, and the ability to deploy applications globally within minutes.
As cloud adoption accelerates, virtual machines will continue evolving with automation, AI-driven optimization, and hybrid cloud integration shaping the future of computing.

Step 1

On Azure portal search for Virtual Machines.
Click on Azure Virtual Machine .

Select virtual machine hosted by Azure.

Step 2
select

Subscription
Create Resource group - name it (its preferred to create a new RG for A new VM to avoid mix -up of old and new data)

any region of your choose.
Configure Virtual Machine details , choose a unique name.
Security- standard
Operating system - windows server Data center *64 Gen 2
check the spot discount (optional, this is used to minimize cost.

Authentication type - password
choose a username and password of your choice
configure inbound port rules - RDP (for windows), SSH ( for linux)
select port 80
accept the license agreement

Step 3

Go to Monitoring Tab
Disable Boot Diagnostics

Step 4

Go to Tags Tab
choose a name and value of your choose. ** tags helps to identify data on the VM.

Go to the Review + create Tab
when the validation process is complete

select "create" to deploy.
after a successful deployment click on 'GO to resource'

click on 'connect' to kick start your VM.

-to increase your VMs time out , click on public IP address then increase it to 30.

Step 4
To download and run Open RDP file

select Native RDP - download the file
open RDP file on your computer
Enter Username + password
click connect to access VM
click continue.

I selected my region as Turkey hence the Turkish language on my virtual machine

Your virtual computer is ready to be used , you can access any data stored on the cloud.

Providing shared file storage on Azure

Ifeoma Usonwa Nwafor — Tue, 15 Jul 2025 16:43:42 +0000

How to Provide shared file storage

STEP 1

In the portal, search for and select** Storage accounts.** Select + Create.
For Resource group select Create new. Give your resource group a name and select **OK **to save your changes.
Provide a Storage account name. Ensure the name meets the naming requirements.
Set the Performance to Premium.
Set the Premium account type to File shares.
Set the Redundancy to Zone-redundant storage.
Select Review and then Create the storage account.
Wait for the resource to deploy.
Select Go to resource.

STEP 2
Create and configure a file share with directory.
Example :Create a file share for the corporate office..

In the storage account, in the Data storage section, select the File shares blade.
Select + File share and provide a*Name*.
Review the other options, but take the defaults.
Select Create

STEP 3
We need to Configure and test snapshots. Similar to blob storage, you need to protect against accidental deletion of files. You decide to use snapshots

Select your file share.
In the Operations section, select the Snapshots blade.
Select + Add snapshot. The comment is optional. Select OK.
Select your snapshot and verify your file directory and uploaded file are included.

STEP 3a
Configure restricting storage access to selected virtual networks.
This tasks in this section requires a virtual network with subnet. In a production environment these resources would already be created.

Search for and select Virtual networks.
Select Create. Select your resource group. and give the virtual network a name.
Take the defaults for other parameters, select Review + create, and then Create.
Wait for the resource to deploy.
Select Go to resource.

In the Settings section, select the Subnets blade.
Select the default subnet. In the Service endpoints section **choose **Microsoft.Storage in the Services drop-down.
Do not make any other changes.
Be sure to Save your changes.

STEP 4
The storage account should only be accessed from the virtual network you just created.

Return to your files storage account.
In the Security + networking **section, select the **Networking blade.
Change the Public network access to Enabled from selected virtual networks and IP addresses.
In the Virtual networks section, select Add existing virtual network.
Select your virtual network and subnet, select Add.
Be sure to Save your changes.
Select the Storage browser and navigate to your file share.
Verify the message not authorized to perform this operation. You are not connecting from the virtual network.

How to Configure simple settings in the storage account on Azure.

Ifeoma Usonwa Nwafor — Thu, 10 Jul 2025 14:47:40 +0000

Simple steps on how to configure simple settings in the storage account on Azure

STEP 1
When the data in this storage account doesn’t require high availability or durability. A lowest cost storage solution is desired.

In your storage account, in the Data management section, select the Redundancy blade.
Select Locally-redundant storage (LRS) in the Redundancy drop-down. Be sure to Save your changes.
Refresh the page and notice the content only exists in the primary location.

STEP 2
When the storage account should only accept requests from secure connections and developers would like the storage account to use at least TLS version 1.2.

In the Settings section, select the Configuration blade.
Ensure Minimal TLS version is set to Version 1.2. is enabled
Ensure Allow storage account key access is Disabled.
Be sure to Save your changes.

STEP 3
To ensure the storage account allows public access from all networks.

In the Security + networking **section, select the **Networking blade.
Ensure Public network access is set to Enabled from all networks.
Be sure to Save your changes.

Creating a resource group and a storage account on Azure for beginners.

Ifeoma Usonwa Nwafor — Thu, 10 Jul 2025 13:50:49 +0000

What is a Resource Group?
A Resource Group in Microsoft Azure is a container that holds related resources for an Azure solution. These resources could include virtual machines, storage accounts, databases, web apps, and more.

Uses of a Resource Groups.
✅ 1. Organizing Azure Resources
Resource groups help you logically group related Azure resources (like VMs, storage accounts, databases) so they’re easier to manage based on project, environment (dev/test/prod), department, or application.

✅ 2. Simplified Resource Management
You can manage and monitor all resources in a resource group collectively:
Deploy or delete resources together
Apply tags for cost tracking or resource categorization
Use Azure Policy to enforce rules on all resources in the group

✅ 3. Access Control and Security
Resource groups support Role-Based Access Control (RBAC):
Grant specific users or groups permission to only one resource group (instead of the whole subscription)
Example: Give a developer team access only to their project’s resource group

✅ 4. Cost Tracking and Budgeting
By grouping resources by project, team, or department, you can:
Track costs more easily
Assign budgets or spending alerts
Use tags to identify resource ownership and purpose

✅ 5. Automation and Deployment
You can use tools like:
ARM templates, Bicep, or Terraform to deploy multiple resources to a resource group at once
This ensures consistent, repeatable infrastructure deployments

✅ 6. Resource Lifecycle Management
Deleting a resource group deletes all resources inside it. This is useful for:
Cleaning up after temporary environments (e.g., dev/test)
Avoiding “resource sprawl” or leftover orphaned services

✅ 7. Monitoring and Alerts
You can apply:
Alerts
Diagnostics settings
Log analytics
to all resources within a group for centralized monitoring.

What is a storage account
This is the actual Azure service used to store data. A Storage Account is a top-level container that provides:
Blobs (object storage)
Files (file shares)
Queues (messaging)
Tables (NoSQL storage)
Disks (for VMs)
✅ Example: mystorageaccount.blob.core.windows.net

Simple steps to create a resource group and a storage account on Azure

STEP 1

In the Azure portal, search for and select Resource groups. Select Create.
Give your resource group a name. For example, storagerg.
Select a region. Use this region throughout the project.
Select **Review and create **to validate the resource group.
Select Create to deploy the resource group.

STEP 2
Create and deploy a storage account to support testing and training.

In the Azure portal, search for and select Storage accounts. Select + Create.
On the Basics tab, select your Resource group.
Provide a Storage account name. The storage account name must be unique in Azure.
Set the Performance to Standard.
Select Review, and then Create.
Wait for the storage account to deploy and then Go to resource.

Benefits of Cloud Computing.

Ifeoma Usonwa Nwafor — Tue, 08 Jul 2025 12:51:53 +0000

What is Cloud Computing.?
Cloud computing is the delivery of computing services—like storage, servers, databases, networking, software, and more—over the internet (the "cloud"). Instead of owning and maintaining physical data centers or hardware, businesses and individuals can access these resources on demand from cloud providers like Microsoft Azure, Amazon Web Services (AWS), or Google Cloud.
Here’s what makes it stand out:

🌍 Accessibility: Use apps and files from anywhere, on any device, with an internet connection.
📈 Scalability: Easily scale your resources up or down depending on your needs.
💸 Cost-Efficiency: Pay only for what you use, cutting down on upfront investments.
🔐 Security & Reliability: Most providers offer strong security features and backup systems. It’s like having a powerful digital toolkit that lives online—flexible, fast, and always within reach. Want a deeper dive into its benefits or real-life applications? I’ve got you covered.

*Benefits of Cloud Computing *

Virtualization
Virtualization is a technology that allows you to create a virtual version of something—like a computer, server, storage device, or network—using software. Instead of using a physical machine for every task, virtualization lets multiple virtual machines (VMs) run on a single physical device.

- Scalability
Scalability is the cloud’s superpower to grow with you. It refers to the ability of a system to handle increasing workloads, traffic, or users by adding more resources—like computing power, storage, or bandwidth—without compromising performance.

- Agility
This refers to how quickly and efficiently organizations can adapt to changes, deploy solutions, and respond to new opportunities or challenges using cloud-based services.

- High Availability
In cloud environments, this means ensuring that services, applications, and resources are always up and running, even in the face of hardware failures, traffic spikes, or maintenance.

- Fault Tolerant
The ability of a cloud system to continue functioning smoothly even when some parts of it fail. It’s all about designing systems that anticipate problems and keep running without interruption—like a backup generator kicking in when the power goes out.

- Global Reach
Thanks to vast networks of data centers spread across continents, cloud computing empowers businesses to serve customers, collaborate with teams, and deploy applications on a global scale.

*What is the difference between Elasticity and Scalability in cloud computing
*

Elasticity is like stretching or shrinking instantly as needed.
Scalability is more like upgrading your entire toolkit to support bigger and better projects.

Why DevOps engineering ?.

Ifeoma Usonwa Nwafor — Sun, 06 Jul 2025 14:56:58 +0000

What is DevOps engineering
DevOps engineering is a discipline that combines software development (Dev) and IT operations (Ops) to improve how software is built, tested, deployed, and maintained. The goal of DevOps is to shorten the development lifecycle, increase deployment frequency, and deliver high-quality software reliably.

**A DevOps Engineer typically focuses on:
Automation: **Creating scripts and tools to automate repetitive tasks like testing, deployment, and monitoring.

CI/CD (Continuous Integration / Continuous Deployment): Setting up pipelines that automatically build, test, and release code updates quickly and safely.

Infrastructure as Code (IaC): Managing cloud infrastructure using code (e.g., Terraform, AWS CloudFormation).

Monitoring & Logging: Ensuring systems are observable, with proper logs and metrics for troubleshooting.

Collaboration: Bridging gaps between development, QA, security, and operations teams to foster a culture of shared responsibility.

Why It Matters:
Speeds up delivery of software.

Reduces errors and downtime.

Enables teams to respond faster to changes or incidents.

Promotes a more collaborative and agile workflow.

DevOps Engineers are problem-solvers who work across technical and organizational boundaries. They must understand both code and infrastructure, and they play a vital role in enabling modern, scalable, and resilient systems**

_KEY BENEFITS OF DevOps
_
Here are the key benefits of DevOps in our world today, especially in the context of modern businesses, technology, and customer expectations:

🚀 1. Faster Software Delivery
DevOps automates development, testing, and deployment, allowing teams to release updates and new features more quickly and frequently.

✅ 2. Improved Software Quality
Continuous integration and automated testing reduce bugs and errors early in the development cycle, leading to more stable, reliable software.

🤝 3. Better Collaboration
DevOps breaks down silos between developers, operations, and other teams, encouraging shared responsibility and improved communication.

📉 4. Reduced Downtime and Failures
By using monitoring, logging, and automation, DevOps minimizes downtime and helps teams quickly detect and fix issues in production.

💸 5. Cost Efficiency
Automation and optimized workflows reduce wasted effort, cloud costs, and downtime—making IT operations more financially efficient.

☁️ 6. Effective Cloud Utilization
DevOps practices like Infrastructure as Code (IaC) and containerization enable efficient use of cloud platforms, making systems scalable and adaptable.

🔄 7 Continuous Improvement****
DevOps promotes a feedback-driven culture where teams can constantly learn, adapt, and improve both the product and the process.

🔐 8. Enhanced Security
With DevSecOps (Security + DevOps), security is integrated into every stage of the development pipeline, making systems more secure by default.