Перейти на главную | Список курсов | Расписание | Заявка на курс | Cisco course on-line registration
Ищете что-то конкретное? Контакты ↓
Звоните +7 727 352 73 73 и +7 727 352 83 83 еще контакты или подайте заявку на курс

Основные направления ↓↑

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

☎ +7 (727) 352 73 73
☎ +7 (727) 352 83 83
☎ +7 (727) 352 71 58
☎ +7 (727) 352 71 59
asemciscotrain.kz
infociscotrain.kz
raushanciscotrain.kz
Гоголя 39, каб. 301
Казахстан, г. Алматы, ул. Казыбек би 22 офис 222, 050010

40074 Microsoft SQL Server 2014 for Oracle DBAs

32
09-12 марта

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

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.

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 instances


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

Module 2: Instance architecture


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

Module 3: Database architecture


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

Module 4: Data objects


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

Module 5: Data access


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

Module 6: Basic administration


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

Module 7: Managing schema objects


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

Module 8: Data protection and security


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

Module 9: Data transport


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

Module 10: Backup and recovery


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

Module 11: 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
§ Understanding threads
Lab: Part 2: Monitoring and performance tuning
§ SQL Server Profiler
§ Hints (T-SQL)
§ Plan guides
§ Setting alerts to automate monitoring
Lab: Part 3: Monitoring and performance tuning
§ Capture a SQL trace for use with Distributed Replay
§ Prepare trace data for use with Distributed Replay
§ Replay trace data using Distributed Replay
 

Module 12: Scalability and high availability


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

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