What are the fundamental concepts of MariaDB, such as tables, indexes, and data types, and how do SQL commands and query optimization techniques enable efficient data storage, retrieval, and manipulation in a relational database management system?