Звезды и С - Главная Звезды и С - Citrix Звезды и С - Microsoft Звезды и С - О нас

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

Специальные предложения
Software Assurance - Бесплатные курсы обучения по ваучерам
Авторские курсы Microsoft
Microsoft Windows Server 2012 R2 / 2016
Microsoft Windows 10 / 8.1
Облачные технологии: Microsoft Windows Azure, Private Cloud, Office 365
Microsoft Exchange Server 2013 / 2016
Microsoft System Center
Microsoft Lync Server 2013 / Skype for business 2015
Microsoft SQL Server 2014 / 2016
Microsoft SharePoint 2013 / 2016
Microsoft Visual Studio 2013 / 2016
Microsoft Forefront
Microsoft BizTalk Server
Microsoft On-Demand
Microsoft Dynamics
Обучение корпоративных пользователей
Более ранние версии программных продуктов Microsoft
Треки - до 2012г. (MCITP, MCTS, MCP)
Microsoft Windows Server 2008
Microsoft Windows Server 2003
Security on Microsoft Windows
Windows 7
Microsoft Windows XP
Microsoft Exchange Server 2010
Microsoft Exchange Server 2007
Microsoft SQL Server 2008
Microsoft SQL Server 2005
Microsoft SharePoint 2007, Project 2007
Microsoft Office Communications Server 2007
Microsoft Office PerformancePoint Server 2007
System Center
Microsoft SharePoint 2010
Авторские курсы A. Кибкало
Microsoft SharePoint 2013
Microsoft SQL Server 2012
Microsoft Visual Studio 2010
Microsoft SharePoint 2010
Microsoft SQL Server 2008
Microsoft Visual Studio 2008
Microsoft SQL Server 2005
Microsoft Visual Studio 2005
Microsoft SQL Server 2000
MS Visual C++ Development
MS Visual Basic Development
MS Solutions Framework
MS Internet/Intranet Application Development
Microsoft SharePoint Portal Server 2007, Project 2007
Microsoft BizTalk Server 2009
Расписание курсов Microsoft и Citrix в графическом формате
Вечернее обучение
Условия обучения
Обучение корпоративных пользователей

Курс 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-2019