In this session, you learnt how to set up a schema and make it ripe for analysis using various DDL (Data Definition Language) and DML (Data Manipulation Language) statements in MySQL.
The DDL statements are:
- CREATE
- ALTER
- DROP
The DML statements are:
- INSERT
- UPDATE
- DELETE
- SELECT
While Data Definition Language statements are used to alter the structure of a database, Data Manipulation Language statements are used to change the data itself that is present inside the database.
So, now that you are ready to use MySQL for its primary intended purpose, that is, data analysis, it’s time to write useful queries to derive actionable insights from the ocean of data that lies in front of you.