OK, so you’ve got the basics. You know what the folks in IT are looking at when you ask for data pulls from Dynamics GP.
In part one of this series, we taught you that SQL allows you to ask a question of the database, and have it answered in a very specific way. But there’s so much more! SQL actually allows you to ask a series of leading questions, coupled with specific commands, grouped together to get to the answer you really want! It’s like truth serum for your data!
Through interactive lectures and hands on examples, attendees of this class will learn:
- what are UPDATE, INSERT, and DELETE commands?
- How do we build a query, stored procedure, or function? For that matter, what are queries, stored procedures, and functions?
- More SQL functions, and how they help us navigate our Dynamics GP data.
Building on the knowledge gained in the first session, attendees will quickly advance to a point where simple reporting, data manipulation, or support needs needn’t wait on an IT resource to be available.
Learning Objectives: Understand how to employ SQL to manage Dynamics GP data.
Instructor: Rod O'Connor, Briware Solutions Inc.
Audience: Anyone who wants to understand SQL
Prerequisites: An open mind and a positive attitude.