Звезды и С - Центр обучения и тестирования

Спец. предложения|Обучение|Вебинары|Сертификация|Тестирование|О нас|Работа с сайтом|Новости|Поиск
Обучение

Специальные предложения
Citrix
Microsoft - Системные инженеры и администраторы MCSA, MCSE
Microsoft - Разработчики MCSD, MCSE
Microsoft SQL Server 2014 / 2016
Microsoft Visual Studio 2013 / 2016
Microsoft SharePoint 2013 / 2016
Microsoft Windows Azure
Microsoft BizTalk Server
Более ранние версии программных продуктов Microsoft
Расписание курсов Microsoft в графическом формате
Microsoft Dynamics
Обучение корпоративных пользователей
Software Assurance - Бесплатные курсы обучения по ваучерам
Microsoft On-Demand
VMware
ITIL
Вечернее обучение
Условия обучения
Linux
Cisco

Курс M40045: Microsoft® SQL Server® for Oracle DBAs

Цена для физических лиц, р.: 23900
Цена для юридических лиц, р.: 25900
Цена вебинара для физических лиц, р.: 21900
Цена вебинара для юридических лиц, р.: 21900

Продолжительность курса (дней): 4

Даты (день):

Даты (вечер):

Курс готовит к тестам:

Цель: This four-day instructor-led 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. This course provides training for Oracle DBA to compare and contrast Oracle database management to SQL Server database management.

Необходимая подготовка:

Предварительный тест:

Результат:

План курса:

Module 1: Database and Instance

  • Defining a Database and an Instance
  • Introducing Microsoft’s and Oracle’s implementation of a database and an instance
  • Understanding client interaction
  • Key database and instance limitations

Module 2: Database Architecture

  • Schema and Data Structure (Objects)
  • Storage Architecture
  • Logging Model, Data Dictionary
  • Lab: Database Architecture
  • Working with Filegroups

Module 3: Instance Architecture

  • Configure a Database server
  • Memory Architecture Overview
  • Memory Areas and Their Functions
  • Process and Thread Architecture
  • Controlling Resources in SQL Server 2008
  • Client and RDBMS Interactions
  • Background Processes/Threads and Their Functions
  • Lab: Instance Architecture
  • Using the Resource Governor
  • View Multi-Instances Shared Resources

Module 4: Data Objects

  • Tables are the main objects that store data
  • Indexes, views, stored programs, and other objects are the support structures
  • Various table types compared based on data organization
  • Various index types compared
  • Native and non-native data type support
  • Block-level storage architecture
  • Lab: Data Objects
  • Create a Partitioned Table
  • Working with Constraints and Triggers

Module 5: Data Access

  • Introduce database components involved in data access
  • Introduce concepts of Transact-SQL and Procedural SQL as tools to access and manipulate data
  • Discuss transactional management concepts
  • Lab: Data Access
  • Query Designer
  • Concatenation and SQL Injection
  • Stored Procedures, Using Cursors

Module 6: Data Protection

  • Protecting data from unauthorized users and authorized users
  • Using locking modes to achieve concurrency and consistency
  • Implementing database security features
  • Using auditing features to monitor database activity
  • Lab: Data Protection
  • Working with SQL Server security
  • Applying Permissions in a SQL Server Database

Module 7: Basic Administration

  • Planning and preparatory steps for a SQL Server environment
  • Creation and configuration of an instance of SQL Server and databases
  • Characteristics of a database
  • Basic database maintenance tasks
  • Lab: Creating Databases and Setting Configuration Parameters
  • Defining a User Database
  • Setting Configuration Parameters

Module 8: Server Management

  • Server-level and instance-level resources such as memory and processes
  • Database-level resources
  • User sessions and their activity
  • Concurrency structures
  • Lab: Resource Utilization
  • Understanding threads
  • Filegroup maintenance

Module 9: Managing Schema Objects

  • Naming guidelines for identifiers in schema object definitions
  • Storage and structure of schema objects
  • Data integrity using constraints
  • Implementing business rules at the database level
  • Lab: Managing Schema Objects
  • Creating Tables and Associated Objects
  • Maintaining Tables
  • Creating Indexed Views

Module 10: Database Security

  • Manage access to database through user accounts and control access to data through privileges and roles
  • Manage access to server using login accounts
  • Lab: Database Security
  • Create Logins and Users
  • Grant and Revoke Permissions

Module 11: Data Transport

  • Tools and functionality in Oracle and their equivalents in SQL Server in data transport out and into the database
  • Tools and functionality in SQL Server for data transport within SQL and across multiple data sources and destinations
  • Lab: Transferring Data
  • Use SSIS to Migrate Data Into a Flat File
  • Use SSIS to Import Data from a Business Partner’s Flat File

Module 12: Backup and Recovery

  • Backup and recovery methods available in Oracle and SQL Server 2008
  • Types of failure, Types of recovery
  • Lab: Create and Execute a Maintenance Plan for Backup
  • Modify, Back up, and Restore a database

Module 13: Performance Tuning

  • Performance tuning methodologies
  • Tools for performance analysis and tuning
  • Lab: Distributed Replay
  • Capture a SQL Trace for use with Distributed Replay and prepare Trace Data for use with Distributed Replay
  • Replay Trace data using Distributed Replay

Module 14: Scalability and High Availability

  • Key high availability and scalability features available in Oracle and SQL Server

Module 15: Monitoring

  • Formulate requirements and identify resources to monitor database
  • Types of monitoring
  • Tools for monitoring
  • Lab: Integrating Performance Monitor Data in SQL Profiler
  • Integrating Performance Monitor Data

Module 16: SQL Server Migration Assistant (SSMA)

  • Queue Management
  • Lab: Create and Manage Queues
  • Create a New Public Queue for Incoming Questions
  • Assessing tasks, Converting codes
  • Migrating data, Testing, Deployment


  Спец. предложения|Обучение|Вебинары|Сертификация|Тестирование|О нас|Работа с сайтом|Новости|Поиск

   Тел: +74953633686 email: info@stars-s.ru

   125040, Москва, Ленинградский проспект, д. 5, стр. 2, под. 5, офис "Звезды и С"

  © Учебный центр "Звезды и С", 1991-2017