Creating and Setting Up a Web Server

Name: Creating and Setting Up a Web Server
Rating: 4.1 (44 reviews)

Learn how to set up a web server from scratch by configuring a linux system to act as a web server

Created bymohamad gharishvandi

Last updated 4/2025

English

English [Auto],

What you'll learn

how to set up a web server
how to create a web site
sql injection
prepared statements
how to create a database in mysql
mysql in cli
how to create a website in linux
how to install mysql in linux

Course content

2 sections • 24 lectures • 1h 58m total length

what is html3:18
Html creates web page content using tags like h1 and a, and the browser translates these tags into visible content with href links.
what is css3:15
Learn how css modifies html content visuals by using inline styles to apply color, width, height, borders, and border radius to create shapes, and preview changes with browser dev tools.
javascript and its use6:42
demonstrates turning static web pages into dynamic interactions with JavaScript, using a button and event listeners to change element styles and links, and cautions about potential misuse by hackers.
client-server communications1:22
Demonstrate client-server communications, showing how clients initiate requests, servers reply with responses, and how DNS resolves names to IP addresses for seamless connectivity.
protocols3:22
Explore how protocols govern client–server communication, including the three-way handshake for tcp connections and data retrieval over http or https, with the browser rendering the page.
apache1:59
Understand how clients and servers communicate over the web using the HTTP protocol, with Apache as a key web server implementation.
buying a vps2:02
Explore how to set up a web server with Apache, and compare hosting on your computer versus renting a VPS from data centers, focusing on security and scalability.
what are databases2:57
Learn how web servers store and organize user data with databases, using tables in mysql, and how html and javascript enable content and interaction on websites.
server side programming languages3:28
Explore how the browser (client) communicates with a web server over http, with encryption protecting data, and how server-side languages like PSP and Python power web applications.
set up a web server4:14
Acquire or lease a web server or VPS, assign a domain name to its IP via DNS mapping, and securely access the remote Linux server with SSH on port 22.
connecting to web server using ssh7:09
Connect to a web server via ssh, verify Apache on Debian 10, and manage /var/www to serve index.html while creating new html pages linked for a browser-accessible site.

installing mysql server on our linux server7:34
Connect from Windows to a remote Linux server and install MySQL server. Use apt-get, apt-cache, and dpkg to install, update repositories, and troubleshoot MySQL 5.7 installation.
creating tables in mysql cli in linux server4:42
Learn to create a database and a staff table using the MySQL CLI on a Linux server, and add columns such as user_id, email, and password.
inserting and selecting data into database2:10
Insert data into the staff table with name and email values, then retrieve records using select queries. Retrieve by user_id to view specific columns such as email.
updating the mysql databases in cli5:37
update a MySQL database from the command line by adding a security column to staff, updating emails and passwords, and validating changes with describe and select queries.
creating a form in our web site to connect to database7:53
Create a web form on a web server to connect to a database by building an HTML login form with email and password fields, a submit button, and basic styling.
installing php on our server6:19
Install php on the server, enable its server-side execution, rename files to .php, and test with echo to verify php runs through the Apache configuration.
enabling php in apache4:36
Enable php in apache by running two commands to install apache and a module, configure mod_php for the current version, and run server-side code in the browser.
enabling mysql in php4:32
Enable MySQL in PHP and connect to the test database by configuring host, port, and database name, then troubleshoot browser and server connections and install the MySQL extension.
connecting to database in mysql php8:57
Learn to connect a php web form to a MySQL database, verify user credentials by querying the staff table for email and password, and retrieve the security number.
retrieving data from database in mysql php5:54
Retrieve data from a mysql database with php, store the query, fetch results as an associative array for login validation, and guard against injection with prepared statements.
sending data to database in the web page5:38
Learn how a web page sends input to a database on a web server, identify a SQL injection vulnerability, and discuss responsible exploitation and patching.
sql injection5:15
Demonstrates how unsafely handling user input in a login form enables SQL injection with single quotes, turning the query into a tautology and exposing security numbers from the database.
prepared statements9:36
Discover how prepared statements secure a web server by binding user input to query parameters, preventing sql injection, and securely executing queries against a database.

Requirements

there is no requirement for this course

Description

the initial goal of this course was to learn about database, how to use them for our web site, how to attack them using concepts like sql injection and how to patch the vulnerabilities resulting in sql injection using prepared statements, but in order for us to do that, we start by creating a website from scratch by buying a virtual private server (vps) with the linux as its operating system , which would result to teach some other concepts along the way.

so as we along you would be familiar with almost everything you need to create website from scratch , concepts that you usually take for granted, for example we learn html,css and javascript abstracts, that what these things are , and why you need them, also we will talk about linux and some important commands. and at last you learn about sql injection, that why such an attack exists , so that you could better understand how to exploit or patch it by yourself and not using any third party applications.

so after this you could just set up your own web server, and even use your own computer for that purpose even though we talk about why this is not recommended, also you learn how to buy vps and create your website vulnerable to sql injection and then patch it using prepared statements.

Who this course is for:

web developers
security pentesters

Creating and Setting Up a Web Server

What you'll learn

Explore related topics

Course content

setting up a web server in linux11 lectures • 40min

mysql databases, sql injection and prepared statements13 lectures • 1hr 19min

Requirements

Description

Who this course is for: