SQL

• What does SQL stand for?
• What is a database query?
• For the following query, what table is the information being pulled from?
• select (name, address) from (roster) where (class=programming)
• Do you have to learn an SQL language in order to control a database?
• What is the Microsoft Office application that can be used for controlling databases?

SQL

Answer the following questions:

• What does SQL stand for?
• What is a database query?
• For the following query, what table is the information being pulled from?
• select (name, address) from (roster) where (class=programming)
• Do you have to learn an SQL language in order to control a database?
• What is the Microsoft Office application that can be used for controlling databases?

.

Another Test

This is another test post...

\

.

Test Post

Here's a Test POstingggg

.

A+

We are taking the A+ Test on 5.23.09 at Stark State at 8:30am.

If the date, time, or location changes, I'll contact you via email. CHECK YOUR EMAIL!

This is a GOOD TEST SIMULATION for the 601 test...

This is a GOOD TEST SIMULATION for the 602 test...

We all must create a user account with PearsonVUE in order to schedule our tests.

Final Test

Test....

.

A+ Format

Here's a link to useful information about the format of the A+ test.

So today, in 40 minutes, we should be able to finish about 45 sample, "Adaptive Drill", questions.

Raise your hand when you've finished.

.

Today's Test

There's no talking or other fun today.

The test has 2 parts: Matching & Short Answer.

Click here to take the test.


.

Technical Support

The following is a list of "How to Give Terrible Tech Support". You assignment is to rewrite the list so that it pertains to "How to give Awesome Tech Support":

1. Assume that everyone who calls tech support is stupid.
2. Don't read or listen carefully. Light upon a couple of key words and give an answer which speaks to the most common questions, not the one being asked.
3. Blame all communication problems on the caller. You, after all, were hired for your superior people-handling skills and technical knowledge. Reading/listening comprehension is not required.
4. Remember that the human beings are only to be found in tech support. Clients are never human.
5. Direct the client to the FAQ. Don't tell the client where the FAQ can be found.
6. If the client finds the FAQ and the question isn't in the FAQ, insist that it is.
7. If the client can prove that the question isn't in the FAQ, insist that wasn't the question you were asked in the first place.
8. Keep the amount of time you spend answering tech support questions to a minimum. Short, evasive answers are always better than long, accurate ones.
9. Do not ever reveal that there are things you do not know. Do not seek help with a client's problem from other tech support staffers or engineers. If you cannot answer a question, see Rule 16.
10. Tell the client that you can't answer the question because you don't have all the necessary information. Tell them to look in the FAQ for the information they need to provide.
11. If the client provides all the necessary information, write back (being careful not to include a copy of the clients message) and tell the client that you cannot answer the question because he/she didn't provide the requested information.
12. If a client cannot understand what you are saying, don't rephrase it or try to figure out where the misunderstanding is coming from.
13. If the client shows signs of frustration, tell them that they are being rude. Hang up immediately.
14. Tell the client that you are not allowed to assist with that sort of problem.
15. Tell the client that you answer a million calls every day and you don't have time to investigate the problem.
16. When all else fails, simply don't give an answer.

Post your list in a comment to this blog.


.

Thursday's Test

Thursday's Test will cover the following:

• Chapters 20 & 21
• Chapter 22
• Chapter 23
• Chapter 24

It will be closed-note, closed-neighbor, closed-everything...
Just you, your brain, and a prayer...


.

Thursday's Test

Thursday's test will cover the following:

Chapter 24 (cont'd)

Answer the following concerning CHAPTER 24:

• Items in the Control Panel are manipulated using what type of policy?
• What is a GPO? GPE?
• List 6 possible {reasonable} responsibilities of a network administrator.
• List 4 password attributes that can be set for a domain.
• What is system auditing?
• How many tcp/ip port numbers are there?
• What are the port numbers assigned to the following: ftp, http, https, smtp, rdp, telnet.
• Who is able to access files protected by EFS?
• What is malware?

.

Router Quizzzz

Answer the following in a comment to this blog post:

• List the default value for the following router settings:
• Host Name:
  
• DHCP Service:
  
• Local IP Address:
  
• Subnet Mask:
  
• Remote Administration:
• How does the router determine which LAN PC is to recieve a network packet?
• Which is stronger, Windows Firewall or a router firewall?
• What does QoS accomplish?
• Why is enabling DMZ a security risk?
• How would you reset a router back to factory defaults if you are unable to log into its web user-interface?
• Which is stronger, WPA or WEP?

.

Welcome Back

Welcome back! I hope that you all had a good break... At least this week is a short one.

Today, since we're easing back into things, we're going to take a look at some "practical" home newtworking. If you mastered the Linksys router, today may somewhat boring.

.

Wireless Encryption

Your assignment, DUE TOMORROW, is to write a 400 word {minimum} report on the strengths and weaknesses of the WEP, WPA, and WPA2 encryption methods.

You must use and cite {I don't care what citation method you use} at least 3 sources.

Name your Word document "wifi-encryption.doc" and upload it when you're finished.

I recommend working in Google Docs so file transportation isn't an issue.

This is a test grade.

.