Are you an Oracle database administrator (DBA)? You can leverage your skills and experience to manage a SQL Server 2014 system. Watch this training workshop to map, compare, and contrast Oracle database 12c management to that of SQL Server 2014. Beyond mere guidelines, this content is a reference guide intended to be delivered as a four-day workshop.
The course was developed to extend the terminologies familiar to the Oracle DBA and to relate those terminologies to the SQL Server world. This relate-and-learn approach can help you expand your knowledge to SQL Server database administration.
Instructor | Bill Ramos - Advaiya Vice President of Consulting Services
Gain an understanding of the two major components of a database system and how they interact to provide data requested by the clients. 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.
Discover the memory and process architectures that are key to a database's performance. This module goes into the details of the hierarchy of memory areas of an instance and its configuration, along with the changes Oracle has made in its internal architecture on the Windows platform and how they compare to SQL Server's implementation.
Explore the structure, components, and contents of the files that constitute the database, and learn the techniques by which storage is viewed (physical and logical) and allocated. Also covered in this module is how SQL Server 2014 supports placing data and log files on Azure Storage.
Examine the schema objects in both databases and get an introduction to the new SQL Server 2014 In-Memory OLTP tables and clustered Columnstore Index objects. A mapping of the native data types from Oracle to SQL Server shows which data types are compatible and which are not.
See how data is accessed and manipulated by the clients, and hear a discussion of important concepts, including transaction and session. This module describes the various commands available through SQL for manipulating data, metadata, transactions, sessions, and instances.
Follow a discussion on planning and installing SQL Server. Although basic duties, such as creating, starting, and shutting down a database, are common to all databases, the options available for these functions are the key differences. Get familiar with the data dictionary and the ways a SQL Server DBA uses it compared to an Oracle DBA.
Take a closer look at the administrative aspect of schema objects described in Module 4. The discussion covers planning, creating, and maintaining many key schema objects. See how choices, in terms of table and index types, column types, and storage, greatly influence the database growth, scalability, performance, and maintainability.
Learn about protecting data against unauthorized access (database security) and from the destructive interaction between authorized users working concurrently (concurrency control). Explore the various features for securing and auditing the database, and see new security features in SQL Server 2014.
Examine the non-transactional mechanisms for moving data into and out of a database, including how to copy databases to an Azure virtual machine using the SQL Server 2014 Deploy Database to Azure VM wizard. The module also reviews data mining and bulk data movement tools.
Hear about the types of errors encountered in a database and the various mechanisms available to safeguard against these errors. This module discusses various backup and recovery methods available, along with Oracle's Recovery Manager (RMAN) and the equivalent functionality available in SQL Server Management Studio.
Hear different approaches to instance and application tuning, along with the administration of resource types, like system resources (such as memory, processes, and storage) and low-level database resources (such as lock, latches, and queues). The session highlights new SQL Server 2014 capabilities around performance improvement and availability monitoring.
Get a high-level overview of the scalability and high-availability features available in each Relational Database Management System (RDBMS). The features discussed include AlwaysOn, parallel query, replication, clustering, table partitioning, database mirroring, and database snapshots.