Product Specialist eOne Integrated Business Solutions
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 get data out of Dynamics GP
Instructor: Rod O'Connor, Briware Solutions Inc. Audience: Anyone who wants to understand SQL
Level: Beginner Prerequisites: An open mind and a positive attitude. Preparation:
• Students should bring a laptop computer to the course. • The detailed instructions for connecting and attending the class will be sent a week prior to class. • There will be short installation that will need to be completed, in order for you to have access to the training environment needed for labs and exercises. • Your instructor will use a hands-on training environment.