I know SQL what database software should I learn, and how do I learn it?
489908
YOu can familiarise yourself with the free versions of DB2 and Oracle express since they are two of the most popular after SQL Server.  You should also consider the other SQL Server products such as analysis services and SSIS as there is strong demand for people who know how to use them and they have free versions you can add to your SQL Server installation.
77102
well it depends on ur envoirment. u can switch to java if u can do that easily. yes crystal report is a good an iteresting option too. oracle has the most spreading db in world u can switch to Oracle all depends on ur interests and expertiese.\nbtw im also on MS track. :) working in VB and SQL server 2000:)
294743
These sites are great learning resources.\n\n\nhttp://www.softwaretrainingtutorials.com/ms-transact-sql.php
1008850
My guess is vb.net.\nSupports .net framework. It is an evolved version of vb 6.0 (?). If you found that one interesting then you'll probably find this one more interesting too because it supports oop!\n\nJ2ee is also good. Once you learn this language you can create application that are platform indepedent.\n\nBut I guess the rational way to make a choice is to think where you want to end up working. For e.g. if you are looking to work in bank-related firms, where storage and management of large databases are a must, then oracle is good option.
527578
SQL is for big boys.\n\nAccess is like for little boys.\n\nIts like comparing linux and windows. It really depends on how comfortable you are with programming. At work, Im into JAVA and coding on window applications. Then we have the mainframe people who hate windows and codes everything in unix. \n\nSQL is sorta like mainframe programming, they are more experienced and they have to know the code.\n\nAccess is like window programming, they are not as experienced with programming and they want a windows based system to code for them.
593430
Personally I would suggest either Java or C# (C-Sharp).  Both of these languages lend themselves to very easy code and easily debugable code.  Both will easily allow you to connect to a Database and do what you need.  As far as output and looks, they're both really similar, if you choose to do a web front it you can use html and all the features of html to aide the design and output.  \n\nIf you choose C++, it will be extreemly difficult to get what you want done.  It will take far more effort to connect to a data back in C++ than it would in Java or C#. \n\nVB is very easy as well, but personally i hate it.  It is far too simple, and you loose flexability.\n\nHope this helps..
173834
Look up good books like C J Date, SQL For Smarties by Joe Celko or a site like\nhttp://www.learndatamodeling.com/
150748
Companies use Oracle more than Microsoft, although it'd be good to get some experience with SQL.  I've used both, and never seen any real huge difference between the two.  The coomands are generally the same, the logic is generally the same.
26037
In my opinion, look upto MySQL, it is the best database for your needs. Incase you have queries regarding its setup, you can lookup to the following professional forums where people discuss such problems :\n\n(1) http://forums.mysql.com/\n(2) http://forums.devshed.com/forumdisplay.php?forumid=4\n(3) http://www.ahfb2000.com/webmaster_help_desk/archive/index.php/f-47.html
996041
http://www.w3schools.com/sql/
799600
Use either Access or MySQL. 1000 records is very small, you do not need to pay the $thousands for MS SQL or Oracle. Access can definitely handle 1000 records.\n\nOne nice thing about Access is that it enables you to create forms. So people can input data using a visual form, and the data goes into the database. Also, Access offers a GUI for creating your database tables. MySQL does not offer these capabilities, but its main plus is that it is free. I would question what the other guy said about how powerful it is, though. It is definitely a lot weaker than Oracle or MS SQL, BUT for your needs it should be fine.\n\nEither Access or MySQL will work fine for Web programming too if you want to connect your db to an online Web site.
573982
MySQL is a good, free, open source database.  If you're going to go that route, you'll want to use one of these two free programs to configure and use mysql more easily.\n\nhttp://cocoamysql.sourceforge.net/\n\nhttp://yoursql.ludit.it/
723480
The main database vendors in Microsoft, Oracle and IBM all now have a free express version of the database that can be downloaded and installed on a windows desktop.  I suggest you download and try it out for yourself.  It is difficult to get an independant opinion on the difference between each database as people will prefer the ones they are familiar with.\n\nAll three database types have relational tables, a simple SQL language, common objects such as procedures, indexes and triggers.  \n\nSQL Server used to be easier to install and administer but over time the three express versions are becoming easier to run so it is hard to seperate them.
714261
A freeware version is Open Office, does the same job but its free.\nhttp://www.openoffice.org\nYou can also download the tutorial.\n\nThe trick with databases is to organise the info properly first. Think about the types of info, write it out on paper and try a few different things. Think about how people will use the database, how will they want to retrieve the info.\nSome people have a real knack for databases; it migh be best to have one or two members of staff whos job it is to build and maintain the database; and assist anyone who gets stuck.
913812
Here are some that I think might be very useful to you:\n\n- http://www.analysisandsolutions.com/code/mybasic.htm\n- http://dev.mysql.com/doc/\n- http://www.w3schools.com/sql/\n- http://www.freewebmasterhelp.com/tutorials/phpmysql/1\n- http://www.devshed.com/c/b/MySQL/\n\nOf course you can find lots others but these are the best to start learning SQL.\n\nHope this helps.
860812
when you have specific questions like that, make the search (yahoo/google) your friend.  That's how all programmers get quick information.  Do you have to use access?  SQL Server is so much easier to use and more robust.
171196
http://www.orafaq.com/\n\nhttp://www.peoplesoft.com/corp/en/public_index.jsp\n\nhttp://www.db.cs.ucdavis.edu/teaching/sqltutorial/\n\nhttp://en.wikipedia.org/wiki/Oracle_database