Creating & Importing Databases – SQL Server 2008R2

September 6, 2012 Leave a comment

SQL Server is a Relational Database Management System (RDBMS), so being able to create and import databases is an essential function of all Database Administrators. Today, we’ll take a look at the different methods of creating and importing databases in SQL Server 2008 R2. There are multiple ways to create and import databases, including wizards, menu options, and coding. We’ll cover each in this lesson. Read more…

Today’s Lesson: Installation of SQL Server

September 4, 2012 1 comment

Today, we’ll discuss the preparations for the installation of SQL Server 2008 R2.  After opening the installation program, unlike most programs, you’ll be faced with a plethora of options and choices.  It can be daunting to someone new to SQL, and here I’ll do a quick walk through to get you started. Read more…

Welcome to The SQL School!

September 3, 2012 Leave a comment

Welcome to The SQL School, a new place to learn all things SQL.  New lessons will be posted on Tuesday’s and Thursday’s, so make sure to keep up with me on Facebook and/or Twitter to get links to the latest lessons.

All lessons will use Microsoft SQL Server 2008 R2 Express, the free edition of SQL.  Click to download.
If something isn’t available in the Express version of SQL Server, I’ll be sure to post more detailed step-by-steps and pictures/videos to make sure you can take from it what is intended.

We will use the AdventureWorks2008R2 database provided by Microsoft.  This contains tables, procedures, everything needed to test and develop on a sample database.  Click to download.

Categories: Welcome! Tags: , ,