Estendere le competenze esistenti come DBA Oracle a SQL Server.
Gestire SQL Server utilizzando la stessa prospettiva di un DBA Oracle.
Comprendere l'architettura sottostante di SQL Server.
Gestire il sistema di SQL Server, i database, e gli utenti.
Gestire file di database da backup o di migrazione verso altri sistemi.
Definire e implementare soluzioni di monitoraggio e messa a punto del sistema di SQL Server.
Esprimere le opzioni High Availability a SQL Server.
Spiegare il processo e lo strumento per la migrazione di schemi Oracle a database di SQL Server.
Per partecipare al corso, gli studenti devono avere:
Esperienza DBA OracleFamiliarità con piattaforme Microsoft WindowsComprensione dei fondamenti del sistema operativo
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
Using the Resource Governor
View multi-instance shared resources
Module 3: Database architecture
Schema and data storage
Tablespaces and datafiles
Logging and data dictionary
Lab : Database architecture
Working with filegroups
Module 4: Data objects
Database tables
Schema objects
Data and data types
Non-native data types – Beyond relational
Lab : Data objects
Create a partitioned table
Module 5: 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
Module 6: 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
Module 7: 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
Module 8: 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
Module 9: 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
Module 10: 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
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