40074 Microsoft® SQL Server® 2014 for Oracle DBAs

Overview

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. Students will be training for Oracle DBA to compare and contrast Oracle database management.

Objectives

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.

Audience

This course 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.

Syllabus

Database and instances

  • Terminology concepts
  • Client interaction with database and instance
  • Understanding database limits

Instance architecture

  • Configuring a database server
  • Memory architecture overview
  • Understanding processes and threads in the database engine
  • Background processes
  • Lab : Instance architecture

Database architecture

  • Schema and data storage
  • Tablespaces and datafiles
  • Logging and data dictionary
  • Lab : Database architecture

Data objects

  • Database tables
  • Schema objects
  • Data and data types
  • Non-native data types – Beyond relational
  • Lab : Data objects

Data access

  • Comparing structured query language
  • Control and procedural statements
  • Developing robust queries
  • Lab : Data access

Basic administration

  • Installing SQL Server
  • Managing and configuring SQL Server
  • Working with SQL Server databases
  • Lab : Basic administration

Managing schema objects

  • Managing tables, constraints, object identifiers, and naming
  • Managing triggers
  • Managing indexes and views
  • Lab : Managing schema objects

Data protection and security

  • Securing the database
  • Managing users
  • Understanding privileges
  • Managing roles
  • Lab : Data protection and security

Data transport

  • Getting data into and out of SQL Server
  • Understanding SQL Server Integration Services
  • Other transfer methods
  • Lab : Data transport

Backup and recovery

  • Understanding database backups
  • Data recovery
  • Backup and recovery tools and solutions
  • Lab : Backup and recovery

Monitoring and performance tuning

  • SQL Server performance tuning
  • Managing memory and processes for SQL Server
  • Managing database interactions
  • Monitoring availability and errors
  • Monitoring performance
  • Lab : Part 1: Monitoring and performance tuning
  • Lab : Part 2: Monitoring and performance tuning
  • Lab : Part 3: Monitoring and performance tuning

Scalability and high availability

  • Understanding availability
  • Replicating databases
  • Other methods to obtain availability

Microsoft SQL Server Migration Assistant

  • Install and configure SQL Server Migration Assistant
  • Migration projects
  • Migrating the data

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 4 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

SQL Server Integration Services
Worldwide
This skill has an average salary of
US$82,419
and is mentioned in
0.09%
of job ads.
High availability
Worldwide
This skill has an average salary of
US$95,204
and is mentioned in
0.28%
of job ads.
Microsoft SQL Server
Worldwide
This skill has an average salary of
US$87,308
and is mentioned in
1.59%
of job ads.
Oracle Database
Worldwide
This skill has an average salary of
US$90,423
and is mentioned in
1.97%
of job ads.