Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

24384 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

Microsoft

SQL magnifying glass

SQL: Installing SQL 2008 R2 | Install SQL

This video will discuss the typical options that are required to install SQL Server. I will also add my own thoughts to the installation process which will provide some insights into what and why...

foreachloop

SSIS: Foreach Loop

The foreach (file enumerator) loop looks at a specific folder and counts the amount of files which are in there and then goes through each file one at a time. This video will...

ExcelIfStatement

Excel: If Function

After a while of using spreadsheets you get to a point where you need better control on how data is being presented to the end user. Quite often this requires you to make "interpretations"...

RelativeVAbsolute

Excel: Absolute & Relative Cell Addressing

Ever had a formula that when copied references the wrong cell? Well this is down to Absolute & Relative cell referencing. Before you suddenly get cold shivers down your back and are running for...

dataviewers

SSIS: Data Viewers

We are slowly getting there! Our packages are coming along quite nicely but then DISASTER! You are getting errors all of sudden. After you have ran around the office screaming for 5...

BIPerspectiveSQL2008R2

BI Perspective: SQL 2008 R2 Editions

The following post shows the differences between Standard and Enterprise Editions of SQL 2008 R2. What I thought which was important to note is what from a BI perspective are the key advantages...

function

Excel: Functions

Functions generally work on a series of cells known as a "Range" which tells it to highlight from a start point to a end point. This video will discus how and why we...

formulas

Excel: Formulas / Calculations

The most basic thing you would do with a spreadsheet is create a calculation to add some values together. Well, its a relativley simple affair to do but there is a BIG gotcha...

MovingHighlightingSpreadsheet

Excel: Moving & Highlighting A Spreadsheet

This fundamental video will describe how to navigate around the Excel Spreadsheet. Most users of Excel are self taught and as a result they can do most of thier day to day work with...

SniffParam

SQL: Parameter Sniffing

Slow Stored Procedure But SQL script runs fast? I bet you its Parameter Sniffing thats to blame! Read this article to understand what Parameter Sniffing is and how to get around it.

fuzzylookup

SSIS: Fuzzy Lookup

With the any kind of database import there are always going to be data problems. Why? Well, it generally down to human beings. A computer is logical, a human is not. A computer does...

lookup

SSIS: Lookups

When either importing data or ETL (Extract, Transform & Load) for a data warehouse, you quite often need to assign key values to your data so you can use these values to join/link on....

Page 1 of 3123»

Valid XHTML 1.0 Transitional website security