Ever wonder what the folks in IT are doing when you ask them to pull data for you from Dynamics GP? Did you ever wish you could do it yourself? Well join us for this fun hands-on class and soon you’ll be speaking and using SQL like a pro!
We’ll start from the very beginning and teach you the elements of a SQL query with a focus on the Dynamics GP data structure. SQL allows users to ask a question of the database, and have it answered in a very specific way. Although it may look like gibberish to you today, SQL is one of the most logical languages there is and we intend to make it easy for you to read and write it, but beyond that, 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:
•Understand how to employ SQL to get data out of Dynamics GP
•What is SQL and how can it be used in relation to Dynamics GP
•The components of an SQL Select query
•Different ways to connect data sources (JOINS and UNIONS)
•How to find data within Dynamics GP
•SQL Functions that can make queries better
•What to do with your query after it is written
•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.
The class will start out assuming attendees know nothing about SQL or programming and will quickly progress them to a point where they can effectively ask a complex question of their Dynamics GP database, as opposed to waiting for someone else to ask it for them.
After the basics, 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.
Audience: Anyone who wants to understand SQL
Level: Beginner
Prerequisites: An open mind and a positive attitude.
Preparation:
•Students should bring an internet capable Windows 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.