SQL Server Essentials for Oracle DBAs: (06) Data Protection
- Posted: Dec 28, 2012 at 9:09AM
- 9,930 views
Right click “Save as…”
Module 6 fulfills the twin tasks of protecting data against unauthorized access (database security) and also from the destructive interaction between authorized users working concurrently (concurrency control). Under security, the various features for securing and auditing the database are discussed. Under concurrency control, the most important topic is locking. Understanding the differences in the concurrency models utilized by Oracle and SQL Server is important in order to design and manage systems that can support a large user population, great performance and scalability.
Full course outline: