Microsoft SQL Server 2014 for Oracle DBAs

Request more details:

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.
Before attending this course, students must have:
- Oracle DBA experience
- Familiarity with Microsoft Windows platforms
- Understanding of operating system fundamentals
Database and instances:
- Terminology concepts
- Client interaction with database and instance
- Understanding database limits

After completing this module, you will be able to:
- Clearly define database and instance within the context of this course.
- Understand some key differences and similarities in how Microsoft and Oracle implement the database and instance in their product solutions.
- Understand client interaction between a database and instance.
- Recognize some key limitations of the database and instance components within Oracle Database and SQL Server systems.
Instance architecture:
- Configuring a database server
- Memory architecture overview
- Understanding processes and threads in the database engine
- Background processes

Lab : Instance architecture
- Using the Resource Governor
- View multi-instance shared resources

After completing this module, you will be able to:
- Configure a database server.
- Identify key database memory structures.
- Identify memory areas inside the Oracle System Global Area (SGA) and their equivalents in Microsoft SQL Server.
- Understand process- and thread-based architecture relevant to a relational database management system (RDBMS).
- Control resources in SQL Server.
- Detail client interaction with the database server.
- Understand background processes and threads.
Database architecture:
- Schema and data storage
- Tablespaces and datafiles
- Logging and data dictionary

Lab : Database architecture
- Working with filegroups

After completing this module, you will be able to:
- Understand schema and schema objects.
- Identify logical and physical structures using storage organization.
- Explain the architecture of data storage components and their hierarchy and relationships.
- Manage storage structures.
- Understand how to build the database using physical and logical definition storage structures.
- Comprehend the transaction logging model employed to perform transaction recovery and rollback.
- Distinguish major differences between the construction of the data dictionary in Oracle and Microsoft SQL Server.
Data objects:
- Database tables
- Schema objects
- Data and data types
- Non-native data types Beyond relational

Lab : Data objects
- Create a partitioned table

After completing this module, you will be able to understand:
- The organization of data in tables and the various forms of data.
- The supporting schema objects.
- Types of data that can be stored in tables.
- Organization and presentation of data in complex real-world forms.
- Storage organization of the schema objects.
Data access:
- Comparing structured query language
- Control and procedural statements
- Developing robust queries

Lab : Data access
- Query designer
- Concatenation and SQL injection
- Stored procedures
- Cursors

After completing this module, you will be able to:
- Identify the components of the relational engine and their roles in processing SQL.
- Understand the basic concepts of Structured Query Language (SQL).
- Define procedural SQL constructs and their mechanisms.
- Identify query optimization by the relational engine and user overrides.
- Understand transaction management.
Basic administration:
- Installing SQL Server
- Managing and configuring SQL Server
- Working with SQL Server databases

Lab : Basic administration
- Defining a user database
- Setting configuration parameters
- Filegroup maintenance

After completing this module, you will be able to:
- Plan and install SQL Server software.
- Create and configure an instance.
- Plan and create a database.
- Identify the various states in which a database can exist.
- Understand the data dictionary.
Managing schema objects:
- Managing tables, constraints, object identifiers, and naming
- Managing triggers
- Managing indexes and views

Lab : Managing schema objects
- Creating tables and associated objects
- Creating indexed views

After completing this module, you will be able to:
- Understand identifier and naming conventions.
- Manage tables and indexes.
- Select storage parameters.
- Manage constraints and triggers.
- Manage views and sequences/identity columns.
- Review dependencies within the database.
Data protection and security:
- Securing the database
- Managing users
- Understanding privileges
- Managing roles

Lab : Data protection and security
- Creating logins and users
- Grant permissions
- Revoke permissions
- Separation of duties

After completing this module, you will be able to:
- Implement security using the hierarchical structure of each login, user, role, and profile.
- Monitor database activity with auditing.
- Create and maintain login accounts.
- Create and maintain user accounts.
- Create and maintain user defined roles.
- Manage privileges for users and roles.
Data transport:
- Getting data into and out of SQL Server
- Understanding SQL Server Integration Services
- Other transfer methods

Lab : Data transport
- Use SQL Server Integration Services to migrate data into a flat file
- Use SQL Server Integration Services to import data from a flat file

After completing this module, you will be able to:
- Understand the tools and functionality in Oracle and their equivalents in SQL Server for moving data in and out of the database.
- Understand the tools and functionality in SQL Server to transport data into, out of, and within a database, as well as across multiple databases, multiple file formats, and other data sources and destinations.
Backup and recovery:
- Understanding database backups
- Data recovery
- Backup and recovery tools and solutions

Lab : Backup and recovery
- Create and execute a maintenance plan for backup
- Modify, backup, and restore a database

After completing this module, you will be able to:
- Identify database errors and various types of failure.
- Understand the various backup methods.
- Obtain a high-level understanding of recovery methods.
- Identify tools native to a relational database management system (RDBMS) that are used for backup and recovery.
- Explore vendor solutions for backup and redundancy.
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

After completing this module, you will be able to:
- Identify the monitoring requirements of a database.
- Distinguish sources of information for server, database, and instance activity.
- Identify server and database components that can be monitored.
- Examine SQL Server tools for monitoring.
- Create a methodology to develop an application and its related database with optimal performance.
- Understand the methodologies involved in tuning a running instance.
- Identify key elements in instance, database, and application tuning.
Scalability and high availability:
- Understanding availability
- Replicating databases
- Other methods to obtain availability

After completing this module, you will be able to:
- Define high availability and understand its requirements.
- Compare high availability features in Oracle and SQL Server.
- Define scalability and understand its requirements.
- Compare scalability features in Oracle and SQL Server.
Microsoft SQL Server Migration Assistant:
- Install and configure SQL Server Migration Assistant
- Migration projects
- Migrating the data

After completing this module, you will be able to:
- Install SQL Server Migration Assistant (SSMA) and extension packs.
- Configure SSMA.
- Emulate Oracle packages, sequences, and Oracle-style exception handling within SQL Server.
- Generate migration assessment reports.
- Convert and migrate a schema.
- Migrate data.
- Convert procedures, functions, views, and triggers.
- Perform migration testing.