Intro to SQL Server

Introduction to SQL Server

Audience

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

Time

This class is broken into 5 sessions 4 hours each.

Course Description

This 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 2005 and 2008.
  • Foundations of Transact-SQL.
  • Creating Tables.
  • Constraints.
  • Joins and the relational database.
  • SQL Server Report Server (SSRS)

Class Sessions

Session 1 – 4 Hours

Topic:   Class overview, Configuring and Installing SQL Server 2008 – Whats new in 2008R2
Overview:  An overview of the class, what we will cover, and what will be expected.  Installing SQL Server 2008, 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 2008
  5. Differences between SQL Server 2008 and SQL Server 2008R2
  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 – 4 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 – 4 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 – 4 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 – 4 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 Response to Intro 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?

    Andrew

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by sweetCaptcha