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 SQL

ReportWizard

SSRS: Report Wizard

So, you have your server configured and ready for "Report Consumers" (posh way of saying users!).  Where do you start I hear you asking?  Well, if your a novice your best place to start...

ReportConfiguration

SSRS: Report Server Configuration

"Before you can run you must walk".  Never a more a true word said!  If your intention is to produce reports for small to large businesses you need to ensure you have configured the...

SQLServerAgent

SQL: Server Agent

After you have your database the way you want it, the next thing on your list of priorities should be maintenance. You can perform most things manually, but what if you wanted the...

conversionAndDerived

SSIS: Conversion & Derived Data

With any data that your going to import into a database there are problems with the way the data has been entered down to calculations displaying values to too many decimals. To correct this you...

system-databases

SQL: System Databases

In SQL Server there are four databases that you may never use but are equally as important as your databases you work on day in day out. These "System" databases are a fundamental concept to...

union

SQL: Union Statement

When it comes to data manipulation there is only so much you can do. Most of the options on data manipulation stem from three sources: 1. Field Manipulation (the likes of case statements, if...

VariablesIntro

SSIS: Variables Introduction

A question was raised by one of our subscribers asking about variables and how they are used. So here we are! This video explains the basics of what variables are and how...

LikeStatement

SQL: Like Statement Special Wildcards

From time to time you will want to search within your database for specific information. Quite often this information would be a name or descriptor of some shape or form, but what if you...

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

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

Page 2 of 3«123»

Valid XHTML 1.0 Transitional website security