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.
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
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
- 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: email@example.com and we will find a way to meet your needs.
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 firstname.lastname@example.org