The Official IT Thread

[lighthearted26]

Anyone on here really good with SQL and query statements? I saw someone mention it earlier. I have this take home test and I am stumped on a few. Ill just ask one though,

Write a query statement for this:

Provide an alphabetical list of employee last names, job titles, and the city where they work, grouped by city.

My answer is

SELECT last_name, job_title, city

FROM. hr.employees

GROUP BY city

Is this right?

 

[traestar]

Anyone on here really good with SQL and query statements? I saw someone mention it earlier. I have this take home test and I am stumped on a few. Ill just ask one though,

Write a query statement for this:

Provide an alphabetical list of employee last names, job titles, and the city where they work, grouped by city.

My answer is

SELECT last_name, job_title, city

FROM. hr.employees

GROUP BY city

Is this right?

After the FROM hr.employees, I'd ORDER by last_name

 

[lighthearted26]

Anyone on here really good with SQL and query statements? I saw someone mention it earlier. I have this take home test and I am stumped on a few. Ill just ask one though,

Write a query statement for this:

Provide an alphabetical list of employee last names, job titles, and the city where they work, grouped by city.

My answer is

SELECT last_name, job_title, city

FROM. hr.employees

GROUP BY city

Is this right?

After the FROM hr.employees, I'd ORDER by last_name

Thank you.

 

[black caesar]

I think I'll be taking the ICND1 next week or the week after.

Can someone help me break down Static Routing a little better?

 

[King Erauno]

I think I'll be taking the ICND1 next week or the week after.

Can someone help me break down Static Routing a little better?

Static routing: Manually route packets to a certain destination that you as the administrator input.

Pros: only you allow access to certain networks. No overhead on the router CPU

Cons: input by hand, not very scalable.

ip route destination network mask next hop address exit interface administrative distance(optional)

Router(config)# ip route 172.16.1.0 255.255.255.0 192.168.1.1 150(optional)

iproute: tells us that it is a static route

172.16.1.0 is the remote network that we want to send packets to

255.255.255.0 is the mask of the network (aka: anything in the 172.16.1.x network gets routed)

192.168.1.1 is the next hop or router that we send the packets to. It also means that the hop or router at this ip address knows how to get to the intended destination

150 is the administrative distance. default for static is 1. basically the trustworthiness of the route. the lower the number the more trustworthy this is.

you could also have: Router(config)# ip route 172.16.1.0 255.255.255.0 int s0/0/0

says the same thing, except to send packets out of the s0/0/0 interface

to determine what routes are static, type in : sh ip route (show IP route)

you will see an S next to the routes there

 

[Mr Popo]

What's going on fellas...went and took the A+ exams today and passed!!

Hopefully employers will give me more of a chance.

Now on to Security+

 

[King Erauno]

What's going on fellas...went and took the A+ exams today and passed!!

Hopefully employers will give me more of a chance.

Now on to Security+

good shit hommie. throw that joint on your resume and keep studying

 

[black caesar]

What's going on fellas...went and took the A+ exams today and passed!!

Hopefully employers will give me more of a chance.

Now on to Security+

good shit hommie. throw that joint on your resume and keep studying

How's thing going for you in the ATL? I'm think of moving down there once I get my CCNA. Anyway you can get me in the door? (No helpdesk)

 

[Mr Popo]

Does anyone have a pdf version of a Security+ book?

I have a book but it's for sy0-201....the test is now for sy0-301

 

[King Erauno]

What's going on fellas...went and took the A+ exams today and passed!!

Hopefully employers will give me more of a chance.

Now on to Security+

good shit hommie. throw that joint on your resume and keep studying

How's thing going for you in the ATL? I'm think of moving down there once I get my CCNA. Anyway you can get me in the door? (No helpdesk)

its cool here, still growing on me. Job is a little stressful since i work for a bank and the only network engineer here. once you pass shoot me a pm and your resume and i can pass you onto my recruiter. My job here they're looking for CCNP's to assist me.

 

[vitoria]

Just came across a job in South Carolina working for the D.o.D if any one wants to hop on it pm me.. Job starts @ the end of the month.

 

[black caesar]

What's going on fellas...went and took the A+ exams today and passed!!

Hopefully employers will give me more of a chance.

Now on to Security+

good shit hommie. throw that joint on your resume and keep studying

How's thing going for you in the ATL? I'm think of moving down there once I get my CCNA. Anyway you can get me in the door? (No helpdesk)

its cool here, still growing on me. Job is a little stressful since i work for a bank and the only network engineer here. once you pass shoot me a pm and your resume and i can pass you onto my recruiter. My job here they're looking for CCNP's to assist me.

But I'm trying to get my CCNA. Would they still holla at me?

 

[King Erauno]

What's going on fellas...went and took the A+ exams today and passed!!

Hopefully employers will give me more of a chance.

Now on to Security+

good shit hommie. throw that joint on your resume and keep studying

How's thing going for you in the ATL? I'm think of moving down there once I get my CCNA. Anyway you can get me in the door? (No helpdesk)

its cool here, still growing on me. Job is a little stressful since i work for a bank and the only network engineer here. once you pass shoot me a pm and your resume and i can pass you onto my recruiter. My job here they're looking for CCNP's to assist me.

But I'm trying to get my CCNA. Would they still holla at me?

nah i was saying i wouldnt be able to get you on here at my job because they want a ccnp, but my recruiter (outside company) would be able to find something for you

 

[black caesar]

What's going on fellas...went and took the A+ exams today and passed!!

Hopefully employers will give me more of a chance.

Now on to Security+

good shit hommie. throw that joint on your resume and keep studying

How's thing going for you in the ATL? I'm think of moving down there once I get my CCNA. Anyway you can get me in the door? (No helpdesk)

its cool here, still growing on me. Job is a little stressful since i work for a bank and the only network engineer here. once you pass shoot me a pm and your resume and i can pass you onto my recruiter. My job here they're looking for CCNP's to assist me.

But I'm trying to get my CCNA. Would they still holla at me?

nah i was saying i wouldnt be able to get you on here at my job because they want a ccnp, but my recruiter (outside company) would be able to find something for you

I see. So the recruiter is a temp agency?

 

[black caesar]

What's going on fellas...went and took the A+ exams today and passed!!

Hopefully employers will give me more of a chance.

Now on to Security+

good shit hommie. throw that joint on your resume and keep studying

How's thing going for you in the ATL? I'm think of moving down there once I get my CCNA. Anyway you can get me in the door? (No helpdesk)

its cool here, still growing on me. Job is a little stressful since i work for a bank and the only network engineer here. once you pass shoot me a pm and your resume and i can pass you onto my recruiter. My job here they're looking for CCNP's to assist me.

But I'm trying to get my CCNA. Would they still holla at me?

nah i was saying i wouldnt be able to get you on here at my job because they want a ccnp, but my recruiter (outside company) would be able to find something for you

I see. So the recruiter is a temp agency? Also do you have a copy of packet tracer 5.3?

 

[King Erauno]

nah shes just an IT recruiter who recruits for all kinds of companies. Yeah ive got that and a couple PDF's i used to study my CCNA with. i'll upload them for you tonight when i get home

 

[King Erauno]

shit i actually had a guide here on my dropbox.

check the link and scroll down to where it says download from sendspace:
http://www.sendspace.com/file/578vck

you can use this guide with packetracer 5.3 to go over the topics covered on the exam. read through it, it literally could take you a week or so to go through it to fully understand how to do things. Pair this along with your reading to fully grasp the concept.

 

[black caesar]

shit i actually had a guide here on my dropbox.

check the link and scroll down to where it says download from sendspace:
http://www.sendspace.com/file/578vck

you can use this guide with packetracer 5.3 to go over the topics covered on the exam. read through it, it literally could take you a week or so to go through it to fully understand how to do things. Pair this along with your reading to fully grasp the concept.

Appreciate it, but where's the link to Packet Tracer 5.3?

 

[King Erauno]

my badd here you go
http://www.ccna4u.org/2012/02/packet-tracer-version-5-3-3-software-downloads-update-08-02-2012.html

 

[black caesar]

my badd here you go
http://www.ccna4u.org/2012/02/packet-tracer-version-5-3-3-software-downloads-update-08-02-2012.html

Thanks fam. I'm hoping I can pass both parts. Shit ain't going right in VA as far as jobs right now.