2

I'm going to teach several persons mysql. I have the plan of that "course" the problem is that I do not have test DB to work in. A copy of any db from a large application will be hard to start with. IMHO something of 5-6 tables will be ok. Maybe someone knows where is it possible to get such a DB? And another question is: can someone give a link to a list of tasks on stored procedures?

Thank you in advance!

2
  • 1
    Sakila Test Database (dev.mysql.com/doc/sakila/en) Commented Feb 24, 2017 at 8:49
  • @GopeshSharma thank you! And have you any idea of a list of tasks to master stored procedures Commented Feb 24, 2017 at 11:23

1 Answer 1

3

Here are some test databases to work with

https://dev.mysql.com/doc/index-other.html

Sign up to request clarification or add additional context in comments.

3 Comments

the employee database should suit your needs, if it is the one I have in mind
@midor yes, it's really what I need. Maybe there's a list of tasks (on complex joins and stored procedures) somewhere over there?
I think the mysql reference manual uses these databases, so I would just look at their examples in the DDL/DML syntax section e.g.: dev.mysql.com/doc/refman/5.7/en/join.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.