Курсы Microsoft

Microsoft SQL Server & Power BI

MS40045 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)
• Assessing tasks
• Converting codes
• Migrating data
• Testing
• Deployment