SQL Server 2017 DATABASE ADMINISTRATOR - WEBINAR

SQL Server 2017 DATABASE ADMINISTRATOR - WEBINAR

Durasi :

6 Pertemuan  x 3 Jam 

Slot Jadwal (Pilih):

(09.00 - 12.00 OnTime)

(13.00 - 15.00 OnTime)

(19.30 – 22.30 OnTime)

Break Time : 30 Menit

Senin – Sabtu (Everyday)

Media :

Webinar Online

Google Hangout Group Conversation

Fasilitas :

Online Toolkit, Softcopy Module, Sertifikat (soft/hardcopy)

BIAYA ONLINE WEBINAR - KLIK

 

 

 

Silabus SQL Server 2017 DATABASE ADMINISTRATOR - WEBINAR

 

Deskripsi :

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network

Database administrators (DBAs) use specialized software to store and organize data. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.

Secara garis besar peserta dalam training SQL Server 2017 DATABASE ADMINISTRATOR akan belajar mengenai :

• Use T-SQL to create

• Use T-SQL to read data from a database
• Use T-SQL to Update data in a database
• Use T-SQL to delete data from a database
• Backup database
• Restore Database
• Create Indexes
• Monitor Performance of database
• Authenticate users or groups
• Assign Permissions
• Setup Auditing
• Use Activity Monitor
• Use Performance Monitor

• Import and Export Data


Target Peserta:

SQL Server DBA Staff, IT Manager, Public


Materi Bahasan :

Topics include:

–It is all about the Data


Introduction
What is a DBA
Databases
MSDN Virtual Labs
Importing and Exporting Data

–Database Backup and Restore

Introduction
Copy Database Backup Method
Full Database Backup
Differential Database Backup
Transaction Log Backup
Database Recovery
Lab Exercise 1
Lab Exercise 2
Conclusion

–SQL Server Configuration

SQL Server Configuration Manager
Checking Installed Services With PowerShell
Connecting to Instances of SQL Server
Identifying Installed Databases
Identifying Other Server Objects

–T-SQL Quick Guide

Introduction
T-SQL DML SELECT Query
T-SQL DML DELETE Query
T-SQL DML UPDATE Query
T-SQL DML INSERT Query
T-SQL DDL CREATE Query
T-SQL DDL ALTER Query
T-SQL DDL DROP Query
T-SQL DDL TRUNCATE Query
Conclusion

–SQL Server Performance Monitoring

Introduction
Using Activity Monitor
Collecting Data
Using Performance Monitor
Extended Events
Indexes

–Security

Introduction
Authentication
Permissions
Auditing
Conclusion

REGISTRASI SEKARANG  - KLIK

 

Atau hubungi Admin untuk informasi lebih lanjut :
Tel/WA : 0838-0838-0001 , info@purnamaAcademy.com

 

PERINGATAN :

STOP CORONA/ COVID-19 , LAKUKAN SOCIAL DISTANCING , JAGA KEBERSIHAN TANGAN, MAKAN BERGIZI , OLAHRAGA &  #DIAMDIRUMAH

 

 



Post a Comment

0 Comments