IT Certifications and Careers (Official Discussion Thread)

[DIMES]

I failed my rackspace interview today, I've been installing LAMP on Ubuntu and learning some basic stuff about it. They asked me questions like "in Red Hat, where do you go to see how many connections are active?, what's the two boot sequence of Red Hat, where in Red Hat do you go to see the system log?"

Basically anything to do with Red Hat.

What was the title you were going for?

 

[flipn50]

Ad
TE="DIMES, post: 9369954, member: 17536"]What was the title you were going for?[/QUOTE]

Linux
admin

 

[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");