This article is going to be designed for people who have no interest in being a DBA and simply need a basic understanding of SQL and running basic queries and understand scripts.
These two sites, SoloLearn and Code Academy, provide step by step tutorials to learning the basics of the SQL Language.
These two sites provide step by step tutorials to learning the basics of the SQL Language.
I have created a quick reference for people to print to refer to. Here is the link: sql-quick-reference
With Microsoft Dynamic GP, the most you will utilize are select, delete, and update statements. These are the basics that should be understood to troubleshoot items. All examples within my articles pertaining to SQL will be using the tables for Great Plains 2015 and Fabrikam in Microsoft SQL Server 2014.
Agenda:
Understanding SQL Tables
Understanding SQL Querying Window
Understanding Select Statements
Understanding Delete Statements
Understanding Update Statements (Coming Soon)