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

 

 

---

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!