facebook

Kurs:

Administering a SQL Database Infrastructure

Srednji

40 časova

Digitalni materijali/pristup lab okruženju

Sertifikat o pohađanju kursa

Pristup snimljenim predavanjima 45 dana

Zašto ovaj kurs?

Ovaj kurs vas sistematski vodi kroz sve ključne aspekte administracije, pružajući vam vještine potrebne za pouzdano i efikasno upravljanje bazama podataka u savremenom IT okruženju.

Kroz praktičan rad i detaljno obrađene cjeline, polaznici usvajaju znanja o sigurnosnim mehanizmima, zaštiti podataka, backup procedurama, automatizaciji zadataka i naprednim funkcijama neophodnim za svakodnevno upravljanje bazama.

Anliza podataka putem programa Excel

Kome je namijenjen ovaj kurs?

Namijenjen je svima koji već rade sa SQL bazama podataka i žele da unaprijede svoje administrativne vještine, ali i onima koji teže da karijeru usmjere ka upravljanju bazama podataka. Bez obzira na trenutni nivo iskustva, kurs pruža čvrstu osnovu i konkretna znanja za rad u administraciji SQL Server 2016 okruženja.

Plan i program kursa:

1. SQL Server Security
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Connect to databases
  • Authorization Across Servers
  • Partially Contained Databases
2. Assigning Server and Database Roles
  • Working with server roles
  • Working with Fixed Database Roles
  • Assigning User-Defined Database Roles
3. Authorizing Users to Access Resources
  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
4. Protecting Data with Encryption and Auditing
  • Options for auditing data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption
5. Recovery Models and Backup Strategies
  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies
6. Backing Up SQL Server Databases
  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options
7. Restoring SQL Server 2016 Databases
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
8. Automating SQL Server Management
  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Managemen
9. Configuring Security for SQL Server Agent
  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts
10. Monitoring SQL Server with Alerts and Notifications
  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Operators, Alerts, and Notifications
  • Alerts in Azure SQL Database
11. Introduction to Managing SQL Server by using PowerShell
  • Getting Started with Windows PowerShell
  • Configure SQL Server using PowerShell
  • Administer and Maintain SQL Server with PowerShell
  • Managing Azure SQL Databases using PowerShell
12. Tracing Access to SQL Server with Extended events
  • Extended Events Core Concepts
  • Working with Extended Events
13. Monitoring SQL Server
  • Monitoring activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility
14. Troubleshooting SQL Server
  • A Trouble Shooting Methodology for SQL Server
  • Resolving Service Related Issues
  • Resolving Connectivity and Log-in issues
15. Importing and Exporting Data
  • Transferring Data to and from SQL Server
  • Importing and Exporting Table Data
  • Using bcp and BULK INSERT to Import Data
  • Deploying and Upgrading Data-Tier Application
SERTIFIKACIJA
  • Polaznici dobijaju sertifikat o pohađanju kursa Administering a SQL Database Infrastructure ukoliko su bili prisutni na minimalno 70% predavanja.

690,00 KM

    Preferirani način praćenja kursa


    *Ukoliko nemate promo kod ostavite prazno polje.

    Cijena je bez PDV-a.

    Cilj kursa je da naučiš

    R

    Autentifikaciju i autorizaciju korisnika

    R

    Dodjeljivanje uloga serveru i bazama podataka

    R

    Zaštitu podataka sa enkripcijom

    R

    Kreiranje strategije za backup podataka

    R

    Automatizacija kod upravljanja bazama podataka

    R

    Upravljanje SQL serverom pomoću PowerShell-a

    R

    Nadgledanje SQL server infrastrukture i rješavanje problema

    Šta dobijam?

    Pristup obuci u trajanju od 40 časova

    Digitalnu literaturu i pristup virtuelnom lab okruženju

    Sertifikat o pohađanju kursa

    Pristup snimljenim predavanjima 45 dana od datuma završetka kursa 

    Detaljne informacije

    Početak:
    -
    Kraj:
    -
    pon
    uto
    sri
    čet
    pet
    09:00-16:00
    40 časova
    LANACO Tehnološki centar
    Veljka Mlađenovića bb
    Banja Luka
    (krug Poslovne zone Incel)
    Mogućnost praćenja online

    Možda te zanima

    Ništa nije pronađeno
    Share This