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.
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.
Content
MariaDB Setup
Performing CRUD OPerations