Duration:
Only 8 days
Study Mode:
Classroom
Next Date:
06/01/2025 (Monday)

Overview

Get the skills to manage a Microsoft SQL Server database and customise Microsoft Dynamics 365 on this 8 day accelerated MCSA: Microsoft Dynamics 365 for operations course.

Your expert Microsoft Certified Trainer (MCT) will immerse you in the course using Firebrand's unique Lecture | Lab | Review technique. You'll get hands-on experience covering topics including:

  • Installing, maintaining and configuring a Microsoft SQL Server database
  • Creating backups and securing your database
  • Microsoft Dynamics 365 for Retail and Finance and Operations
  • Read and write basic X++

Your accelerated course will prepare you for exams 70-764 and MB6-894. You will sit these on-site during the course, covered by your Certification Guarantee.

Earning your MCSA: Microsoft Dynamics 365 certification demonstrates you have the skills for a position as a Dynamics 365 developer, solution architect, or implementer. It also acts as your first step towards becoming MCSE: Business Applications certified.

Curriculum

Course 20764C: Administering a SQL Database Infrastructure

Module 1: SQL Server Security

  • Lab: Authenticating Users

Module 2: Assigning Server and Database Roles

  • Lab: Assigning server and database roles

Module 3: Authorising Users to Access Resources

  • Lab: Authorising users to access resources

Module 4: Protecting Data with Encryption and Auditing

  • Lab: Using Auditing and Encryption

Module 5: Recovery Models and Backup Strategies

  • Lab: Understanding SQL Server recovery models

Module 6: Backing Up SQL Server Databases

  • Lab: Backing Up Databases

Module 7: Restoring SQL Server 2016 Databases

  • Lab: Restoring SQL Server Databases

Module 8: Automating SQL Server Management

  • Lab: Automating SQL Server Management

Module 9: Configuring Security for SQL Server Agent

  • Lab: Configuring Security for SQL Server Agent

Module 10: Monitoring SQL Server with Alerts and Notifications

  • Lab: Monitoring SQL Server with Alerts and Notifications

Module 11: Introduction to Managing SQL Server by using PowerShell

  • Lab: Using PowerShell to Manage SQL Server

Module 12: Tracing Access to SQL Server with Extended events

  • Lab: Extended Events

Module 13: Monitoring SQL Server

  • Lab: Monitoring SQL Server

Module 14: Troubleshooting SQL Server

  • Lab: Troubleshooting Common Issues

Module 15: Importing and Exporting Data

  • Lab: Importing and Exporting Data

MB6-894: Development, Extensions and Deployment for Microsoft Dynamics 365 for Finance and Operations

Section 1: Understand the architecture and development environment

  • Describe the Microsoft Dynamics 365 for Finance and Operations architecture
  • Describe the Microsoft Dynamics 365 for Retail architecture
  • Manage development with Microsoft Visual Studio and Lifecycle Services (LCS)

Section 2: Develop new elements by using Application Explorer

  • Create and manage labels and resources
  • Create and manage data types
  • Create and manage tables

Section 3: Read and Write Basic X++

  • Describe the X++ environment
  • Work with X++ control statements
  • Work with classes
  • Manipulate data with X++
  • Manage exceptions in X++

Section 4: Manage the User Interface and Security for Developers

  • Manage the user interface
  • Manage the user navigation
  • Manage security in the development environment

Section 5: Develop and extend retail components

  • Modify retail components
  • Deploy retail modifications
  • Monitor retail components

Exam Track

At the end of this accelerated course, you'll sit the following exams at the strong>Firebrand Training centre, covered by your Certification Guarantee:

Exam 70-764: Administering a SQL Database Infrastructure

  • Technology: SQL Server
  • Languages: English

Exam MB6-894: Development, Extensions and Deployment for Microsoft Dynamics 365 for Finance and Operations

  • Technology: Microsoft Dynamics 365
  • Languages: English

What's Included

  • MOC 20764 - Administering a SQL Database Infrastructure
  • Firebrand Custom Courseware

Prerequisites

Before attending the course, it is recommended you meet the following prerequisites:

  • Foundation knowledge of the Microsoft Windows operating system and its core functions
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Experience of database design
  • Basic knowledge of Microsoft Dynamics AX, Visual Studio 2015, and object-oriented programming.

Benefits

Seven reasons why you should sit your course with Firebrand Training

  • Two options of training. Choose between residential classroom-based, or online courses
  • You'll be certified fast. With us, you’ll be trained in record time
  • Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
  • Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  • You’ll learn more. A day with a traditional training provider generally runs from 9 am – 5 pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day of quality learning time, with your instructor
  • You’ll learn faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  • You’ll be studying with the best. We’ve been named in the Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 135,000 professionals

*For residential training only. Doesn't apply for online courses
**Some exceptions apply. Please refer to the Exam Track or speak with our experts

Think you are ready for the course? Take a FREE practice test to assess your knowledge!  Free Practice Test

Course Dates


Start
Finish
Status
Study Mode
Prices
06/01/2025 (Mon)
13/01/2025 (Mon)
Open
Classroom
08/04/2025 (Tue)
15/04/2025 (Tue)
Open
Classroom
07/07/2025 (Mon)
14/07/2025 (Mon)
Open
Classroom
07/10/2025 (Tue)
14/10/2025 (Tue)
Open
Classroom