Formations

Actualité

  • NATIVO Référencé OPCA
    Toutes nos formations peuvent être prises en charge par votre OPCA....
  • Toute l'actu sur notre blog

> Voir toutes les Formations SQL Server 2014

Formation M40074 - SQL Server 2014 pour les DBA Oracle

  • Durée : 4 jours
  • Lieu : Paris (La Défense)
  • Inscription
  • Prix : N.C.
  • Réf : M40074    
  • Devis
 

Formation également disponible aux dates que vous souhaitez
(en intra) Devis immédiat au 01 46 20 18 40

Dates et Réservations

 

Public

- Oracle database administrators (DBAs) who work in an enterprise-level environment and require the skills to begin supporting and maintaining a SQL Server database

Prérequis

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

Objectifs

- Provide students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server system
- Provides training for Oracle DBA to compare and contrast Oracle database management to SQL Server database management

Programme

Database and instances
Terminology concepts
Client interaction with database and instance
Understanding database limits

Instance architecture
Configuring a database server
Memory architecture overview
Understanding processes and threads in the database engine
Background processes

Database architecture
Schema and data storage
Tablespaces and datafiles
Logging and data dictionary

Data objects
Database tables
Schema objects
Data and data types
Non-native data types – Beyond relational

Data access
Comparing structured query language
Control and procedural statements
Developing robust queries

Basic administration
Installing SQL Server
Managing and configuring SQL Server
Working with SQL Server databases

Managing schema objects
Managing tables, constraints, object identifiers, and naming
Managing triggers
Managing indexes and views

Data protection and security
Securing the database
Managing users
Understanding privileges
Managing roles

Data transport
Getting data into and out of SQL Server
Understanding SQL Server Integration Services
Other transfer methods

Backup and recovery
Understanding database backups
Data recovery
Backup and recovery tools and solutions

Monitoring and performance tuning
SQL Server performance tuning
Managing memory and processes for SQL Server
Managing database interactions
Monitoring availability and errors
Monitoring performance

Scalability and high availability
Understanding availability
Replicating databases
Other methods to obtain availability

Microsoft SQL Server Migration Assistant
Install and configure SQL Server Migration Assistant
Migration projects
Migrating the data