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.

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

Fields

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...

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...

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.

sorting

SSRS: Sorting

You have a shiny new report that your users can now interrogate with parameters (shown in last video), its interactive now, but there is something missing..... The user will always wants to sort the results...

reportparameters

SSRS: Intro To Parameters

With your report well underway, the next hurdle is ensuring your report is able to change its results depending on the criteria the user wants. this is accomplished by putting report parameters onto...

reportproperties

SSRS: Formatting & Properties

The dataset,datasource and table are present on your report but something is missing.....I know formatting! You cannot have a report that does not have borders,font stylings and shading on can you? of...

Diagrams

SQL: Diagrams

With the basics covered from previous videos in the series, we can now move on to the more interesting areas of SQL server. As a gentle introduction into the intermediate level we shall start...

GroupBy

SQL: Group By Clause

The more data you start interrogating the more records you will return. Its always the same, you start off with basic criteria and before you know it you are referencing several tables to obtain...

PrimaryKeys

SQL: Primary Keys

So if your here on this post your after understanding the mysteries of Primary/Foreign key relationships. Well let me tell you they are an art form not an exacting science something at first you...

Joins

SQL: Joins

If your learning the basics of SQL, there comes a point in everyone's experience of SQL where the learning curve suddenly jumps a notch.  For me this topic made me reminise back to when I...

SelectStatement

SQL: Select Statement

If you want to return values from any SQL source you need to understand the most fundamental statement. The select statement by and large is quite easy to understand but bit by bit, line by...

Valid XHTML 1.0 Transitional website security