| Posted By |
Message |
| Pages: [1] 2 |
bonch20
LIF Adult
Member since 9/09 1290 total posts
Name:
Bonnie
|
MySQL
anyone know anything about MySQL databases? trying to find a course....not something online, i think i need hands-on.
thanks!
|
Posted 7/20/10 2:46 PM  |
| |
|
Long Island Weddings
Long Island's Largest Bridal Resource |
Blazesyth
*yawn*
Member since 5/05 8129 total posts
Name:
|
Re: MySQL
Try Learning Tree or New Horizons.
|
| Posted 7/20/10 2:59 PM |
| |
|
bonch20
LIF Adult
Member since 9/09 1290 total posts
Name:
Bonnie
|
Re: MySQL
oh bless you....thanks much!!
|
| Posted 7/20/10 3:16 PM |
| |
|
Andrewz00
Look! I changed it!
Member since 4/10 1789 total posts
Name:
Andrew
|
Re: MySQL
Posted by Blazesyth
Try Learning Tree or New Horizons.
+1 for new horizons... we always send new hires there!
|
| Posted 7/20/10 3:37 PM |
| |
|
luvsun27
Check out my cool glasses
Member since 5/05 8135 total posts
Name:
Kim
|
Re: MySQL
I have never taken a course, I have learned myself through trial/error and google is your friend 
|
| Posted 7/20/10 3:57 PM |
| |
|
Andrewz00
Look! I changed it!
Member since 4/10 1789 total posts
Name:
Andrew
|
Re: MySQL
Posted by luvsun27
I have never taken a course, I have learned myself through trial/error and google is your friend
you know SQL???
|
| Posted 7/20/10 3:58 PM |
| |
|
luvsun27
Check out my cool glasses
Member since 5/05 8135 total posts
Name:
Kim
|
Re: MySQL
Posted by Andrewz00
Posted by luvsun27
I have never taken a course, I have learned myself through trial/error and google is your friend
you know SQL???
Yes  Wanna quiz me?
|
| Posted 7/20/10 3:59 PM |
| |
|
Blazesyth
*yawn*
Member since 5/05 8129 total posts
Name:
|
Re: MySQL
Posted by luvsun27
I have never taken a course, I have learned myself through trial/error and google is your friend
Same. Google gives me enough information to do what I want and be dangerous.
|
| Posted 7/20/10 3:59 PM |
| |
|
luvsun27
Check out my cool glasses
Member since 5/05 8135 total posts
Name:
Kim
|
Re: MySQL
Posted by Andrewz00
Posted by luvsun27
I have never taken a course, I have learned myself through trial/error and google is your friend
you know SQL???
I'm actually writing a report/query in an oracle database as we speak 
|
| Posted 7/20/10 4:01 PM |
| |
|
Katareen
5,000 Posts!
Member since 4/10 7180 total posts
Name:
Katherine
|
Re: MySQL
I use it every day at work as well!!
|
| Posted 7/20/10 4:07 PM |
| |
|
|
|
Re: MySQL
Wow. I had to double check my address bar. For some reason I thought I was on Slashdot.
MySQL is not hard to learn at all. I'll point you to: http://www.mysqltutorial.org/
There are a ton of books on MySQL as well, check out your local Borders.
What will you be using MySQL for? The tricky part is learning how to use it with your programming environment of choice. If you're in Java, check out Hibernate (after your learn MySQL of course) Persistance Engines are so hip right now.
|
| Posted 7/20/10 4:32 PM |
| |
|
Blazesyth
*yawn*
Member since 5/05 8129 total posts
Name:
|
Re: MySQL
Posted by saltoftheearth
Wow. I had to double check my address bar. For some reason I thought I was on Slashdot.
If you're in Java, check out Hibernate (after your learn MySQL of course) Persistance Engines are so hip right now.
DB and dev teams here talk all the time about how Hibernate and MongoDB are going to 'change everything'. I'm sick of hearing it without proof so I just give them the 'blah blah blah' hand and  Until my lock wait time and buffer cache ratio go down, zip it.
Message edited 7/20/2010 4:40:05 PM.
|
| Posted 7/20/10 4:36 PM |
| |
|
|
|
Re: MySQL
DB and dev teams here talk all the time about how Hibernate and MongoDB are going to 'change everything'. I'm sick of hearing it without proof so I just give them the 'blah blah blah' hand and Until my lock wait time and buffer cache ratio go down, zip it.
I can't tell you how much Hibernate has simplified my life. I started working with Hibernate back in its beta days. Now JPA is a standard in J2EE. So I work with straight up JPA code, (while still using Hibernate as my underlying engine). Since using Hibernate/JPA I rarely write SQL (inside my code), in addition to not having to refactor everytime someone decides to add a new field or mess with the schema.
Message edited 7/20/2010 4:51:31 PM.
|
| Posted 7/20/10 4:50 PM |
| |
|
Andrewz00
Look! I changed it!
Member since 4/10 1789 total posts
Name:
Andrew
|
Re: MySQL
Posted by saltoftheearth
DB and dev teams here talk all the time about how Hibernate and MongoDB are going to 'change everything'. I'm sick of hearing it without proof so I just give them the 'blah blah blah' hand and Until my lock wait time and buffer cache ratio go down, zip it.
I can't tell you how much Hibernate has simplified my life. I started working with Hibernate back in its beta days. Now JPA is a standard in J2EE. So I work with straight up JPA code, (while still using Hibernate as my underlying engine). Since using Hibernate/JPA I rarely write SQL (inside my code), in addition to not having to refactor everytime someone decides to add a new field or mess with the schema.
WOW!!!! i am impressed yet again! and i thought i was the only computer nerd on here! phew!
|
| Posted 7/20/10 4:56 PM |
| |
|
Blazesyth
*yawn*
Member since 5/05 8129 total posts
Name:
|
Re: MySQL
Posted by saltoftheearth
I can't tell you how much Hibernate has simplified my life. I started working with Hibernate back in its beta days. Now JPA is a standard in J2EE. So I work with straight up JPA code, (while still using Hibernate as my underlying engine). Since using Hibernate/JPA I rarely write SQL (inside my code), in addition to not having to refactor everytime someone decides to add a new field or mess with the schema.
Yeah, I can see not having to refactor as a big plus. It's just the hype hype hype that gets to me.
Like 'THE CLOUD'. The cloud will NOT fix EVERYTHING people. "We'll just move it to the cloud and it'll be GREAT!" Umm, the cloud won't fix that your application still suxx.... Sure you can scale horizontally on the fly, because your crappy app takes 100% CPU. If you had a better app, it wouldn't use excessive CPU and therefore wouldn't need to auto-scale and ding us for $$$ for another server.
</rant>
|
| Posted 7/20/10 4:58 PM |
| |
|
bonch20
LIF Adult
Member since 9/09 1290 total posts
Name:
Bonnie
|
Re: MySQL
we have a team creating a new website for us and i'm supposed to become the webmaster once it's complete....i seem find tons on MS SQL, not MySQL. there's a 4 week course at Hofstra. waiting to see if the boss will go for that. i'd like to take something 'physical' and then use the web to teach me further.
|
| Posted 7/21/10 10:22 AM |
| |
|
Blazesyth
*yawn*
Member since 5/05 8129 total posts
Name:
|
Re: MySQL
Posted by bonch20
we have a team creating a new website for us and i'm supposed to become the webmaster once it's complete....i seem find tons on MS SQL, not MySQL. there's a 4 week course at Hofstra. waiting to see if the boss will go for that. i'd like to take something 'physical' and then use the web to teach me further.
SQL is a programming language; MS SQL (Microsoft SQL) is a database management program that uses that language. Along with MSSQL, other software programs that use SQL are Oracle, and MySQL.
I think you should find out what your exact responsibilites/role will be before you commit to a class so you can make sure you are getting the right training. The team might be building an interface to help you make changes and you might need no SQL/MSSQL/MySQL experience.
|
| Posted 7/21/10 10:29 AM |
| |
|
bonch20
LIF Adult
Member since 9/09 1290 total posts
Name:
Bonnie
|
Re: MySQL
Posted by Blazesyth
Posted by bonch20
we have a team creating a new website for us and i'm supposed to become the webmaster once it's complete....i seem find tons on MS SQL, not MySQL. there's a 4 week course at Hofstra. waiting to see if the boss will go for that. i'd like to take something 'physical' and then use the web to teach me further.
SQL is a programming language; MS SQL (Microsoft SQL) is a database management program that uses that language. Along with MSSQL, other software programs that use SQL are Oracle, and MySQL.
I think you should find out what your exact responsibilites/role will be before you commit to a class so you can make sure you are getting the right training. The team might be building an interface to help you make changes and you might need no SQL/MSSQL/MySQL experience.
thanks for the above! actually, they are the ones who told me to take a class to better understand the program...this is one of the things they sent over: Proficiency on SQL database queries to read, extract or change data in the database, as needed.
|
| Posted 7/21/10 10:41 AM |
| |
|
greenfreak
.
Member since 9/06 11483 total posts
Name:
greenfreak
|
Re: MySQL
Posted by Andrewz00
WOW!!!! i am impressed yet again! and i thought i was the only computer nerd on here! phew!
Not only are you among many other nerds, but many other female nerds which are harder to come by.
I've taken New Horizons classes too, not on SQL but other things, and they seemed well organized and the instructor was great.
Once you have the basics, Google is great but one of the sites that always comes up in my searches for information is Experts Exchange.
I would also suggest, before their work on the site is done, that they set aside a good chunk of time to go over everything with you. DH is a programmer and he's worked with people that were ambiguous on purpose because they knew they would get more $ if the client had to request more help.
|
| Posted 7/21/10 1:09 PM |
| |
|
luvsun27
Check out my cool glasses
Member since 5/05 8135 total posts
Name:
Kim
|
Re: MySQL
Posted by greenfreak
Once you have the basics, Google is great but one of the sites that always comes up in my searches for information is Experts Exchange.
That site you have to pay for. If your too cheap like me I found this one to be pretty good sql help. Also...I usually can find most anything using google, it just takes a little extra effort. Good luck!
|
| Posted 7/21/10 1:18 PM |
| |
|
greenfreak
.
Member since 9/06 11483 total posts
Name:
greenfreak
|
Re: MySQL
Posted by luvsun27
That site you have to pay for.
Not necessarily... If you want to post your own new questions, you do. I bought a subscription with my company card. But you can still get the information from the site if it comes up in a Google search by clicking on "Cached Link" and scrolling to the bottom.
|
| Posted 7/21/10 1:24 PM |
| |
|
luvsun27
Check out my cool glasses
Member since 5/05 8135 total posts
Name:
Kim
|
Re: MySQL
Posted by greenfreak
Posted by luvsun27
That site you have to pay for.
Not necessarily... If you want to post your own new questions, you do. I bought a subscription with my company card. But you can still get the information from the site if it comes up in a Google search by clicking on "Cached Link" and scrolling to the bottom.
Oh...I'll have to try that Whenever that site comes up in my search, I always disregard it and look for others because I don't have a subscription
|
| Posted 7/21/10 1:26 PM |
| |
|
Celt
~~~~~~~~~~
Member since 4/08 7758 total posts
Name:
colette
|
Re: MySQL
This thread is f'ing with my self-esteem!!
|
| Posted 7/21/10 1:28 PM |
| |
|
Blazesyth
*yawn*
Member since 5/05 8129 total posts
Name:
|
Re: MySQL
Posted by greenfreak
I bought a subscription with my company card.
Cached content is your friend!
So now we all know just to funnel all questions that need to be posted thru you.
|
| Posted 7/21/10 1:32 PM |
| |
|
luvsun27
Check out my cool glasses
Member since 5/05 8135 total posts
Name:
Kim
|
Re: MySQL
Posted by greenfreak
But you can still get the information from the site if it comes up in a Google search by clicking on "Cached Link" and scrolling to the bottom.
You are my hero...just tried this  
|
| Posted 7/21/10 1:33 PM |
| |
|
| Pages: [1] 2 |
