Project 1999

Go Back   Project 1999 > General Community > Off Topic

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 07-17-2013, 10:44 PM
Knuckle Knuckle is offline
Planar Protector

Knuckle's Avatar

Join Date: Dec 2010
Posts: 3,850
Send a message via AIM to Knuckle
Default @ owl_root_naez_slangnandbangin

Trying to learn SQL with ultimate goal of being a database admin with pretty much zero coding experience (took introduction to java websphere and C++ basics in college 5 years ago). If I have the option for paid tuition while working fulltime, is it worth taking Uni classes or could I learn specific languages/books and save myself some time?

edit: basically wanting to learn SQL in my freetime and trying to find a good place to 'start'.
  #2  
Old 07-17-2013, 11:34 PM
Nirgon Nirgon is offline
Banned


Join Date: Jun 2011
Location: Ruins of Old Paineel
Posts: 14,480
Default

^ lul
  #3  
Old 07-18-2013, 12:25 AM
Knuckle Knuckle is offline
Planar Protector

Knuckle's Avatar

Join Date: Dec 2010
Posts: 3,850
Send a message via AIM to Knuckle
Default

Quote:
Originally Posted by p-niner [You must be logged in to view images. Log in or Register.]
but u should be playing in ur guild on red99 and not learning shit in RL da fuq wrong w u
oracle leads to MYSQL which is what google is using right?
I am a complete newbie and when I was reading some information on Microsoft SQL Server 2012 someone or something referenced back to learning Python(???).

I know naez knows python language.

I feel a bit overwhelmed with the different specializations for SQL, I understand that there's much more roles involved in SQL DBA then simply knowing SQL code, but I also am curious if the microsoft SQL server code is more commonly used than MYSQL
  #4  
Old 07-18-2013, 12:34 AM
r00t r00t is offline
Sarnak


Join Date: Jun 2013
Posts: 330
Default

SQL is easy to learn, and there's lots of tutorials online but I've known it for years so don't know any good recent ones. Getting queries (especially lots of joins, and table structures) 'right' and optimized is the difficult part people get paid the big bucks for. I took some database classes in college but it was more like pointless implementation details (unless writing your own db server like mysql)... they kind of expected you to know SQL already, so not sure if it would really help you just bs your way in.

You can interface with Microsoft SQL server very very easily from C# (easier to learn than Python with your Java background). PHP/MySQL also pretty easy.

I think MySQL is probably the most common db used as it powers most websites. Then for most anything else probably MSSQL or Oracle. Most of SQL is ANSI standard across all of the different types of servers though, there's just very minor differences.

I think you should come up with some real world ideas you could practice making tables for and running queries on. Something maybe like a school. Have teachers belong to departments and classes, and have students able to enroll in them, things like that. Learn about foreign keys and all the different relations (one to one, one to many, many to many). You could probably come up with like 6 or so tables, easily more. Did work for a swedish airport once that took about 2 months just to gather info on and was ~80 tables for all the flights/connections/client/pilots&controllers/planes/etc details. Try to come up with other types of ideas too and figure out what all tables you'd need to store the data.


Oh you asked what Google is using. Probably everything imaginable, depending on the project. They even have their own db implementations called BigTable and I think there's another one. They're fast for lookups but uber slow to write to (also dont support joins at least last time I played with it), which is why when doin SEO it takes awhile to get 'indexed' (gotta wait for the server farm).
Last edited by r00t; 07-18-2013 at 02:36 PM..
  #5  
Old 07-18-2013, 12:36 AM
Sirken Sirken is offline
VIP / Contributor

Sirken's Avatar

Join Date: Feb 2010
Posts: 15,822
Default

Quote:
Originally Posted by Knuckle [You must be logged in to view images. Log in or Register.]
Trying to learn SQL with ultimate goal of being a database admin with pretty much zero coding experience (took introduction to java websphere and C++ basics in college 5 years ago). If I have the option for paid tuition while working fulltime, is it worth taking Uni classes or could I learn specific languages/books and save myself some time?

edit: basically wanting to learn SQL in my freetime and trying to find a good place to 'start'.
PM sent
__________________
Ever wonder what Braknar does around here? - https://youtu.be/WTtFXBgggpI

Sirken's Twitch Stream - www.twitch.tv/sirken_

Quote:
Originally Posted by Uthgaard View Post
Accusing me of simultaneous favoritism for two opposing guilds involves a special kind of stupid
Quote:
Originally Posted by karsten View Post
going after sirken is like going to a cheerleader convention and punching the only one that bothered to talk to you
Quote:
Originally Posted by Rogean View Post
I've met Sirken IRL.. he ain't jelly of shit

  #6  
Old 07-18-2013, 08:57 PM
Knuckle Knuckle is offline
Planar Protector

Knuckle's Avatar

Join Date: Dec 2010
Posts: 3,850
Send a message via AIM to Knuckle
Default

Good info everyone, my understanding is I can just jump right in and learn SQL by itself with little IT background, I'm hoping to get some networking going on with folks in the business before taking UNI classes.
  #7  
Old 07-18-2013, 09:55 PM
Malice_Mizer Malice_Mizer is offline
Aviak

Malice_Mizer's Avatar

Join Date: Jun 2013
Location: ATL
Posts: 61
Default

Quote:
Originally Posted by Knuckle [You must be logged in to view images. Log in or Register.]
Good info everyone, my understanding is I can just jump right in and learn SQL by itself with little IT background, I'm hoping to get some networking going on with folks in the business before taking UNI classes.
With a face like that you should have no problems.
Closed Thread


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 02:56 PM.


Everquest is a registered trademark of Daybreak Game Company LLC.
Project 1999 is not associated or affiliated in any way with Daybreak Game Company LLC.
Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.