Быстрые ссылки: Перейти на главную | Список курсов | Расписание | Заявка на курс | Ответы на вопросы экспертов
Ищите что-то конкретное?Контакты ↓

Наши контакты

☎ +7 (7172) 46 97 51
☎ +7 (777) 241 72 98
☎ +7 (747) 716 21 22
nataciscotrain.kz
asemciscotrain.kz
infociscotrain.kz
raushanciscotrain.kz
Гоголя 39, каб. 301
Казахстан, г. Астана, ул. Иманбаевой 8

MS 40045 - Microsoft SQL Server for Oracle DBAs город Астана

32

Содержание курса

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 workshop provides a quick start for the Oracle DBA to map, compare, and contrast the realm of Oracle database management to SQL Server database management. Each module also provides demos.

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:
§ Oracle DBA experience
§ Familiarity with Microsoft Windows platforms
§ Understanding of operating system fundamentals

Программа курса:

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
 

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
 

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
 

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
 

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
 

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
 

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
 

Module 9: Managing Schema Objects


§ Naming guidelines for identifiers in schema object definitions
§ Storage and structure of schema objects
§ Implementing data integrity using constraints
§ Implementing business rules at the database level
Lab: Managing Schema Objects
 

Module 10: Database Security


§ Manage access to database through user accounts
§ Control access to data through privileges and roles
§ Manage access to server using login accounts
Lab: Database Security
 

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 Server and across multiple data sources and destinations
Lab: Transferring Data
 

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
 

Module 13: Performance Tuning


§ Performance tuning methodologies
§ Tools and techniques for performance analysis and tuning
Lab: Distributed Replay
 

Module 14: Scalability and High Availability


§ Key high availability features available in Oracle and SQL Server
§ Key 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
 

Module 16: SQL Server Migration Assistant(SSMA)
 Подходит? Подать заявку на этот курс