Microsoft SQL Server 2014 for Oracle DBAs
Описание
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
Расписание
Курс не запланирован.
Вы можете подать заявку на открытие курса: