Table of Contents:

• Introduction


• SQL Server Overview
  
  
  
  • Overview
  
  
  • What is SQL Server?
  
  
  
  


• SQL Server Management Studio
  
  
  
  • The File Menu
  
  
  • The View Menu
  
  
  • The Tools Menu
  
  
  • The Window Menu
  
  
  • The Community Menu
  
  
  • The Toolbar
  
  
  • The Object Explorer
  
  
  • Databases
  
  
  • Introducing Transact-SQL (T-SQL)
  
  
  
  


• Creating Databases and Tables
  
  
  
  • Overview
  
  
  
  


• Creating a New Database
  
  
  
  • The General Page
  
  
  • Change Atogrowth
  
  
  • Path
  
  
  • Options Page
  
  
  • -Compatibility Level
  
  
  
  


• Creating a New Table
  
  
  
  • Rules to Follow When Creating a Database
  
  
  • The Seven Different Category Types
  
  
  • Require and Not Require
  
  
  • Table Opening Options
  
  
  • Creating Tables Using T-SQL
  
  
  
  


• Working with Tables
  
  
  
  • Overview
  
  
  
  


• Adding Constraints
  
  
  
  • Creating a New Constraint
  
  
  • IN Command
  
  
  • Checking Constraints
  
  
  
  


• Understanding Indexes
  
  
  
  • Primary Key
  
  
  • Adding Another Index
  
  
  • Concatenated Index
  
  
  • Altering Table Design
  
  
  
  


• Using the SELECT Statement
  
  
  
  • Overview
  
  
  • The Basic SELECT Statement
  
  
  • The FROM Clause
  
  
  • The Use Command
  
  
  • Using Star
  
  
  • Query Designer
  
  
  • The FROM Clause
  
  
  • The WHERE Clause
  
  
  • The IN() Command
  
  
  • Using Multiple Select Statements
  
  
  • Querying Text
  
  
  • Using Wildcards
  
  
  • The ORDER BY Clause
  
  
  
  


• Multi-Table Queries
  
  
  
  • Overview
  
  
  • Linking Using the MS-SQL Query Method
  
  
  • Linking Using the Ansi-SQL Method
  
  
  • Inner Joins
  
  
  • Using Table Aliases
  
  
  • Outer Joins
  
  
  
  


• Creating Views and Stored Procedures
  
  
  
  • Overview
  
  
  • Working with Views
  
  
  • Create Views Using the Interface
  
  
  • Create Views Using T-SQL
  
  
  • Understanding Stored Procedures
  
  
  • Create a Simple Stored Procedure
  
  
  • Create Stored Procedures containing Arguments
  
  
  
  


• Conclusion