Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Pengantar ke SQL Server
- Ulasan arsitektur SQL Server
- Versi dan edisi
- Alat dan antarmuka Management
Pemasangan dan Konfigurasi
- Kebutuhan sistem
- Pemasangan SQL Server dan SSMS
- Konfigurasi awal dan keamanan
Database Management
- Membuat dan mengelola database
- Tabel, indeks, dan keterbatasan
- Operasi backup dan restore
Pengelolaan Pengguna dan Keamanan
- Kebijakan autentikasi
- Rol dan izin
- Audit dan kepatuhan
Memo Monitoring dan Penyetelan Kinerja
- Alat dan laporan pemantauan
- Teknik dasar optimisasi query
- Stra-tegi indeksasi
Otomatisasi dan Pemeliharaan
- SQL Server Agent dan pekerjaan
- Rencana pemeliharaan
- Backup otomatis dan notifikasi
Penyelesaian Masalah dan Pemulihan
- Riwayat kesalahan dan诊断和恢复
- 恢复模型
- 高可用性基础
总结与下一步行动
Requirements
- Pemahaman tentang konsep dasar basis data
- Pengalaman menggunakan sistem operasi Windows
- Ketahuan dengan kueri SQL dasar
Audience
- Administrators Database
- Pengelola sistem IT
- Tenaga dukungan teknis
40 Hours
Testimonials (5)
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.
Stefan
Course - SQL in SQL Server
Practical exercises for practice and understanding of the concept, clarification provided for any questions.
Safdar Abbas - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Interactive exercises
