With this course, you will learn:
- Creating, modifying and deleting tables in a database (DDL)
- Inserting, updating and deleting data from tables (DML)
- Select queries
- Aggregate functions
- Database design
- Creating databases.
Through the course you will go through creating an example database for a cinema online booking system using concepts taught in the database design section. Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material. In addition there are installation videos covering MySQL on Windows, Mac or Linux.