• Post category:StudyBullet-13
  • Reading time:5 mins read


Learn Fundamentals of MariaDB Step-by-Step : Perform CRUD Operations

What you will learn

Install and configure MariaDB on a local machine or server.

Understand database concepts

Perform CRUD Operations

Create new database tables

Insert and retrieve data

Understand Data Types in MariaDB

Understand and use SQL commands, such as SELECT, INSERT, UPDATE, DELETE

Filter data using WHERE clauses and comparison operators.

Sort data using ORDER BY clauses.

Description

MariaDB is a relational database management system (RDBMS) that stores data in tables with columns and rows.

MariaDB was originally created in 2009 as a fork of MySQL, after concerns arose about its acquisition by Oracle Corporation. MariaDB is led by the original developers of MySQL, and it has since become a fully community-driven open-source project that is governed by the MariaDB Foundation. The project has grown in popularity over the years, and it is now used by many large organizations, including Google, Wikipedia, and Red Hat.

One of the advantages of using MariaDB is its compatibility with MySQL. It supports many of the same SQL commands and syntax as MySQL, which means that existing applications and code written for MySQL can often be easily ported to MariaDB without major modifications. Additionally, MariaDB has continued to innovate and introduce new features that have been well-received by the developer community, such as support for NoSQL data storage and distributed SQL.


Get Instant Notification of New Courses on our Telegram channel.


Overall, MariaDB is a powerful, flexible, and feature-rich database management system that is well-suited for a wide range of applications and use cases. Whether you’re a developer looking to build web applications or a business owner looking for a reliable and scalable database solution, MariaDB is definitely worth considering.

What you will learn includes:

  • Understanding database concepts
  • Performing CRUD Operations
  • InstallingΒ  and configuring MariaDB on a local machine or server.
  • creating a new database tables
  • Inserting and retrieving data
  • Understanding Data Types in MariaDB
  • Understand and use SQL commands, such as SELECT, INSERT, UPDATE, DELETE
  • Filter data using WHERE clauses and comparison operators.
  • Sort data using ORDER BY clauses.
English
language

Content

MariaDB Setup

Introduction
What is MariaDB
Download and Install MariaDB
Download and install MariaDB Management Tool
Download sample database
MariaDB Data Types
Basic Database Concepts
What is a Schema
Relationship between MariaDB & MySQL

Performing CRUD OPerations

What is CRUD
Creating CRUD Operations
Inserting data into database
Retrieving and reading data from database
Updating data inside database
Deleting data inside database
Truncating a table
Dropping a table
Removing Duplicates
Sorting data
Using Aliases
Retrieving data with AND |OR Operator