D365FO from Zero! SQL Practice Homework1 review and questions! скачать в хорошем качестве

D365FO from Zero! SQL Practice Homework1 review and questions!

Welcome back to the D365FO Technical training course from ZERO! In this 1 on 1 training lesson, we review the SQL Homework for Microsoft Dynamics 365 Finance and Operations that I assigned to Derek! The task was to write queries for purchase orders and purchase order lines just like we did for Sales Orders in the previous lesson! Homework review sessions are an opportunity for the student to ask any questions they want! In this lesson, we jump between the D365FO user interface which you access via web browser, Visual studio 2022 with the Dynamics 365 Finance and Operations extension, and SQL Management Studio. You will learn how to find the table the raw data is stored in from a Form and write single table SQL select statements that filter the data with the where clause. In this series, I will be teaching sql, databases, x++(D365FO programming language), object oriented programming, and also business processes. No PRIOR knowledge is necessary!! Great for freshers! All lessons and homework will be recorded and available for FREE on the James Humphrey (TRJHTECH) youtube channel! There will also be blog posts with every lesson to recap the key takeaways! Although it is a technical series, we will also be discussing a lot of functional aspects. If you are functional, I highly recommend understanding some of "How the sausage is made" because it will help you better interact with your technical team! You can find all the episodes for this series here!    • D365FO Learn Dynamics 365 Finance and Oper...   For business inquiries reach out to us at: bizinq@trjhtech.com Timestamps: 00:00 Replying questions about the course and career. 05:25 Navigating d365FO UI and explaining differences between Header and lines 08:54 Reviewing the header query: Identifying common SQL mistakes 19:40 How to label aliases correctly and naming conventions. 27:27 How to identify fields in the UI and search in Visual Studio 35:05 Adding fields to the query and fixing errors You can see the blogposts for this video here 👇 https://trjhtech.com/d365-fo-technica... Microsoft dynamics 365 for finance and operations previously known as Dynamics Ax/Axapta consists of several products: Dynamics 365 Finance, D365 Human Resources, Dynamics 365 Supply Chain Management, and D365 Commerce Check out the D365FO technical tutorials / d365fo x++ development playlist for more D365 f&o technical training!    • D365FO technical tutorials | Microsoft dyn...   Other D365 content creators I recommend checking out: Peter Ramer (dynamics365musings), Rumman Ansari (rummanansari), Mohammed Yasar (techtalk365), Microsoft Dynamics 365 Community About James Humphrey (trjhtech): 19+ years working in the Microsoft Dynamics ecosystem: including 3.5 years consulting independently, 11 years at top-tier partners, and 5 years client side.