TOP HOT – מסלולי הכשרה המבוקשים של נאיה קולג’

חייגו עכשיו: 073-2865544

Practical Microsoft SQL Server for the Oracle DBA’s


This course is to help Oracle database administrators (DBAs) leverage their skills and experience as an Oracle DBA to manage a Microsoft SQL Server system. This workshop provides a quick start for the Oracle DBA to map, compare and contrast the realm of Oracle database management to Microsoft SQL Server database management and all the important and common day-to-day tasks required for each SQL Server user.

At a fundamental level, Oracle and SQL Server are very similar. Their architectures are comparable, and their administrative features and functions are typical to a relational database management system.

After completing this course, you will be able to:

  • Extend your existing competencies as an Oracle DBA 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
  • Express High Availability options to SQL Server

This course is for the experienced Oracle database administrators (DBAs) who works in an enterprise-level environment and requires the skills to begin supporting and maintaining a SQL Server database.

Introduction to the SQL Server database

Introduction to SQL Server platform

  • Instances and Databases in SQL Server
    • Basic architecture of instances and databases in SQL Server
    • System databases and User databases
  • Using the SQL Server Management Studio and other tools
  • SQL Server main services

Creating a database

SQL Server Storage structures

  • Filegroups, DB Files and the Transaction Log.
  • Enlarging and Shrinking datafiles

Common “How To” differences between Oracle and SQL Server for basic operations

  • Identity columns and Sequences
  • Transaction handling in SQL Server
  • CTAS (Create table as SELECT.. )
  • Concatenation
  • TOP n Queries
  • Casting and converting
  • Case sensitivity

Application DBA

Table and index design in SQL Server

  • Heap, Clustered and Partitioned tables
  • Common Data Types
  • Clustered vs. Non-Clustered indexes
  • Special index features in SQL Server (Included column & Filtered indexes)

Transact SQL and code objects

  • Basic structures and syntax (Variables, conditions, Loops..)
  • Temp tables
  • Writing and invoking User-Defined functions and procedures
  • DML and DDL Triggers
  • Error handling

Managing SQL Server – Backup and recovery, data moving and Security

Backup and Recovery in SQL Server

  • Recovery Models
  • The Transaction Log
  • Backup types
  • Performing recovery

Exporting and Importing data

  • Using the “Export and Import Wizard”
  • Using SSMS generated scripts.
  • Using the BCP utility

SQL Server security model

  • Working with Logins and Users
  • Windows Logins vs. SQL Server Logins
  • Privileges and Roles in SQL Server
  • The SYSADMIN role and DBO user.

Managing SQL Server – Automation, monitoring and HA

Automation and jobs in SQL Server

  • Introduction to the SQL Server Agent
  • Managing SQL Server Agent jobs
  • Working with Alerts
  • Sending emails from SQL Server

SQL Server high availability solutions – Overview

  • Log shipping
  • Database mirroring
  • Server Clustering
  • Always-on 2012
  • Replication

SQL Server most recent release new features – Overview


Monitoring SQL Server

  • Viewing execution plans (Estimated and actual)
  • Viewing and releasing locks
  • The Activity Monitor
  • Dynamic Management Views (DMVs) and system tables
  • The Windows Performance Monitor and SQL Server counters
  • The Profiler
  • Database Engine Tuning Advisor
  • Data collection and Management Data Warehouse

Simulating, Monitoring and Optimizing Activity

In this part we will demonstrate an applicative load on SQL Server and we will examine the haw we can monitor the activity, collect performance data and apply tuning methods to optimize performance.

  • Reviewing Monitoring Tools
  • Setting up Simulating Environment
  • Configuring Monitoring Tools
  • Generating Database Activity
  • Viewing and Exploring Monitoring Findings
  • Discussing Performance Issues
  • Applying Optimizations
ערן קורןערן הינו יועץ מוביל ובכיר בנאיה טכנולוגיות בתחום מסדי נתונים ו-Big Data. במסגרת תפקידו ערן מתמחה בניהול מסדי נתונים, בניית ארכיטקטורה, וכן בפלטפורמות NoSQL מובילות בעולם ה- Big Data.
  • על פי דרישה מועד פתיחה
  • 09:00-16:30daysימים ושעות
  • 24academic hours שעות אקדמיות
  • מתקדםcourse levelרמת הקורס
  • עברית/Englishlanguageשפת הדרכה
  • לבדיקת התאמה לקורס
  • [current_url]

    השאירו פרטים ונחזור אליכם בהקדם!

Call Now Button דילוג לתוכן