| Author |
Topic |
|
princeofbmore
Starting Member
3 Posts |
 Posted - 2005-12-08 : 13:05:42
|
| Hey,I had classes in school, Cold Fusion, Access, et cetera ... the last year I've been doing a lot of front end stuff, Flash intros, banner ads, landing pages...I want to get back into SQL where do I start? I know HTML, a little PHP, ***I would like to learn by hand coding, no editors, any suggestions?I want to be able to build a shopping cart & a site that sells sneakers, or something similar ...content management system... anyone interested in being my mentor?I can build the site no problem but I do not understand how to call / pull data and create the databaseLet me know, in the meantime I'm reading PHP & MySQL for beginners thankshouston !! |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-08 : 13:54:58
|
| This forum is for MS SQL Server, you can learn php and mysql at www.mysql.org or www.php.net to understand database more, i advice you get a book on dynamic web pages.For Microsoft you could learn either ASP/MS SQL, ASP/ACCESSor .net/MS SQLpoints to look out for1. front end apps. in this case, ASP OR .NET2. database connection see sample here www.connectionstrings.com3. database queries (if you have a distributed tier architecture)ie writing commands, using stored proceedures .My sql hasnt got this4. your database (admin, mgt, backup, security etc)SQL Server is the way to goafrika |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-08 : 14:49:24
|
The new version of mysql has stored procedures.  I would buy books from Ken Henderson. Also, but "Inside SQL Server" from Kaylen Delaney so you understand what's happening behind the scenes. You also need to buy some books on database design and theory. Read the articles on this website and www.sql-server-performance.com.Right now, MS has tons of free training on SQL Server 2005 if you go to the SQL Server website. There are webcasts, online classes, virtual labs, etc. Take advantage of those.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
princeofbmore
Starting Member
3 Posts |
Posted - 2005-12-08 : 15:28:28
|
| Whats the difference between My SQL and SQL? Where does Microsoft Access tie in to all of this? |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2005-12-08 : 15:41:50
|
| Hi,First u have to have a clear idea of the tools / languages needed for ur task.MySQL is a free of charge DatabaseSQL is the Structured Query Language, which is the standard language, used to communicate with all Databases (with some minor changes for some)MS SQL Server is a Database Server developeded by Microsoft, somewhat similar to MySQL but has lot more features, flexibility.First comeup with ur particular need. I think this forum is mainly for those who work on MS SQL Server in particular and if u want to know about other stuff like MySQL or PHP etc. u have to find such a forum. Some were suggested by the ealier answer. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-08 : 15:59:34
|
| www.dbforums will cover all the other products. You can use Google and search for things like "compare SQL Server mysql". SQL Server has a free version of the software also. As Srinika said, MS SQL Server has far more features and will scale much better than mySQL. mySQL is open source and free if you use the "non enterprise support" version. MS Access doesn't tie into this. It's not a real database. It's a toy. It can be used for some good, quick technology needs though or to prototype something out real quick sometimes.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-09 : 00:52:39
|
| >>Whats the difference between My SQL and SQL? Where does Microsoft Access tie in to all of this?This is not the specific question. Google search may help you MadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-09 : 03:46:34
|
quote:
Originally posted by derrickleggett
The new version of mysql has stored procedures. I would buy books from Ken Henderson. Also, but "Inside SQL Server" from Kaylen Delaney so you understand what's happening behind the scenes. You also need to buy some books on database design and theory. Read the articles on this website and www.sql-server-performance.com.Right now, MS has tons of free training on SQL Server 2005 if you go to the SQL Server website. There are webcasts, online classes, virtual labs, etc. Take advantage of those.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
yes i heard version 5 of MySQL has SP. But is this out and tested against bugs ? basically princeofbmore, you need to understand a few thingsthere are many database flavours by different vendors1. MS SQL as you know by now is by microsoft2. oracle by oracle corp3. MySQL is a free open source db, owned by nobody and anybody can join to add to the source codes by simply joining the mysql.org groupothers abound e.g. informix, sybase, db2, teradata etcthese are all roboust relational database management systems, (RDBMS).access is a file database, and cannot scale.SQL - is the language all SQL complaint databases speak  when you create a dynamic website like yahoo or this site sqlteam when users login and see their profile its just gotten from a database of some sort. Do you understand ?its up to you to choose what you are comfortable with and the way you want to gohope this helps |
|
|
|
princeofbmore
Starting Member
3 Posts |
Posted - 2005-12-10 : 08:29:33
|
| Thanks Afrika your the only one that really understands my question thus far. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-10 : 12:49:43
|
| Then, you aren't stating your question clearly. I have given you all kinds of information about where you can go to learn the EXACT questions you asked. Stop being lazy and check the websites out. If you are interested in learning correctly, then get some motivation and learn. That's what most of us did on here. The microsoft web site has tons of free training material right now that will show you how to "hardcode". You can look at www.asp.net and tons of other sites for fully functional sites, applications, and tutorials that will teach you as well. Buy the books I told you about. Look at the websites. Learn. Also, learn how to use honey instead of vinegar when you are wanting help. Part of being a good architect, designer, or developer is learning to communicate and listen. If you don't have that, you shouldn't get into the business. Most of the waste and "IT drain" in the industry comes from people who want to do something kewl and don't ever take the the time to shutup and listen or learn good communication skills.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-10 : 14:32:02
|
| Ouch !!! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-12-10 : 15:47:26
|
| Not ouch, fair. |
|
|
|
|
gotta question somewhat new to SQL