Welcome to Part 5 of our free SQL 101 training series covering the basics in SQL Server 2008 administration. Today we will focus on the UPDATE statement.
Your instructor, Mel Haynes, will be covering the UPDATE statement definition, updates based on a value, nested statements and how to update all rows.
All student files are available for download here.
Let us know what you think about this lesson and the previous videos too.

There are a number of Vista certification exams that you can take. One popular choice is exam 70-622: Supporting and Troubleshooting Applications on a Windows Vista Client for Enterprise Support Technicians
I have already outlined the 70-622 exam in one of my previous articles, where I provided an overview of the skills needed for the exam and how to achieve the MCTS certification.
Today I’m going to focus on one area of the 70-622 exam — Deploying Windows Vista segment of the exam, specifically the section that covers analyzing the business environment and selecting an appropriate deployment method.
The 70-622 Vista Desktop Support for Enterprise Technicians exam measures a number of different skills and the first section of topics for the exam encompasses the following:
A few weeks ago I talked about Adobe Acrobat replacement along with 7 other must have Windows utilities.
Last week I showed you how to use CCleaner to improve Windows performance. Today I’m going to show you how to speed up your Windows by replacing Acrobat Reader.
What started out as a tiny little utility to allow anyone to view a file the same way it looked on the creator’s computer has turned into a massive piece of bloatware complete with unasked for add-ons, always-on services taking up system resources, and a start time that would make turtles laugh out loud.
Of course, we’re talking about Adobe Acrobat Reader.
The current version of Adobe Acrobat Reader weighs in a 32 MB (though you can get a lighter weight version if you pay close attention when selecting your download) and takes up over 130 MB when installed. That seems like an awful lot for a program that most people just need to display PDF files on their computer screen. But, it gets even worse.
Welcome to Part 4 of our free SQL 101 training series covering the basics in administration of SQL Server 2008. Today’s video will focus entirely on the INSERT statement.
In case you missed them, here are the previous videos in the series:
Part 3: Intro to Structured Query Language
Note: All student files are available for download here.

I’ve already introduced you to some of the most common network attacks like the IP address sweep, port scanning, and IP spoofing.
I have also recently covered the ping of death and other network attacks, including the SYN flood, UDP flood, ICMP flood and the teardrop attack.
Now that we have the basic Denial of Service Attacks (aka DoS attacks) and the Reconnaissance Attacks out of the way, let’s talk about other types of network attacks.
Today I’ll focus on:
I hope that this article, along with my previous ones, will shed some light on vulnerabilities in security and help you with your concerns regarding your network’s security needs. It may even inspire you to get your CCNA Security Certification.

Recently, we talked about 8 must have Windows utilities.
Some improved Window’s default functionality via replacement utilities. Some of the top must have utilities improved security and privacy.
But, CCleaner provides a critical function for high-performance Windows computing that doesn’t even exist in a standard Windows installation.
Membership in the group of people who think that Windows is tight, highly-efficient code is limited to those who have spent time in a rubber room. It is no secret that the Windows code-base has bloated over the years. What is less commonly known is just how much junk gets left lying around your PC.
Whether it’s Windows not cleaning up after itself, or other applications littering temp files all over your disk, if you’ve never run a system cleaner before, you’ll be shocked at how much clutter is hampering the performance of your computer. It’s not uncommon to free up hundreds of megabytes of disk space.
Copyright © Train Signal Inc. All Rights Reserved.