Courses and Conferences

DTI Main Reception

Do you need help?

  • Gregersensvej 8
  • 2630 Taastrup
Google MapsApple MapsRejseplanen
  • Forskerparken Fyn, Forskerparken 10F
  • 5230 Odense M
Google MapsApple MapsRejseplanen
  • Teknologiparken Kongsvang Allé 29
  • 8000 Aarhus C
Google MapsApple MapsRejseplanen
  • NordsøcentretPostboks 104
  • 9850Hirtshals
Google MapsApple MapsRejseplanen
  • Gammel Ålbovej 1
  • 6092Sønder Stenderup
Google MapsApple MapsRejseplanen
87725 - MCSA SQL Server
365 days online course

Online Course: MCSA: SQL Server 2012 Collection

If you are working with databases and used to working with SQL Server 2012, you now have the opportunity to gain the required knowledge for being certified MSCA in SQL Server 2012 The course is in English and you can take it online when it suits you. You will have access to the online course for 365 days.


SQL Server 2012

SQL Server 2012 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2012 database to meet business requirements, administrators and developers must fully understand how to design, create, and configure these database objects. SQL Server 2012 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, the SQL Server Database Engine, Integration Services, Analyzes Services, and Reporting Services. This collection will qualify you to take the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.



Target audience

IT professionals who have jobs in database administration or database development. Candidates for this collection should have two or more years of experience using SQL Server 2012 or a previous version of SQL Server, and they are seeking to prove their proficiency in writing queries. Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work as database developers.


  • Choose the appropriate data type to use
  • Create, modify and implement tables and index
  • Describe, retrieve, convert and modify data within SQL Server 2012
  • Create and modify user-defined functions and DML triggers
  • Distinguish between SQL Server 2012 editions
  • Install and upgrade
  • TestPreps for the certification
  • The Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification

Collection content

SQL Server 2012 Collection provides access to several courses designed by experienced subject matter experts and course designers. For informal learning and performance support, the collection includes materials and books from leading publishers and access to videos. For those employees who are working on certifications, this collection provides a wide array of certification test preparation support including test preps and access to a highly credentialed team of mentors.

Here are some of the many topics covered in this collection:

  • Creating Database Objects
  • Querying Basics and Modifying Data
  • Creating Functions and Triggers
  • Managing XML Data
  • Installation and Upgrade
  • Instance Configuration and Database Creation
  • Managing Database Data
  • Managing Indexes, Full-Text Search and Partitions
  • Configuring High Availability
  • Design and Deployment
  • Create Basic packages
  • Enhancing packages
  • Installing SSIS
  • Troubleshooting
  • DQS and MDS Solutions


Kursuskollektionen består af 23 kurser, hvor hvert kursus gennemsnitsligt varer en time. Hele kursuskollektionen kan således gennemføres på ca. 23 timer.

Features / How does it work?

When you sign up for a of courses, you will get access to a relevant selection of courses for the next 365 days. Each course is divided into several modules. From the summary menu you can choose the order in which you wish to go through the modules. The contents are explained through sound, pictures and text – and some modules contain short videos with scenarios and case studies. Each course gives you the opportunity to test your comprehension of the subject with tests before, during and after completing the course. To take the online courses you will need a computer or tablet with sound device and internet access. You choose when you want to take a course, and you can pause it during a session – bookmarks will keep track of how far you have progressed.

Read more about our online courses and find the answers to your questions (FAQ)

Were you looking for another online course?

We offer more than 7,000 different online courses on a large variety of topics. Contact us by phone (+45 72203000) or e-mail: and we will find a way to meet your needs.

You can also browse through our selected online courses.

Buy online courses for a group of people

If your department, your entire company or just a couple of people require access to online courses, please contact us for an offer by phone +45 72203000 or

Do you have any questions please contact