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.

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

Microsoft

PackageConfigurations

SSIS: Package Configurations

One of the transitions from a beginner to an intermediate developer in SSIS is the ability to configure packages that you have created en mass. This can be done in a variety of ways...

PivotTables

Excel: Pivot Tables

One thing I do find funny in my line of work is the amount of IT people that don't use Pivot tables. Pivot tables can save the user so much time when it comes...

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

WhereClasue

SQL: Where Clause

Following on from our previous video of how to display results from SQL by use of the select statement. We are now going to discuss the basics of filtering our information by use...

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

Workflow

SSIS: WorkFlow Vs. DataFlow

With SSIS the first thing you need to understand in the basic concept of what "Work Flow" and "Data Flow" are. This video will discuss the differences at a basic level ready for some...

BI

BI: Business Intelligence 101

Business Intelligence (BI) is one big area! This video will provide you an introduction into the BI domain. Making a video discussing the theory can be daunting but I hope this video...

subdocuments

Word: Sub Documents

Sub documents are a little used feature but has some fantastic benefits! The purpose of sub documents is to allow the user to split the document up into smaller chunks, very handy if...

Outlines

Word: Outlines

This video will provide you with the basic understanding of what the "Outline View" is and how to use it. Within 10 minutes I guarantee you will be moving pages and pages of...

Page 4 of 5«12345»

Valid XHTML 1.0 Transitional website security