Курсы Microsoft

Microsoft SQL Server & Power BI

MS40074 Microsoft SQL Server 2014 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 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
• Install and configure SQL Server Migration Assistant
• Migration projects
• Migrating the data