tark.ee
tark.ee

Administering a SQL Database Infrastructure - MOC#20764

This instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

BCS Koolitus
Description
Practical exercise, independent work.
Programme
  • Module 1: SQL Server Security
  • Module 2: Assigning Server and Database Roles
  • Module 3: Authorizing Users to Access Resources
  • Module 4: Protecting Data with Encryption and Auditing
  • Module 5: Recovery Models and Backup Strategies
  • Module 6: Backing Up SQL Server Databases
  • Module 7: Restoring SQL Server 2016 Databases
  • Module 8: Automating SQL Server Management
  • Module 9: Configuring Security for SQL Server Agent
  • Module 10: Monitoring SQL Server with Alerts and Notifications
  • Module 11: Introduction to Managing SQL Server by using PowerShell
  • Module 12: Tracing Access to SQL Server with Extended events
  • Module 13: Monitoring SQL Server
  • Module 14: Troubleshooting SQL Server
  • Module 15: Importing and Exporting Data
Skills you will gain
  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data
Additional information
Assesment methods: Execution of independent work. Assesment form: Independent practical tasks on relevant topics. Price includes
  • Coffee breaks and lunch in restaurant “Lusikas”
  • Free Microsoft certification exam within the period of 6 months after finishing the course
✨
Vajan seda oma tiimile
Aitame koostada päringu
›

This course last ran in June 2019. We do not know yet whether or when it will run again — that is why it is still here. Ask us if you are interested.

Sarnased koolitused, mis praegu toimuvad

Administreerimine

Administering a SQL Database Infrastructure (55316A)

55316A Administering a SQL Database Infrastructure on koolitus, kust saad kõik praktilised oskused ja teadmised SQL andmebaaside infrastruktuuri haldamisest.

16.11 · Lõõtsa 5

15.03 · Lõõtsa 5

Henn Sarv

Henn Sarv

Nordic Koolitus

Nordic Koolitus

1090€+kmVaata

Administreerimine

Administering Microsoft Endpoint Configuration Manager (55348AC )

This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager.

08.02 – 22.09 · Lõõtsa 5 · 40 akadeemilist tundi (5 päeva)

Meelis Nigols

Meelis Nigols

Nordic Koolitus

Nordic Koolitus

1090€+kmVaata

Administreerimine

Microsoft Azure Administrator (AZ-104T00-A)

This course teaches IT Professionals how to manage their Azure subscriptions, create and scale virtual machines, implement storage solutions, configure virtual networking, back up and share data, connect Azure and on-premises sites, manage network traffic, implement Azure Active Directory, secure identities, and monitor your solution.

14.12 – 17.12 · Aia 7 või videokonverentsi keskkonnas Teams · 32 ak. tundi

Andres Liitmaa

Andres Liitmaa

BCS Koolitus

BCS Koolitus

1390€+kmVaata

Administreerimine

Installation, Storage, and Compute with Windows Server (55341AC)

The aim of this Windows Server training is to provide the fundamental networking skills required to deploy and support Windows Server 2022 in most organizations.

04.01 – 10.10 · Lõõtsa 5 · 40 akadeemilist tundi (5 päeva)

Peep Võrno

Peep Võrno

Nordic Koolitus

Nordic Koolitus

1090€+kmVaata

Tell me when this course runs again

This course is not running at the moment. Leave your contact details and we will let you know when it, or a similar course, is back in the calendar.

Notify me withinmonths.
✨

Otsid midagi muud?

Aitame leida sarnase koolituse või koostada tiimile eraldi pakkumise — vestle meiega.

Ask when it runs ↓