Blog Post

SQL Server Essentials for Oracle DBAs: (02) Database Architecture

Sign in to queue

Description

Module 2 goes in-depth into structure, components and contents of the files that constitute the database. To be able to manage hundreds of gigabytes, terabytes, or even petabytes of data, it is important to learn the techniques by which storage is viewed (physical and logical) and allocated. Databases use various hierarchies of storage structures such as blocks, extents, segments and table spaces to control storage allocation. The definition of schema and the objects that comprise the schema are introduced here. SQL Server uses similar techniques as Oracle; however the differentiation from Oracle is in the functionality.

Full course outline:

Embed

Download

Download this episode

Download captions

The Discussion

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.