OD 20462 Administering Microsoft® SQL Server® 2014 Databases (90 Day)

Popis kurzu

Témata kurzu seznámí účastníky s technikami, jejichž znalost je nezbytná pro efektivní zvládnutí správy a údržby databázového systému Microsoft SQL Server 2014. Kurz je vhodný jak pro začátečníky, tak pro zkušenější správce, kteří potřebují stávající informace osvěžit a lépe procvičit. Kurz není vhodný pro seznámení s novinkami verze MS SQL Server 2014 a je součástí oficiální přípravy na úspěšné složení certifikační zkoušky.

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Obsah kurzu

After completing this course, students will be able to:

• Describe core database administration tasks and tools.


• Install and configure SQL Server 2014.


• Configure SQL Server databases and storage.


• Plan and implement a backup strategy.


• Restore databases from backups.


• Import and export data. Monitor SQL Server.


• Trace SQL Server activity.


• Manage SQL Server security.


• Audit data access and encrypt data.


• Perform ongoing database maintenance.


• Automate SQL Server maintenance with SQL Server Agent Jobs.


• Configure Database Mail, alerts and notifications.

MOC On-Demand is an integrated combination of video, text, practical tasks and knowledge tests designed to help IT experts and developers to expand their knowledge about Microsoft technologies. The courses are a great alternative for anyone wanting to learn independently and at their own pace. They can also be used in the form of a Blended Class together with managed training courses, or as the basis for training solutions with mentoring and other learning programmes.

All Labs within a course can be accessed via the Microsoft Labs Online (MLO) platform. Participants enrolled on a course can start the Labs directly from within a course; they do not need to be set up separately.

Licence codes purchased for the new Skillpipe MOC On-Demand courses can now all be found in the "Digital Library" section. The licence codes for these courses are now provided via the Management Dashboard, just like for the dMOC courses.

System requirements for Skillpipe MOC On-Demand

System requirements for Skillpipe MOC On-Demand

Browser:

• current version of Internet Explorer, Microsoft Edge, Google Chrome™ or Firefox®

Internet access:

• broadband Internet connection (recommended: network bandwidth of over 4Mbps)

Screen resolution:

• 1280 x 1024 or higher

Studijní materiály