This post is how the database born in small business, today is impossible managed big data whit simple SQL Basic , this information and database is the year 2007
SQL is common find stores procedures https://en.wikipedia.org/wiki/Stored_procedure
http://docs.openlinksw.com/virtuoso/ch-sqlprocedures/
for check proc i find this query
A small database (<10 GB) is possible work whit SQLEXPRES, this is a database
https://www.dropbox.com/preview/Public%20(1)/SCPV170520101632.bak?role=personal
Whit a POS installer , only modify the SYSDBINFO, and creatre a login for user psa.
https://www.dropbox.com/preview/Public%20(1)/INSTALADOR%20SISTEMA%20TIENDA.zip?role=personal
Another project to practice in MySQL is http://blog.xcero.xyz/site/
Is a Online Store , this connection if in PHP and try to practice how to show item description and price