Blog Post

SQL Server Essentials for Oracle DBAs: (05) Data Access

Sign in to queue

Description

Module 5 focuses on how data is accessed and manipulated by the clients. Important concepts such as transaction, session, and so on are discussed here. This module describes the various commands available through SQL for manipulating data, metadata, transactions, sessions, and instances. An overview of procedural extensions to the SQL language available in Oracle (PL/SQL) and SQL Server (Transact-SQL) is given in this module. Cursors, which are data structures used to convey results of user transactions, are discussed as well to provide insight into what SQL Server supports and how they are used compared to Oracle.

Full course outline:

Embed

Download

Download this episode

Download captions

The Discussion

Add Your 2 Cents