80696AE: SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 Training

3896 Learners

The 80696AE: SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 training offers an in-depth insight on tools that helps the candidates in creating and maintaining SQL Server to maintain the performance of Microsoft Dynamics AX. Moreover, the SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 Course Training helps the candidates in enhancing their skill on SQL Optimization that helps them in achieving their career goals for sure. The trainers help the candidates in gaining hands-on experience on the subject matter so that they would be able to deal with the real time issues while dealing with the projects.

After completing the SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 Training, the candidates would be able to:

Develop an understanding of the tools available to monitor and solve performance problems
Understand how to create or design the data structures in Microsoft Dynamics AX to improve their performance
Tune queries
Review X++ best practices that affect performance
Tune indexes
Understand how to create Maintenance plans in SQL Server to maintain the performance of Microsoft Dynamics AX
Understand how to configure the parameters to improve the performance of Microsoft Dynamics AX
How to create a plan for Microsoft Dynamics AX infrastructure?

Target audience

Application Consultants
Pre-Sales Professionals
Developers

Prerequisites

Following are the prerequisites for SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 Training:

80313: Development IV in Microsoft Dynamics AX 2012
80672: Installation and Configuration for Microsoft Dynamics AX 2012 R3 CU8

After completing the SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 Training, the candidates would be able to:

Develop an understanding of the tools available to monitor and solve performance problems
Understand how to create or design the data structures in Microsoft Dynamics AX to improve their performance
Tune queries
Review X++ best practices that affect performance
Tune indexes
Understand how to create Maintenance plans in SQL Server to maintain the performance of Microsoft Dynamics AX
Understand how to configure the parameters to improve the performance of Microsoft Dynamics AX
How to create a plan for Microsoft Dynamics AX infrastructure?

Target audience

Application Consultants
Pre-Sales Professionals
Developers

Prerequisites

Following are the prerequisites for SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 Training:

80313: Development IV in Microsoft Dynamics AX 2012
80672: Installation and Configuration for Microsoft Dynamics AX 2012 R3 CU8

80696AE: SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 Training Course Content

Infrastructure and capacity Planning
Configuration Best Practices
Database Design Considerations
X++SQL Code Best Practices
X++Coding for Performance Best Practices
Post-implementation: Monotoring and Performance

1. Infrastructure and capacity Planning

Microsoft Dynamics AX 2012 Architectural Review
Sizing Questions - Part I
Sizing Questions - Part II
Sizing Questions - Part III
Hardware Sizing Resources
Database Sizing Guidelines
Application Object Server Sizing Guidelines
Enterprise Portal Server Sizing Guidelines
Integration Server Sizing Guidelines
Terminal Server Sizing Guidelines
Day in the Life Benchmark
Enterprise Portal Benchmark
Hyper V Benchmark
High Volume Inventory Benchmark
Moving from Theory to Practice: Create a Network Plan
Moving from Theory to Practice: Considerations

2. Configuration Best Practices

SQL Configuration: Overview
SQL Configuration: Operating System Settings
SQL Configuration: SQL Server Service Account
SQL Configuration: Configuring SQL Server
SQL Configuration: Trace Flags
SQL Configuration: Temp Database
SQL Configuration: Configure the AX Database
Server Configuration
AX Settings
Batch Configuration
Design Effective SQL Server Maintenance Plans

3. Database Design Considerations

Create and Maintain Database Objects
Data Types
Table Caching
Table Caching Guidelines
Table Inheritance
Temporary Tables
Indexing
Clustered Index Usage
Non-Clustered Index Usage
Column Order
Included Columns
Concurrency Control
Data Compression

4. X++SQL Code Best Practices

Index Tuning Process: Overview
Index Tuning Process: Identify Query in SQL Server Management Studio
Index Tuning Process: Create and Analyze an Execution Plan
Index Tuning Process: Parameter Sniffing
Index Tuning Process: Add and Test Index Changes
Index Tuning
Query Tuning: Overview
Query Tuning: Database Bulk Updates
Query Tuning: Loops and Where Clause
Query Tuning: Aggregates, Minimize Data Returned, and Index Hints
Query Tuning

5. X++Coding for Performance Best Practices

Development Practices to Do and Not Do: Loops, Conditionals and Fieldlists
Development Practices to Do and Not Do: Aggregations and Transaction Scoping
Development Practices to Do and Not Do: UI Interaction
Development Best Practices
Code Placement
Batching and Batch Strategies: SysOperationFramework
Batching and Batch Strategies: Batch Bundling
Batching and Batch Strategies: Individual Task Model
Batching and Batch Strategies: Top Picking
Form Considerations
Response Time Expectations

6. Post-implementation: Monotoring and Performance

Performance Tuning Approach
Locking, Blocking, and Deadlocks
SQL Server Reporting Services (SSRS) Tuning
Enterprise Portal Performance Tuning
Performance Analyzer (DynamicsPerf)
AX Trace Parser
System Diagnostics on Lifecycle Services
Windows Performance Monitor (PerfMon)
Other Tools
Tools to be Cautious About
Common Intermediate Language (CIL)

Drop Us a Query

+91 95550 06479

Available 24x7 for your queries

80696AE: SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 Corporate Training & Certificati

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

+91 9555006479

Available 24x7