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
Class 2
- Simple Selects
- Simple Inserts
- Simple Updates
- Simple Delete
- Aggregating Data
- Lab: Exploring the AdventureWorks database
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
Class 4
- Overview of database design
- 1st, 2nd and 3rd normal form.
- Creating Tables
- Creating relationship
Class 5
- Overview of SSRS
- SSRS Demonstration
- Creating reports
- Advanced report creation
- Matrix Reporting
- Advanced Reporting Options
- Course Review
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!
Leave a Reply