Sql - Wth!?

Makeuptalk.com forums

Help Support Makeuptalk.com forums:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
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!

 
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.

 
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!





 
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
icon_redface.gif





 
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
icon_redface.gif
I am glad that I wasn't the only one confused.
Tony- is it hard to learn?

 
Originally Posted by Tony(admin) Yep lol How would I go about it? Community college or books?
 
Marisol, may be they just did what you did
wink.gif


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!

 
Originally Posted by lilla Marisol, may be they just did what you did
wink.gif
Maybe...
icon_biggrin.gif
 
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
wink.gif
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

Back
Top