Home » questions » SQL-plus database?????

SQL-plus database?????

2
2006-08-19 06:25:16, Category: Programming & Design
i am looking for some SQL projects,, that are resolved already. i need them to practice SQL. i am a student in UK. please let me know if someone know anything about getting these resolved projects and scripts.

Answers

  1. sheeple_rancher

    On 2006-08-19 08:39:45


    Most of the database makers have example projects on their sites with create scripts, usage examples and sample data. Most will use the database with other stuff (java, c++, php, etc) but some will be pure sql. Unless they get into the edges of SQL and use company-specific variations, most should work on any modern sql database server. Starter - http://dev.mysql.com/doc/ and scroll down to 'Example Databases'.

  2. nwohiosteve

    On 2006-08-19 07:07:24


    If you're looking for something to experiment with in SQL, I recommend using MySQL. It's free. There is a drop in application framework called InstantRails that includes a fully functional MySQL application. Here's all you do... Download InstantRails from here... http://rubyforge.org/frs/download.php/9957/InstantRails-1.3a-win.zip and unzip the entire fileset into some directory. Create a shortcut from the program InstantRails.exe to your desktop or somewhere. Open it. You will see the control panel and MySQL will show "Started". Click the " I " icon just left of the Apache button. Choose "Rails Applications / Open Ruby Console Window" Type "mysql -u root" This will put you at the mysql> prompt. You can then experiment with MySQL. " show databases; " will show the current databases " use cookbook " will select the cookbook database " show tables; " will show the cookbook database tables " select * from categories; " will display all the categories in the cookbook categories table Then go to http://mysql.com/doc/refman/5.0/en/tutorial.html to read a tutorial. Go to: http://mysql.com/doc/refman/5.0/en/index.html to read or download the reference manual. Have fun!