SQL and other nonsense
- Started
- Last post
- 20 Responses
- Point5
If I wanted to learn about database shit on my own, where would I start (books, sites, etc)? And when I say "learn" I mean starting from ground zero. I have no clue what's going on with that shit, but that it would be damn helpful to have a greater knowledge about it and how it works.
- Milan0
books are the best when learning any programming/scripting language. don't bother with sites and tutorials, tons of garbage out there that will just waste your time...
Check out the books from:
http://www.wrox.comand do a search on: http://www.amazon.com
- flavorful0
Welcome to the Dark Side!
O'Reilly pwns all books.
http://www.oreilly.com/Are you looking into MySQL or MSSQL?
MySQL = PHP (Mostly)
MSSQL = ASP (Mostly)MySQL = Most hosting packages has this.
MSSQL = Few and far between as Microsoft requires licensing to run on each processor on the server, haha.
- flavorful0
O'Reilly even has this thing called "Safari" where you can read all their books online.
I have the 10 book, bookshelf.
It really is awesome, I've used it for years ...
To be honest I don't use it much as I did before, but it's a helpful resource if you're stuck on something.
And also gets all the new technology books before they come out in print.
I use it more for their non-programming books now, heh.
I'VE WROTE TOO MUCH!
- flavorful0
By helpful resource if you're stuck, I mean I pretty much am a .NET/MSSQL fucking nerd.
- Point50
flavor, you're out of control sometimes, but thorough none-the-less. I would have to say I'd be leaning more towards MySQL.
Thanks for the info guys. I'll be making some book purchases this weekend.
- mirola0
learn the three steps of normalisation, relational integrity and a couple of data types and you'll know everything you need.
- seed0
I like this book a lot as a reference:
http://www.amazon.com/Sams-Teach…I would start with mySQL and create a simple tables and output it. Then try filters, sorting, relational tables, etc.
- acescence0
if u have a mac you could install mysql:
http://www.entropy.ch/software/m…
then start up apache and play!
- seed0
For a practice environment at home xampp is really easy to install:
http://www.apachefriends.org/en/…
- moth0
Before using MySQL (a database) with the web, you first need to learn a development language to eventually interact with it. I would suggest starting here with PHP:
http://www.php.net/manual/en/int….. and ditch the books.
Read, try, and click next. Before you know it - you'll have learnt something useful.
- flavorful0
I wouldn't ditch the books, stick close with O'Reilly books and have a set project YOU want to work on to accomplish such.
That being said I learned MySQL/PHP and MSSQL/ASP without books but I do suggest them as everyone learns differently.
And we can't all be geniuses. Though we can all have different genii.
- Point50
nerds...
Thanks!
- cosmo0
fuck sql. lets just post non-sense like jaline all day. sql that is like so 300 B.C. I still use text files for data storage. psst...sql is lame.
- actual0
how about the video tutorials on lynda.com??
their other videos that i've viewed have been pretty helpful.
they have 9.5 hours on PHP?
is it any good? i've been looking to learn php/mysql as well. would this be a good route to go?
- cosmo0
If you know the basics like loops, variable declaration, etc. Tell yourself that you want to build a login system, research as much as possible and slowly work on it. That is the way I learned php/mysql, that was 5 years ago.
Don't hesitate to post on NT. moth, ascence, undoundo, heavyT are all great helps, i probably forgot to mention others.
- PhonyMcRingRing0
Webmonkey gives a nice overview of the basics of databases:
- RoomFive0
i don't have the patience to read tutorials... i learn everything through trial and error, look at some code, change the 3 to 5, chop out bits (etc), and see what happens, after awhile you figure out what everything does and you work from there...
it's a strange sense of accomplishment when it works! lol