Exclusive Offer On Firebrand City Centre Courses
Only 8 days
Classroom
18/11/2024 (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