TypeHo Koetlisa Sekolo
Ngodisa

SQL Server PowerShell

Tlhaloso

Bamameli le Litlhokahalo

Tlhahiso ea Tlhahlobo

Kemiso le Litefiso

tiiseletswe

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

batlehang

Barupeluoa ba lokela ho sebetsa le Powershell mme ba tsebe matlahell cmdlets Fumana, Beha, pele, haeba, ho na le, ha, Variables, pipeline, kapa joalo. Powershell merero ea motheo e sa koahetsoeng, ke feela SQL Server e amanang le Powershell e tla koaheloa

Course Outline Duration: 2-3 Days

Day XCHARX 1

  • Ho laola Litšebeletso tsa SQL Server
  • Ho laola Melao-motheo ea Molaetsa oa Mecha
  • Ho laola Likarabo tsa bareki ba SQL Server
  • Ho laola Melao-motheo ea Seraka ea Seratso
  • Ho fetola SQL Server Advanced Properties
  • Ho Hlahloba liphoso tse tsoang SQL
  • Konopo ea Phoso ea Seva
  • Ho hlahloba Deadlocks
  • Ho shebella thibelo
  • Litsela tsa Boitsebiso
  • Ho hlahloba Lintlha tsa Boitsebiso
  • Setebelisoa sa sqlps
  • SQLSERVER: Drive le InvokeSqlcmd
  • Ho fumana Boitsebiso ba Version
  • SQL Server Information SPID

Letsatsi- 2

  • SQL Server Information-Related Information
  • SQL Server Information-Related Information
  • Ho fetola tsela ea ho kena
  • Molemo oa ho boloka boitsebiso - Tlaleho e feletseng, e fapaneng le ea transaction
  • Ho tsosolosa Backup - Backup e feletseng le Transaction Log Backup
  • Lefapha la Tsamaiso ea Tsamaiso
  • Sesebelisoa sa Inventory Centralized
  • Sebaka sa Fumaneha sa Fumaneha le
  • Ho haha ​​SQL Server Inventory
  • Setšoantšo sa Sethaleng sa SQL Server
  • Ho bokella SQL Server Performance le Host Performance
  • Ho hlahloba SQL Server:
    • Pinging SQL Server Hosts
    • Ho hlahloba Litšebeletso tse amanang le SQL Server ho Baemeli ba SQL Server
    • Ho hlahloba Nako ea Bofelo ea SQL Server
  • Tlhokomelo ea Tšebeliso ea Disk Space, Database
  • Tlhokomelo ea Tšebeliso ea Disk Space
  • Ho hlahloba Lintlha tsa Files

Letsatsi- 3

  • Ts'ebetso ea ho hlahloba
  • Litlaleho tse hahang
  • DBCC CHECKDB
  • SQL Server Command e lumelle
  • Ho sebelisa SMOs
    • Ho kenya SMO
    • Ho fihlella Lintho tsa SQL Server
    • Lintho tsa SMO Hierarchy
  • Ho fumana boitsebiso le ho tsoa SQL Server
    • Kenya Data ho Letlapa
    • Bala ho Letlapa
  • Ho laola mesebetsi ea WMI le cmdlets
    • Fumana-CimInstanceCimInstance
    • Fumana-CimAssociatedInstance
    • Fumana-CimClass
    • Win32_Service
    • Win32_Process
    • Win32_LogicalDisk
    • Win32_DiskPartition
  • Mekhoa e fapaneng ea ho koala liboka tsa PS kamora ho phethoa
    • bolaea
    • Emisa-Tshebetso

Re kopa o re ngolle info@itstechschool.com & re ikopanye le rona ka + 91-9870480053 bakeng sa theko ea theko le theko ea tiiso, kemiso le sebaka

Re Tlisetsa Potso

Bakeng sa lintlha tse ling ka mosa iteanye le rona.


Reviews