SQL Server for the Oracle DBA

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…

An overview of the differences and similarities between SQL Server and Oracle database technologies. Presented by SQL Server Technical Specialists Kristeen Kohrs and Mike Wilmot. Kristeen is a former Oracle employee (over 9 years).

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.…

Module 3 discusses the memory and process architectures that are key to a database's performance. The module goes into the details of the hierarchy of memory areas of an instance and its configuration. This module also describes how the various functions of the RDBMS are accomplished by the…

Module 15 shows the mechanisms by which the database can be monitored for availability, errors, and performance. Statistics that can be captured for both proactive and reactive administration of the databases are reviewed here. [03:59] - Error logs [10:50] - Error messages [19:50] - Monitoring…

Module 7 contains discussion on planning and installation of SQL Server. While basic duties such a creating, starting and shutting down a database are common to all databases, the options available for these functions are the key differences. True to the words “Knowledge is Power”, familiarity with…

Module 14 provides a high-level overview of the scalability and high availability features available in each RDBMS. Oracle and SQL Server are both enterprise class RDBMS, therefore the topics of scalability and high availability are deemed important. However, due to the scope of the course the…

Module 4 examines in greater detail the schema objects introduced in Module 2. While all schema objects are mentioned, of particular interest are tables, the type of data they can hold, and their storage layout. A proper understanding of data types and storage architecture of tables and indexes is…

Module 3 discusses the memory and process architectures that are key to a database's performance. The module goes into the details of the hierarchy of memory areas of an instance and its configuration. This module also describes how the various functions of the RDBMS are accomplished by the…

Module 13 is divided into two sections: tuning an instance and tuning an application. Tuning the instance involves taking steps to ensure that system resources such as memory, CPU and I/O are used efficiently. Tuning an application starts with the design and architecture of the application and…