Using the 'restaurant' database, a considerable amount SQL commands are put into practice. This script was made just for practice purpose and is seen as a guide for the creator.
Commands and guide is from sololearn MySQL course. Also other commands are being used.
Some of the commands seen in this repository have to do with:
- Basic concepts,
- Create Read, Update, Delete (CRUD) directions,
- Like, group by, distinct, in, not in,
- Filtering,
- Functions like count, concat, sum, etc.,
- Subqueries
- JOIN, Table operations,
- Altering and dropping tables
- Rollback,
- Views, among many others.