bbala Posted February 3, 2011 Share Posted February 3, 2011 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 More sharing options...
birbal Posted February 3, 2011 Share Posted February 3, 2011 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 More sharing options...
bbala Posted February 3, 2011 Author Share Posted February 3, 2011 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 More sharing options...
birbal Posted February 3, 2011 Share Posted February 3, 2011 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.