IT Certifications and Careers (Official Discussion Thread)

[FreshFromATL]

sql gawds I need some serious help, daps and rep will be provided;
mysql> desc staff;
+---------------+--------------+------+-----+---------+-------
| Field | Type | Null | Key | Default | Extra
+---------------+--------------+------+-----+---------+-------
| Staff_no | varchar(6) | NO | PRI | NULL |
| Lastname | varchar(30) | YES | | NULL |
| Firstname | varchar(25) | YES | | NULL |
| Hire_date | date | YES | | NULL |
| Location | varchar(30) | YES | | NULL |
| Supervisor_no | varchar(6) | YES | | NULL |
| Salary | decimal(8,2) | YES | | NULL |
| Commission | decimal(4,2) | YES | | NULL |
+---------------+--------------+------+-----+---------+-------
8 rows in set (0.00 sec)

mysql> desc sales;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| Order_no | varchar(6) | NO | PRI | NULL | |
| Sale_date | date | YES | | NULL | |
| Staff_no | varchar(6) | YES | | NULL | |
| Cust_no | varchar(6) | YES | | NULL | |
| Invoiced | decimal(2,0) | YES | | NULL | |
+-----------+--------------+------+-----+---------+-------+
Using the tables STAFF and SALES find all order numbers and sales date by staff member 000008. Include staff number, name and commission.
Can anybody help ive been getting error messages for an hour and a half trying to get this right

This shouldn't take more than 5 seconds to do. Hint: You need an inner join. You will be joining the tables on staff number.

 

[Soundbwoy]

This shouldn't take more than 5 seconds to do. Hint: You need an inner join. You will be joining the tables on staff number.

I found the answer took me awhile toohow often do you guys use sql tho?

 

[Pyrexcup]

ok so i've been chilling for a minute. been working helpdesk for almost 5 months just scoping the game to see the next step i want to take. To be honest i'm still not sure where i want to go one thing i know though is i want to sooner or later be working for myself cant see myself working for someone else the rest of my life. Right now im working enjoying the summer once September hits im jumping back on the grind, need to start doing research again and start studying for some certs so i can leave this place in around a year.
Things are not too bad here i cant solve most things now but i dont want to get complacent got to keep it moving

 

[SomaliLandCruiser]

Java

 

[Theabbot]

Anybody working on ITIL certs?
I am about to take my Foundation exam on Wed. Was looking for study tools and found this site:
itil-v3-exam-paper-dumps.weebly
Anyone use them before?

 

[kevm3]

I decided to get back into my PHP studies, which will also allow me to play around with MySQL. Can't wait to start getting deep into the book.

 

[Pyrexcup]

Anybody working on ITIL certs?
I am about to take my Foundation exam on Wed. Was looking for study tools and found this site:
itil-v3-exam-paper-dumps.weebly
Anyone use them before?

isn't that some management cert or some shyt

 

[Theabbot]

isn't that some management cert or some shyt

It's some IT process & management shyt that my boss is requiring the whole team to get certified in (foundations level). The company is paying so I ain't mad at em.

 

[Scott Larock]

I'm trying to get back into IT, I have a 2 year and some contract jobs but I'm looking for something full time paying at least 40k,

I have a A+ should I get a S+ or CCENT?

 

[FreshFromATL]

I found the answer took me awhile toohow often do you guys use sql tho?

I use SQL every second I'm at work.

 

[Soundbwoy]

I use SQL every second I'm at work.

any good resource you can recommend?

 

[nomoreneveragain]

Whose on Sharepoint up in here?

My Co-Worker always tells me to learn it, he says his girl makes 96K in Seattle just doing sharepoint. She dumb as rocks.

I want to learn but don't know where to start.

 

[Silver Surfer]

here's a easy one for yall....print out the items in the list that have the first character 'o' or the last character 'o'

show code

List someStringList = new ArrayList<String>();
someStringList.add("one");
someStringList.add("two");
someStringList.add("three");

 

[FreshFromATL]

Whose on Sharepoint up in here?

My Co-Worker always tells me to learn it, he says his girl makes 96K in Seattle just doing sharepoint. She dumb as rocks.

I want to learn but don't know where to start.

We deploy some of our reports to sharepoint. I think yo man was lying because sharepoint ain't nothing but a fukking Web server for communication lol. You post a report and send everyone the link lol.

 

[patscorpio]

I found the answer took me awhile toohow often do you guys use sql tho?

for me at least once a week..i use it along with crystal making customized reports for my client