This course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server system. It is intended for experienced Oracle database administrators (DBAs) who work in an enterprise-level environment and require the skills to begin supporting and maintaining a SQL Server database.
After completing this course, students will be able to extend their existing competencies as Oracle DBAs to SQL Server; manage SQL Server using the same perspective of an Oracle DBA; understand the underlying architecture of SQL Server; manage the SQL Server system, databases, and users; manage database files by backing up or migrating to other systems; define and implement monitoring and tuning solutions to the SQL Server system; express High Availability options to SQL Server; explain the process and tool to migrate Oracle schemas to SQL Server databases.
Before attending this course, students must have the following pre-requisites:
Oracle DBA experience
Familiarity with Microsoft Windows platforms
Understanding of operating system fundamentals
Module 1: Database and Instances
Client interaction with database and instance
Understanding database limits
Clearly define database and instance within the context of this course.
Understand some key differences and similarities in how Microsoft and Oracle implement the database and instance in their product solutions.
Understand client interaction between a database and instance.
Recognize some key limitations of the database and instance components within Oracle Database and SQL Server systems.
Module 2: Instance Architecture
Configuring a database server
Memory architecture overview
Understanding processes and threads in the database engine
Lab: Instance architecture
Using the Resource Governor
View multi-instance shared resources
Configure a database server.
Identify key database memory structures.
Identify memory areas inside the Oracle System Global Area (SGA) and their equivalents in Microsoft SQL Server.
Understand process- and thread-based architecture relevant to a relational database management system (RDBMS).
Control resources in SQL Server.
Detail client interaction with the database server.
Understand background processes and threads.
Module 3: Database Architecture
Schema and data storage
Tablespaces and datafiles
Logging and data dictionary
Lab: Database architecture
Working with filegroups
Understand schema and schema objects.
Identify logical and physical structures using storage organization.
Explain the architecture of data storage components and their hierarchy and relationships.
Manage storage structures.
Understand how to build the database using physical and logical definition storage structures.
Comprehend the transaction logging model employed to perform transaction recovery and rollback.
Distinguish major differences between the construction of the data dictionary in Oracle and Microsoft SQL Server
Module 4: Data Objects
Data and data types
Non-native data types - Beyond relational
Lab: Data objects
Create a partitioned table
The organization of data in tables and the various forms of data.
The supporting schema objects.
Types of data that can be stored in tables.
Organization and presentation of data in complex real-world forms.
Storage organization of the schema objects.
Module 5: Data Access
Comparing structured query language
Control and procedural statements
Developing robust queries
Lab: Data access
Concatenation and SQL injection
Identify the components of the relational engine and their roles in processing SQL.
Understand the basic concepts of Structured Query Language (SQL).
Define procedural SQL constructs and their mechanisms.
Identify query optimization by the relational engine and user overrides.
Understand transaction management.
Module 6: Basic Administration
Installing SQL Server
Managing and configuring SQL Server
Working with SQL Server databases
Lab: Basic administration
Defining a user database
Setting configuration parameters
Plan and install SQL Server software.
Create and configure an instance.
Plan and create a database.
Identify the various states in which a database can exist.
Understand the data dictionary.
Module 7: Managing Schema Objects
Managing tables, constraints, object identifiers, and naming
Managing indexes and views
Lab: Managing schema objects
Creating tables and associated objects
Creating indexed views
Understand identifier and naming conventions.
Manage tables and indexes.
Select storage parameters.
Manage constraints and triggers.
Manage views and sequences/identity columns.
Review dependencies within the database.
Module 8: Data Protection and Security
Securing the database
Lab: Data protection and security
Creating logins and users
Separation of duties
Implement security using the hierarchical structure of each login, user, role, and profile.
Monitor database activity with auditing.
Create and maintain login accounts.
Create and maintain user accounts.
Create and maintain user defined roles.
Manage privileges for users and roles.
Module 9: Data Transport
Getting data into and out of SQL Server
Understanding SQL Server Integration Services
Other transfer methods
Lab: Data transport
Use SQL Server Integration Services to migrate data into a flat file
Use SQL Server Integration Services to import data from a flat file
Understand the tools and functionality in Oracle and their equivalents in SQL Server for moving data in and out of the database.
Understand the tools and functionality in SQL Server to transport data into, out of, and within a database, as well as across multiple databases, multiple file formats, and other data sources and destinations.
Module 10: Backup and Recovery
Understanding database backups
Backup and recovery tools and solutions
Lab: Backup and recovery
Create and execute a maintenance plan for backup
Modify, backup, and restore a database
Identify database errors and various types of failure.
Understand the various backup methods.
Obtain a high-level understanding of recovery methods.
Identify tools native to a relational database management system (RDBMS) that are used for backup and recovery.
Explore vendor solutions for backup and redundancy.
Module 11: Monitoring and Performance Tuning
SQL Server performance tuning
Managing memory and processes for SQL Server
Managing database interactions
Monitoring availability and errors
Lab: Part 1: Monitoring and performance tuning
Lab: Part 2: Monitoring and performance tuning
SQL Server Profiler
Setting alerts to automate monitoring
Lab: Part 3: Monitoring and performance tuning
Capture a SQL trace for use with Distributed Replay
Prepare trace data for use with Distributed Replay
Replay trace data using Distributed Replay
Identify the monitoring requirements of a database.
Distinguish sources of information for server, database, and instance activity.
Identify server and database components that can be monitored.
Examine SQL Server tools for monitoring.
Create a methodology to develop an application and its related database with optimal performance.
Understand the methodologies involved in tuning a running instance.
Identify key elements in instance, database, and application tuning.
Module 12: Scalability and High Availability
Other methods to obtain availability
Define high availability and understand its requirements.
Compare high availability features in Oracle and SQL Server.
Define scalability and understand its requirements.
Compare scalability features in Oracle and SQL Server.
Module 13: Microsoft SQL Server Migration Assistant
Install and configure SQL Server Migration Assistant
Migrating the data
Install SQL Server Migration Assistant (SSMA) and extension packs.
Emulate Oracle packages, sequences, and Oracle-style exception handling within SQL Server.
Generate migration assessment reports.
Convert and migrate a schema.
Convert procedures, functions, views, and triggers.
If you need training for 3 or more people, you should ask us about onsite training. Putting
aside the obvious location benefit, content can be customised to better meet your
business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or
simply mention it when we contact you.