Notes from the Introduction to SQL server class.

Here are the slide decks from the Introduction to SQL Server class – January 2010.

Class 1

  • About the Instructor
  • Introduction and Class Overview (Review Syllabus)
  • Course Logistics – What to expect and what is expected
  • What is SQL Server?
  • Installing SQL Server 2008
  • SQL Server Management Studio
  • Differences between SQL Server 2005 and SQL 2008
  • Introduction to SQL Books Online

Week_1.pdf

 

Class 2

  • Simple Selects
  • Simple Inserts
  • Simple Updates
  • Simple Delete
  • Aggregating Data
  • Lab: Exploring the AdventureWorks database

Week_2.pdf

 

Class 3

  • Querying tables
  • Join Syntax
  • Advanced Joins
  • Unions
  • Sub-Queries
  • Lab: Experimenting with the output and different types of joins on the same data

Week_3.pdf

 

Class 4

  • Overview of database design
  • 1st, 2nd and 3rd normal form.
  • Creating Tables
  • Creating relationship

Week_4.pdf

 

Class 5

  • Overview of SSRS
  • SSRS Demonstration
  • Creating reports
  • Advanced report creation
  • Matrix Reporting
  • Advanced Reporting Options
  • Course Review

Week_5.pdf