Jump to content

A sample mysql database for learning?


bbala
 Share

Recommended Posts

Hi, I want some sql file like pubs2 database of sybase with excersises to try out.Mainly to demonstrate/learn the use of joins, normalisation, basic select, update, insert queries, keys etc,Thanks,

Link to comment
Share on other sites

i am not sure what do you mean by pubs2 database..why you want the pubs 2 databse..you can always create a one and can practise on your own..if you have mysql installed.if you want to practise sql i think you should use mysql command line instead of phpmyadmin.

Link to comment
Share on other sites

pubs2 is just a sample database. The advantage is it has lots of tables created already. So you can directly start trying select statements, joins etc. Its also helps to understand various normal forms of database.http://infocenter.sybase.com/help/index.js...ug/sqlug894.htm

i am not sure what do you mean by pubs2 database..why you want the pubs 2 databse..you can always create a one and can practise on your own..if you have mysql installed.if you want to practise sql i think you should use mysql command line instead of phpmyadmin.
Link to comment
Share on other sites

though i did not use this type of db yet..as far i am getting it will cover the DQL part..but i think if you want to practise all DDL,DCL,DML you may like to do it by creating your own..once you create db and table..and dumping some data on it..you can start practising...once your tables are populated you dont need to do much...you can practise queries on it after that.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...