OD20764C: Administering a SQL Database Infrastructure (90 Day)

This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.

Created by
Got Questions? Enquire Now
  • Full access to the official Digital Microsoft Official Courseware (dMOC)
  • Microsoft’s HD-quality streaming videos
  • Access to Hands-On, Live Lab
  • Microsoft Training Support 24*7
  • Exercises, Readings and Knowledge checks

This 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.

  • 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
  • The primary audience for this course is individuals who administer and maintain SQL Server databases.
  • These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
  • The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Microsoft Official Courses On-Demand (MOC On-Demand) are authorized Microsoft official courses exclusively developed by Microsoft Certified Trainers. MOC on-demand delivers a comprehensive training experience comprising a merge of high-quality audiovisuals, academic readings, Microsoft labs online and knowledge check/assessments.

MOC on-demand is a self-paced training structured for IT Professionals and Developers which makes them proficient in the Microsoft technology and develop technical skills. It focusses on providing you a live, real-time environment for hands-on training while including all the interactive features with credible content that other On-demand offerings lack.

MOC On-Demand comprises a range of courses which are structured in a modular format consisting different modules that are further segregated into lessons, each of which contains questions to testify your knowledge.

Self-paced learning

An online course structure which gives you utmost flexibility to learn.

Official Microsoft content

HD-quality streaming videos with interactive content delivered by expert instructors -“straight from the source”.

Digital Microsoft Official Curriculum

Access to the official curriculum anywhere & anytime.

Hands-on live labs

Microsoft Labs Online to work on your technical skills with integrated lab steps.

Knowledge assessments

Knowledge check and instant feedback to mark your stand in the training process.

24x7 availability

Microsoft-hosted mentors available to you round the clock via chat, email, & phone.

Authored by Microsoft certified experts

In-depth technical content structured by individuals who wrote the software and delivered by expert instructors.

ms-excel-basic-to-advanced-level

MS Excel Basic to Advanced Level

By : Ramzan Rajani

Lecture 15

front-end-web-design-using-wysiwyg-web-builder-like-a-pro

Front End Web Design Using WYSIWYG ...

By : Ishmeal Lamptey

Lecture 39

Free

implementing-configuring-cisco-routers-part-1

Implementing & Configuring Cisco Ro...

By : Dariusz Lipski

Lecture 10

learn-nxtgen-hacking-with-technology

Learn NxtGen Hacking with Technolog...

By : Gopikrishna C

Lecture 80

digital-marketing-and-basics-of-seo

Digital Marketing and Basics of SEO

By : Abhirup Moitra

Lecture 10

google-tensorflow-hands-on-with-python-latest

Google TensorFlow Hands on with Pyt...

By : UNP United Network of Professionals

Lecture 51

Buy

$29

Enjoy Limitless Learning. Get Access to Unlimited Courses with Premium Subscrption Subscribe Now

Sign up and start learning
By signing up. you agree to our Terms of Use and Privacy Policy
Forget Password