Where you can practice exercises about MySQL, helping you to deepen your knowledge of MySQL. Some knowledge you can learn from me from the basics such as creating data tables, relationships between them, using MySQL Workbench to create databases without having to code, simple queries ... then you can learn advanced lessons such as creating tables with code, performing complex queries between tables, optimizing queries to improve your application performance. Hope it will be useful for you.
Important
Follow me here My progress and do the exercises in order.
- Basic overview of SQL: ER diagrams, entities, attributes, constraints, relationships between entities ...
- Install MySQL Workbench software, download here MySQL Community Downloads
- Basic use of tools to build databases such as: MySQL Workbench, draw.io
How to install:
git clone https://github.com/anhhducnguyen/MySQL
cd MySQLSession 1: MySQL database management system
Session 2: Database design
Session 3: DML statements and queries
Session 4: Advanced queries
Session 5: View - Index
Session 6: Procedure
Session 7:Trigger
Session 8: Transaction
Details are available at Database programming framework