Quantcast

Sql - Wth!?

Makeuptalk.com - Makeup forums and reviews

Help Support Makeuptalk.com - Makeup forums and reviews:

Joined
Feb 12, 2005
Messages
28,176
Reaction score
3
Does anyone here (I am hoping girl_geek will see this) know that SQL is? I have tried researching this and its too confusing. One of the things I recently learned for work is how to do programming and the instructor said that we were using some SQL language. HUH!?!?? Everyone in class knew what she was talking about so I didn't ask. I should have and now I am wondering what it means. Can someone please explain it to me in a way that I will understand?

TIA!

 

Liz

Joined
Feb 27, 2005
Messages
9,784
Reaction score
2
all i know is that it's some sort of computer programming language. my bf has a ton of comp books, and those are some of them.

 
Joined
Oct 22, 2003
Messages
22,667
Reaction score
441
Location
Huntington Beach, CA
SQL is an ANSI standard computer language for accessing and manipulating databases

Some Databases are MySQL, Oracle, DB2, Sybase, Informix, Microsoft SQL Server, Microsoft Access, and other database systems.

MuT runs on MySQL





Originally Posted by Marisol

Does anyone here (I am hoping girl_geek will see this) know that SQL is? I have tried researching this and its too confusing. One of the things I recently learned for work is how to do programming and the instructor said that we were using some SQL language. HUH!?!?? Everyone in class knew what she was talking about so I didn't ask. I should have and now I am wondering what it means. Can someone please explain it to me in a way that I will understand?
TIA!





 
Joined
Oct 22, 2003
Messages
22,667
Reaction score
441
Location
Huntington Beach, CA
hehe. Basically SQL is a generic word for database manipulation...





Originally Posted by charms23

Wow, Tony, that made it so much clearer...LOL! It's all a bunch of words that I don't understand





 
Joined
Feb 12, 2005
Messages
28,176
Reaction score
3
Originally Posted by charms23 Wow, Tony, that made it so much clearer...LOL! It's all a bunch of words that I don't understand
I am glad that I wasn't the only one confused.
Tony- is it hard to learn?

 
Joined
Feb 12, 2005
Messages
28,176
Reaction score
3
Originally Posted by Tony(admin) Yep lol How would I go about it? Community college or books?
 
Joined
Feb 16, 2005
Messages
5,115
Reaction score
0
Marisol, may be they just did what you did


Originally Posted by Marisol Does anyone here (I am hoping girl_geek will see this) know that SQL is? I have tried researching this and its too confusing. One of the things I recently learned for work is how to do programming and the instructor said that we were using some SQL language. HUH!?!?? Everyone in class knew what she was talking about so I didn't ask. I should have and now I am wondering what it means. Can someone please explain it to me in a way that I will understand?
TIA!

 
Joined
Feb 12, 2005
Messages
28,176
Reaction score
3
Originally Posted by lilla Marisol, may be they just did what you did
Maybe...
 
Joined
Feb 10, 2004
Messages
4,603
Reaction score
1
Tony explained what SQL is as well as I could have. I've used SQL in a few database classes but I'm still not an expert at it, I just know the basics. (In the database class I'm taking this semester, we had to write the code to create our own [simulated] databases, rather than just querying an existing database!)

Most of the time you'll use SQL to query (search) and update a database, although you can use to create whole databases and do all sorts of fun stuff like that. If you are already a little familiar with databases (like if you've ever used Microsoft Access) that will help, but if you understand what fields, records, tables, and data types are you should be fine. Depending on how in-depth SQL code you will be writing, you may need to understand the basics of relational databases (like what keys and foreign keys are) since that's what most databases are. There's a lot of SQL tutorials available online and lots of books you can buy; here are a few tutorials I found from a Google search (keep in mind there are subtle differences in SQL depending on what database you are using, like if you're using MS Access, Oracle, or IBM DB2):

http://www.sqlcourse.com/ (This looks like a good one, you can even run your own SQL code and see what happens!)

http://www.w3schools.com/sql/default.asp

http://www.1keydata.com/sql/sql.html (Contains a list of common commands in the blue side bar)

Also it's possible that not everyone there knew SQL unless they are all CS (Computer Science) majors or something. One thing I've noticed (that is especially common among freshman CS majors) is that CS people don't like to admit how much they don't know; they'd rather rattle on about what little they do know in an attempt to make themselves look smarter
My first semester as a CS major, I was really nervous because I'd never programmed before and all the guys in the class kept talking about computer stuff that I didn't know about, but when I started getting the high scores on the tests I learned that they were just all talk! lol

Good luck with your research!

 

Latest posts

Top