40074 - 40074 Microsoft SQL Server 2014 for Oracle DBAs
CLASS DATE(s):
Request a Class

COURSE LENGTH: 4 Days

COURSE COST: $1995.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

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.

AUDIENCE AND PREREQUISITES

This course is intended for experienced Oracle database administrators (DBAs) who work in an enterprise-level environment and require the skills to begin supporting and maintaining a SQL Server database.

Before attending this course, students must have:
- Oracle DBA experience
- Familiarity with Microsoft Windows platforms
- Understanding of operating system fundamentals

  

*Course Cost listed does not include the cost of courseware (required) or lunch (otional). Course subject to minimum enrollment. If minimum enrollment is not met, this course may run as a Live Distance Learning session. If you have any questions, please contact us (learn@vtec.org or 207-775-0244)

COURSE TOPICS:


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
Lab : Part 2: Monitoring and performance tuning
Lab : Part 3: Monitoring and performance tuning

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