A collection of SQL commands known as the Data Manipulation Language (DML) are used to interact with and alter data kept in relational databases. Users can enter new data, update records that already exist,

Strong features from MySQL, such as views, subqueries, GROUP BY, and DELETE, all help to make database administration effective and adaptable. Subqueries improve the readability and structure of queries,

Entity-relationship diagrams (ERD) and other data modeling principles define the logical architecture of a database by methodically organizing and representing data items, their properties, and the

In my database management course, I learned about various types of database management systems (DBMSs), their components, database design, queries, and transactions. Database design is crucial for maintaining