Spørgsmål? Ring på: 7027 2784

Man.-tors. kl. 8.00-16.00 / Fre. kl. 8.00-15.30

Svanevej 22, 2400 København NV

Category Icon
E-learning kurser

SQL Database Administration

Learn to manage SQL Server environments with confidence — from core setup to advanced administration. This course covers everything from queries and permissions to backups, recovery, and performance optimization.

personer der anbefaler

93% would recommend Itucation

+1.000 participants each year

SQL-Database-Administration

Apply here (non-binding)

Get a 6-week course approved through your job center. It’s free for you and a great opportunity to return to work.

Our team is here to guide you: 7027 2784

Duration

6 weeks

Location

Online

Next start date

Every monday

Master SQL Server Administration - On-Premise and in the Cloud

Learn to install, configure, and manage SQL Server — covering tuning, backups, security, and availability. Work with on-premise servers and Azure using practical tools.

🔹 SQL Foundations – Syntax, queries, tables, and transactions.

🔹 Database Administration – Manage access, automate with PowerShell, run backups.

🔹 Cloud Deployment – Set up secure Azure databases, boost performance.

🔹 Security & Recovery – Handle permissions, encryption, and recovery.

🔹 Performance & Monitoring – Maintain and optimize uptime.

📚 Covers curriculum from retired Microsoft certifications:
70-764 (Administering SQL Databases)
70-765 (Provisioning SQL Databases)
Although no longer offered by Microsoft, the course delivers valuable, job-ready skills. 💡

Information & Price

Start date:

Hver mandag

Location:

Online

Study schedule:

5 days a week

Language:

Engelsk

Duration:

6 weeks

Price for applicants:

Free for unemployed*

*Free, if you fulfil the criteria for 6-week job-oriented training programs via the Jobcenter

Price for Jobcenter:

Kr. 19.600 (ex. moms)

Feedback from our students

Course content

  • SQL Basics
    • Understand SQL 2016 and database concepts
    • Write and manage queries and tables
    • Group, aggregate, and use arithmetic in SQL
    • Explore Transact-SQL and subqueries
  • Security & Transactions
    • Manage SQL security and permissions
    • Work with transaction logs
      Use subqueries and user authorizations
    • Implement encryption and troubleshoot
  • Multi-Table Design
    • Design multi-table database architectures
    • Understand database relationships and structure
    • Manage complex queries across tables
    • Apply grouping and aggregation in depth
  • SQL Server Administration (70-764)
    • Configure data access and permissions
    • Backup and restore databases
    • Monitor queries and database activity
    • Ensure high availability and recovery
  • SQL Infrastructure Tools
    • Use PowerShell for SQL Server management
    • Set up disaster recovery strategies
    • Troubleshoot performance and availability
    • Manage encryption and secure access
  • SQL on Azure (70-765)
    • Install and upgrade SQL Server 2016
    • Run SQL virtual machines on Azure
    • Optimize performance and storage
    • Deploy secure Azure SQL applications

Who is the course for?

Dette kursus er henvendt til ledige, som ønsker at opkvalificere sig, og derved komme tilbage på arbejdsmarkedet.

Kurset er særligt relevant hvis du:

  • har erfaring med brug af PC og Windows – og også gerne relationelle databaser og database-design
  • har en grundlæggende forståelse for servere, databaser og Transact-SQL
  • ønsker at opnå IT-specialist viden samt ambitioner om at arbejde med MS SQL 2016 database
  • mangler kompetencer indenfor SQL Database Administration, for at lande drømmejobbet

 

Kurset er gratis for dig som ledig, såfremt du opfylder kravene for 6 ugers jobrettet uddannelse via dit jobcenter.

hvem-er-dette-kursus-for

Access to career coaching

During your 6-week employment-oriented course. you’ll have access to our career coach. They can assist you with your future opportunities, job applications, CV, and interview skills.
At the same time, Itucation has a business consultant dedicated to connecting participants with internships and available jobs.

How to apply

Get started in 4 easy steps

We assist you throughout the entire process and make sure you get the information you need.

1
Find your course

Find the course that suits you best – or ask our advisors for guidance.

2
Registration

You make a non-binding registration. We’ll then call you to ensure the course fits your future plans.

3
Apply through the jobcenter

You’ll receive the necessary documents from us, making the process simple.

4
Course start

After approval, you can begin the course and build valuable new competencies.

Meet your education manager

As co-founder of Itucation, Søren brings over 15 years of experience in training and upskilling job seekers. He has worked as a teacher, consultant, and education manager, and has been active in the IT field since the mid-1990s — giving him extensive industry insight.

He also has a solid understanding of the target audience and maintains a strong network with job centers and unemployment funds. That’s why our courses are always designed to meet real market demands, equipping you with practical and valuable skills.

We’re ready to advise you: 7027 2784

Do you need help?

Have a chat with Kristina, our experienced course advisor. She can help you find the course that best matches your goals, explain the application process, and guide you on how to get the course approved through your job center.

Approved on "regional positivliste"

This course is approved on the “regionale positivliste for 6 ugers kurser til ledige”, and can be applied for through your job center. If you have any questions about the application process, please contact us at 7027 2784 or kurser@itucation.dk.

For list titles and reference numbers, simply click the button below to access our overview document.

Partner

Nova Learning skaber adgang til de bedste ressourcer inden for læring: e-learning, mentorordning, eksamenssimulering og virtuelle labs. Alle e-learning kurser er tilpasset og målrettet mod certificeringer og/eller rettet mod jobs inden for de nyeste teknologier. Herunder Artificial Intelligence, Machine Learning & Data Science.

Hvorfor tage et e-learningskursus i SQL 2016 Database Administration?

Kom tilbage i arbejde efter dit SQL 2016 Database Administration e-learningskursus

Som databasespecialist med speciale i administation af Microsoft SQL 2016 Server får du stor viden om grundlæggende og videregående database-infrastruktur inkl. database-adgang og -tilladelser, backup af databasen, forespørgsler, disaster recovery, administration af databasen via PowerShell, kryptering af data og meget mere.

Du lærer SQL fra bunden, hvor vi kigger på tabeller, forespørgsler, sikkerhed, database-design og -arkitektur mv. Ovenpå dette fundament fortsætter vi til installation og opgradering af SQL Server 2016, SQL Server virtual machines på Azure, performance, Azure SQL Database-kryptering, udrulning af applikationer på Azure SQL-databaser mv.

Du kommer omkring pensummet fra de to certificeringer Administering a SQL Database Infrastructure samt Provisioning SQL Databases.

På baggrund af denne viden, kan du arbejde specialiseret som database-administrator af Microsoft SQL Server 2016 og håndtere store mængder vel-strukturerede data med høj sikkerhed, oppetid og performance i databasen.

Vores e-learningskursus SQL 2016 Database Administrator har fra start til slut fokus på, at du:

✓ Skal kunne få arbejde som database-administrator eller lignende stilling efter endt e-learningskursus.
✓ Skal have en solid viden om SQL-sproget og Microsoft SQL Server 2016.
✓ Kan strukturere forespørgsler, optimere performance og sikkerhed samt mange andre specialist-opgaver i databasen.

Secure your spot on the course - without commitment

Signing up is 100% obligation-free — you can register right away, even before your job center has granted approval.

After your signup, we’ll give you a quick call to guide you through the practical steps and share tips on how to secure approval for the course.

SQL-Database-Administration

Non-binding registration

Get a 6-week course approved through your job center. It’s free for you and a great opportunity to return to work.

Duration

6 weeks

Location

Online

Next start date

Every monday

Info til jobcentre & a-kasser

Godkendt på den regionale positivliste

Kurset er godkendt på den regionale positivliste for 6 ugers kurser til ledige, som kan søges via dit jobcenter. Kontakt os på 7027 2784 eller på kurser@itucation.dk hvis du har spørgsmål til hvordan du søger dette kursus hos dit jobcenter.

Kontaktperson hos Itucation

Kristina Rosager
kurser@itucation.dk (sikker mail)

ITUCATION ApS
CVR-nr: 33248016
P-nr: 1016378247