Course Overview
This course introduces the user to SQL Server 2008 and the SQL Server Management Studio. It covers the basics from creating databases and tables to learning how to query multiple tables. Once those basics are covered, the final exercise is understanding and creating Views and simple Stored Procedures. This course is designed to get the user up and running with SQL Server as quickly as possible.
Course Objectives
Getting Started with SQL Server, Creating a Database and Tables, Working with Tables, SELECT Statements, Multi-Table Queries, Views and Stored Procedures
Agenda
1 - Introduction
2 - Getting Started with SQL Server
- Overview: What is SQL Server?
- Connecting to the Server
- Working in the Management Studio
- Template Explorer
- Using Tools
- Understanding Window, Community, and Help Tabs
- Using Toolbars
- Using Object Explorer
- Opening a Table
- Transacting SQL
3 - Creating a Database and Tables
- Creating Databases with the Database Wizard
- Creating Tables Manually
- Understanding the 7 Basic Data Type Categories
- Using the Table We Created
- Creating Tables Using T-SQL
4 - Working with Tables
- Adding Constraints
- Understanding Indexes
- Altering the Table Design
5 - SELECT Statements
- The Basic SELECT Statement
- The FROM Clause
- The WHERE Clause
- The ORDER Clause
6 - Multi-Table Queries
- MS-SQL Query Method
- Using a WHERE Clause to Link Tables
- Ansi-SQL Method
- Joining Tables: Inner Join
- Query Designer
- Ambiguous Column Name
- Table Aliases
- Joining Tables: Left Outer Join
- Joining Tables: Right Outer Join
- A Tip for Building a New Query
7 - Views and Stored Procedures
- Overview
- Creating a View
- Creating a View Using T-SQL
- Creating Simple Stored Procedures
- Using Arguments
- Executing Stored Procedures
8 - Conclusion