Skip to main content

Module 1: Database and Instance

In this module, you will learn the following:

  • Defining a Database and an Instance
  • Introduce Microsoft's and Oracle's Implementations of a Database and an Instance
  • Understand Client Interaction
  • Key Database and Instance Limitations

If you've installed Silverlight, you can click the Play button in the video player at left.
Or, right-click (Save Target As...) the link below to download.

Video Download
WMV

Length: 18 Minutes 52 seconds

Downloads
Powerpoint - Open the file using PowerPoint 2007.
Zip - Unzip the file, click launch.htm to view interactive training.


Module 1: Demo 1

In this demonstration you will see how to:

  • Stop and start service using the SQL Server Configuration Manager
  • Stop and start services using the command prompt
  • Connect to a database engine
  • View the properties of an instance in Configuration Manager
  • Review a database in object explorer
  • Connect to another database engine
  • Review associated registry keys for SQL Server installations

Video Download
WMV

Length: 18 Minutes 15 seconds


Module 1: Demo 2

In this demonstration you will see how to:

  • Analyze network protocols
  • Review TCP/IP settings
  • Analyze client protocols

Video Download
WMV

Length: 3 Minutes 36 seconds