Database
By screamkevin
@screamkevin (82)
Philippines
3 responses
@votenoonpineapple (235)
• Canada
13 Mar 09
What sort of database were you using? MySQL, Microsoft SQL, etc? Were you accessing the database from your web site scripts, or from your computer?
@votenoonpineapple (235)
• Canada
14 Mar 09
Sorry about the wait.
If you go to tutorialspoint.com/mysql/mysql-useful-functions.html, there are some good examples of scripting there. You would use the SQL scripting by embedding within a PHP page, for example, with your MySQL database.
Assuming your connecting to a database that comes with your web site, and is not hosted on your own servers, it is also good practice to install an application, just to get in the swing of things. For a Linux site, some good ones are WordPress, CubeCart, etc. They're all free, and can be installed by uploading to your web site using FTP, and then following their directions. They'll generally need your MySQL connection settings, which your web hosting provider will be able to provide you with.
Once the application is installed, you would also be able to look at the scripting behind varios web pages to see working examples of how to connect to your own database and perform certain funtions.
w3schools.com/sql/ also has some great examples of SQL scripting and learning by example / tests. They'll let you try out some scripting, and show you the results, and whether it's working. W3Schools will also have tutorials on how to embed SQL in to your pages, such as in to a PHP page, etc.
functionx.com/sqlserver/ has some great MS SQL tutorials. Under the SQL Operations, you can view examples of basic functions, which you could basically copy and paste and then use to fill in your own info. There's some examples of built in functions, keywords, and expression examples too.
@votenoonpineapple (235)
• Canada
14 Mar 09
If you're looking for something a bit more specific, let me know, and I'll see what I can do.
@harvey007 (2)
• United States
15 May 09
http://idealprogrammer.com - has over 400 hours of free video tutorials on sql server, asp.net, c#, vb.net and more. Check it out.
@sudhajosyula50 (3808)
• India
7 Apr 09
There are different types of database in this world.Please mention about the database which you want to learn.Depending upon it anyone can suggest that particular sites.As a beginner i think it is better to go for www.w3schools.com site.