Administering in Microsoft SQL Server
Corso
Online
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Metodologia
Online
-
Inizio
Scegli data
The course is designed for administrators, developers and database developers.
The objectives of the training:
acquire and strengthen the skills to create and manage databases
knowledge of the syntax and use SQL to retrieve and modify data
apply safety rules in the database
the use of advanced elements (replication, automation, BI)
the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Profilo del corso
Knowledge of computer and Windows operating system
Opinioni
Materie
- Server
- Microsoft SQL Server
- SQL
Programma
Basic information about databases
- Database files, Database Client / Server
- Relational database management systems (RDBMS)
- Express, Standard, Enterprise
- Workgroup, Mobile , Developer
- SQL Server Management Studio
- SQL Server Agent
- Database Services
- Analysis Services
- Reporting Services
- Integration Services
- Master
- Model
- Msdb
- Tempdb
- Distribution
- Resource
- The database files and their location
- File size and its growth
- Partitioning tables
- INSERT
- UPDATE
- DELETE
- Columns and Attributes
- Determine the type of data
- Indexes and Keys
- Clustered Indexes
- Non-Clustered Indexes
- REBUILD vs. REORGANIZE
- Procedures
- Views
- Functions
- Triggers
- Simple
- Full
- Bulk logged
- Full
- Differential
- Transaction Log
- Strategy full copy of the database
- Strategy of full backups and transaction log
- The strategy of incremental database backup
- Strategy copy of the database files
- Maintenance Plan
- Jobs
- Server Roles
- Database Roles
- SA Account
- Creating Accounts
- Schemes
- Log Shipping
- Database Mirroring
- Server Clustering
- Snapshot Replication
- Transactional Replication
- Merge Replication
- SQL Server Profiler
- In-Place vs. Side-By-Side
- Service-Pack
- Cluster
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Administering in Microsoft SQL Server