Blog Post

SQL Server Essentials for Oracle DBAs: (01) Database and Instance

Play SQL Server Essentials for Oracle DBAs: (01) Database and Instance
Sign in to queue


Module 1 provides an understanding of the two major components of a database system. The database constitutes the files that store data, and the instance is the collection of server resources that provide a powerful, high performance interface to the data. It also illustrates how the two interact to provide data requested by the clients. Viewing the database and the instance as two separate interactive components of the RDBMS helps us to divide-and-conquer the vast set of topics covered in this workshop.

  • [05:47] - SQL Server Instance Environment
  • [15:14] - Client interaction with Database and Instance
  • [24:51] - Database capacities

Full course outline:



Download this episode

Download captions

The Discussion

Add Your 2 Cents