SQL Server Essentials for Oracle DBAs: (05) Data Access
- Posted: Dec 28, 2012 at 9:09AM
- 10,339 views
Right click “Save as…”
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: