Databases

Integrating Web Application and Databases

Overview

A database is an organized collection of data that can be centralized and used to separate the data to be handled by an application from the code. Applications can do data modification like insert or update correctly and safely by using a database.

There are different types of databases depending on their structure and purpose of use, such as Relational Databases (RDB) and Non-Relational Databases known as NoSQL. The most commonly used type of database is the relational database. A relational database manages data in a collection of tables. A table has multiple columns for each type of data and various constraints such as primary keys and foreign keys that are set before use. The database structure and constraints are very important parts that affect the performance of the entire system.

To communicate with a database in a web application, it is necessary to write the code to operate the database in the program. For example, in a relational database, you can insert, select, update, and delete data (CRUD operations) by including a special language known as SQL in the code.

Databases

Learning Objectives

By learning about databases, you will be able to properly manage the data in your web applications.

The amount of data handled by web applications are enormous, such as user data from membership registration and product data from e-commerce sites. By using a database, it's possible to store all the related data at once and quickly search for and retrieve the desired data.

In addition, by upholding data integrity and preventing data redundancy, the database can prevent data loss and duplication due to simultaneous use by multiple users and maintain consistency. Data encryption can be applied to improve security, and backup functions ensure data integrity.

With the recent web application frameworks, it's possible to implement them with an O/R mapper without directly using SQL. However, since SQL is running inside this mapper, it will be necessary to learn SQL to achieve efficient data access.

Learn about databases in order to create full-fledged services.

Learn from Here

A good place to start learning about databases is with relational databases, which are widely used today. First, let's learn about SQL to manipulate relational databases.

  • Getting Data from SQL

    Understand Types and Purposes of Databases

    Get Data using SELECT

    Use WHERE to Get Specific Data

    Data Sorting

    Use Aggregate Functions

    Group the Data

    Create a Subquery

    Join Multiple Tables with JOIN

    Analyze the Database of a Fashion Website

  • Modifying Data in SQL

    Add Data with INSERT

    Update Data with UPDATE

    Delete Data with DELETE

Recommended Materials

  1. SQL Study I | Progate

Share what you learn today!