SQL-Plus Database?????
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.
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!
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!
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'.
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'.
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!
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!