SQL Server 2008 - Expert

Price
$59.99
Duration
3 Hours, 51 Minutes
Delivery Method
LearnNow On Demand

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.

 

Purchase This On Demand Title or a LearnNow On Demand subscription

SQL Server 2008 - Expert
  Buy Now $59.99 Purchase this course for 12 months.
  Buy Now $99.95 Purchase this course and hundreds of others with our LearnNow On Demand 12-month subscription.

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
  • 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
  • Conclusion