Delve into web development fundamentals, exploring HTML, CSS, JavaScript, and version control. Gain insights into essential web technologies to confidently pursue further learning and projects.

node_setup.tar.gz

RunLiveVM

If you're interested in getting into web development, this course is the perfect place to start -- whether you're a high-schooler looking to learn a new skill, or an entrepreneur who wants to build their own website. The course encompasses everything from the basics of networks to the principles of front-end web development with HTML, CSS, and JavaScript. 

After taking this course, not only will you be comfortable learning any web technology, but you'll also have a better idea of what different technologies are out there and what you'll want to learn. You'll also become familiar with version control systems, which are a global industry standard.

Web Development: A Primer

In the previous lesson, we discussed the role of database management systems in web development and learned that one type of DBMS is SQL. Now, we will discuss popular SQL Database Management Systems that are available to use in web development.

# MySQL

[MySQL](https://www.mysql.com) is amongst the most commonly used database management systems, and it has formed an integral part of most web applications in the past. MySQL is backed by Oracle and uses Standard Query Language (SQL) to store data in the form of a table, and to retrieve data requires making queries in SQL. MySQL, unlike SQL itself, works across all platforms, including Linux, iOS, and Windows and it has all the simplicity of SQL as it does not require any new syntax to be learned once you know SQL. Let's look at an example of a MySQL query that creates a new table: 



CREATE TABLE [IF NOT EXISTS] table_name(
    column1 DATATYPE,
    column2 DATATYPE,
    column3 DATATYPE,
    column4 DATATYPE,
    PRIMARY KEY (column1)
) ENGINE=storage_engine

As is clear from the example above, MySQL uses basic SQL queries to create tables and handle data. This is one of its primary advantages as SQL is not difficult to learn and highly ubiquitous, which means that MySQL is relatively easy to use for most beginners who already know SQL.

# PostgreSQL
[PostgreSQL](https://www.postgresql.org), also known as Postgres, is an open-source object-relational database management system that can handle large amounts of data and can provide seamless support for web applications that handle multiple concurrent users. It is the default database for macOS and provides efficient data management across platforms. Moreover, it also supports concurrent database accesses and allows users to add custom functions developed using several programming languages, including C, C++, and Java.

In addition to this, another primary benefit of PostgreSQL is that it is designed to be extensible. This means that users can define their own data types and even custom plugins to alter parts of the system according to their requirements.

# MariaDB
[MariaDB](https://mariadb.org) is a fork of MySQL, which was created by the original developers of MySQL after MySQL's acquisition. It is meant to be a replacement of MySQL and includes a wide selection of storage engines so it can easily work with data from other relational data management systems. MariaDB, like MySQL, uses a standard querying language, which makes it just as simple to use as MySQL. Moreover, MariaDB runs on a number of operating systems and supports a wide variety of programming languages. In particular, it offers support for PHP, which, as we will later learn, is one of the most popular web development languages.

In addition to having all the benefits that MySQL poses, MariaDB also offers many operations and commands that are not available in MySQL and replaces features that tend to impact performance negatively.


 

An overview of the most common relational database management system.

Introduction

Networks

Databases

The Front End

The Back End

Web Development Frameworks

Version Control with Git

Principles of Software Engineering

Conclusion

SQL Databases

MySQL #