KoleksiPelatihan Kelas
register

SQL server PowerShell

Description

Penonton & Prasyarat

Course Outline

Jadwal & Bayaran

Certification

SQL server PowerShell

PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language. Initially a Windows component only, known as Windows PowerShell

Prasyarat

Peserta ngirim kerja karo Powershell lan weruh cmdlets powershell Get, Set, foreach, yen, Uploaded, hash, Variables, pipeline, ngendi etc. Powershell programming dasar ora dilindhungi, mung SQL Server related Powershell bakal dilindhungi

Course Outline Duration: 2-3 Days

Day XCHARX 1

  • Ngatur Layanan SQL Server
  • Ngatur Protokol Jaringan Klien
  • Ngatur alias SQL Server Client
  • Ngatur Protokol Jaringan Server
  • Ganti SQL Server Advanced Properties
  • Ngawasi Kesalahan saka SQL
  • Log kesalahan server
  • Ngawasi Deadlocks
  • Pemantau pamblokiran
  • Ngawasi Database
  • Ngawasi Database Objects
  • sqlps Utility
  • SQLSERVER: Drive lan InvokeSqlcmd
  • Njupuk Informasi Versi
  • Informasi Server SQL Server

Day- 2

  • Informasi sing gegandhengan karo Server SQL Server
  • Informasi sing gegandhengan karo SQL Server Database
  • Ngganti Mode Login
  • Database Backup - Log Full, Differential & Transactional
  • Mulihake Backup - Gawe serep Full Backup & Transaksi Log
  • Database Administrasi
  • Server Inventarisasi Pusat
  • Database File Lokasi lan
  • Bangunan SQL Server Inventory
  • Instalasi SQL Server Cithakan
  • Ngumpulake Kinerja SQL Server lan Host Performance
  • Ngawasi SQL Server:
    • Pinging Hosts SQL Server
    • Priksa Layanan SQL sing gegandhengan karo SQL Server Hosts
    • Priksa Uptime of SQL Server
  • Ngawasi Disk Space Usage, Database
  • Ngawasi Disk Space Usage
  • Ngawasi Database Files

Day- 3

  • Ngawasi Serep
  • Rebuild Indexes
  • DBCC CHECKDB
  • SQL Server Command ayo
  • Nggunakake SMOs
    • Nginstal SMO
    • Ngakses Obyek SQL Server
    • Hirarki obyek SMO
  • Njupuk data lan metu saka SQL Server
    • Pasang Data menyang Tabel
    • Maca saka Tabel
  • Ngatur fungsi WMI lan cmdlet
    • Get-CimInstanceCimInstance
    • Get-CimAssociatedInstance
    • Get-CimClass
    • Win32_Service
    • Win32_Process
    • Win32_LogicalDisk
    • Win32_DiskPartition
  • Cara sing beda kanggo nutup sesi PS sawise rampung
    • matèni
    • Stop-Process

Mangga tulis ing info@itstechschool.com & hubungi kita ing + 91-9870480053 kanggo biaya kursus & biaya, jadwal & lokasi

Selehake We a Query

Kanggo informasi luwih lengkap hubungi kita.


reviews