Introduction to SQL Server

Download PDF

Introduction to SQL Server

The Introduction to SQL Server course is for those who need to access their data, but have never used Microsoft SQL Server. Intended for business users or other professionals who want to be able to access data in a SQL Server database. We will cover the basics from getting started, and installing the SQL Server product and the tools to access a database. The foundations of the SQL query language will including querying data, creating tables, and bringing data together from multiple tables. Once you understand how to query the data, we will look at building reports for a powerful presentation of your data. This 6 evening class will go from zero or minimal knowledge of SQL Server to a solid understanding of how to query data, collect data, and to present that data.


Required software: SQL Server 2014 – Developer Edition (about $55) or the free trial download from Microsoft. The developer edition is recommended.


This class is intended for people who have never used SQL Server, or who have no formal training in SQL Server.


This class is broken into 6 sessions 3 hours each.

Course Description

The Introduction to SQL Server course introduces the key concepts in relational database models and their implementation in Microsoft SQL Server. It focuses on developing the basic SQL server skills that would be needed for developers, administrators or people attempting to migrate data from access to SQL server. The following topics will be covered.

  • Installing and using Microsoft SQL Server 2014.
  • Foundations of Transact-SQL.
  • Creating Tables.
  • Constraints.
  • Joins and the relational database.
  • SQL Server Report Server (SSRS)

Class Sessions

Session 1 – 3 Hours

Topic:   Class overview, Configuring and Installing SQL Server 2014
Overview:  An overview of the class, what we will cover, and what will be expected.  Installing SQL Server 2014, and how we will be using these systems in class.
Class Activities:
  1. Introduction – Class overview
  2. Course Logistics – What to expect and what is expected
  3. Review Syllabus
  4. Installing SQL Server 2014
  5. Differences between SQL Server 2014
  6. SQL Server Management Studio
    1. Query Windows
    2. Object Explorer
    3. Solution Explorer
    4. Template Explorer
  7. Introduction to SQL Books Online
  8. Writing basic queries

Session 2 – 3 Hours

Topic:   Introduction to Transact SQL – CRUD: Create, Read, Update, and Delete Data
Overview:  Fundamentals of Transact SQL for data manipulation.
Reading:  Chapters 3

Class Activities:

  1. Simple Selects
  2. Simple Inserts
  3. Simple Updates
  4. Simple Delete
  5. Aggregating Data
  6. Lab:  Exploring the AdventureWorks database

Session 3 – 3 Hours

Topic:   The Inns and Outs of JOINS: Can you Relate?
Overview:   This week will be be covering the details with querying against multiple tables, and bring the data together in a format that you can use it.
Reading:  Chapters 3 and 4
Class Activities:
  1. Querying related tables
  2. Join Syntax
  3. Inner Joins
  4. Left Outer Join
  5. Right Outer Join
  6. Cross Joins
  7. Unions
  8. Sub-Queries
  9. Lab:  Experimenting with the output and different types of joins on the same data

Session 4 – 3 Hours

Topic:   Normalization, Creating Table, and Constraints
Overview:   Some basics on designing tables.
Reading:  Chapters 5
Class Activities:
  1. Overview of database design
  2. 1st, 2nd and 3rd normal form.
  3. Creating Tables
  4. Lab: Creating tables
  5. Creating relationships
  6. Lab: Creating relationships

Session 5 – 3 Hours

Topic:   SSRS: SQL Server Reporting Services, Course Review
Overview:  Taking the queries that you have created, and building reports to show the data in a visual presentation
Reading:  Instructor Provided Handout
Class Activities:
  1. Overview of SSRS
  2. SSRS Demonstration
  3. Creating reports
  4. Lab: Creating reports with the wizard
  5. Advanced report creation
  6. Lab: Creating reports without the wizard.
  7. Matrix Reporting
  8. Lab: Creating a Matrix
  9. Advanced Reporting Options  (Grouping, Sorting, Formatting, Report Properties)
  10. Lab: Using Advanced Options
  11. Course Review
One comment on “Introduction to SQL Server
  1. andrew marin says:

    Live in Bellingham and have been in hi-tech as an automation developer for 21 years, but want to make the switch to SQL work. Have some exposure to SQL, but would need to learn pretty much from the ground up. The objective is to become a DB Architect in time. What are my options for getting started with you or some other entity?


Leave a Reply

Your email address will not be published. Required fields are marked *


Time limit is exhausted. Please reload CAPTCHA.