GP and SQL Database courses

  • GP and SQL Database courses

    Posted by DSC Communities on January 10, 2017 at 5:07 pm
    • Katie Pieczynski


      January 10, 2017 at 5:07 PM


      I know this questions has been asked before, but I was wondering if you could give me your suggestion on the best route to go.

      I have been using GP for about 8 years and have a pretty good understanding of it.

      Before GP I used Crystal Reports and MS Query.  I have a decent knowledge of the SQL language, but what I dont have is the database component. 

      If I were wanting to expand my education to more on the IT side to learn about our database and how it interacts with GP and also to perform tasks like clearing tables when an invoice or user is stuck, or writing queries instead of building smartlists, what would be the best route?

      Obviously our local College has a certificate program in Database Administration, but would that be over kill or not even relevant?

      I know GPUG has academy classes and I think those would be beneficial, but would it be enough?

      Should I do both?  Any thoughts or suggestions are welcomed. #databaseadmin

      Thank you,

      Katie Pieczynski
      Accounts Receivable Manager
      Champaign IL

    • Zubin Gidwani


      January 10, 2017 at 7:34 PM


      If you can wait there is a full day training course on Feb24 which would be a great intro class for you. 

      Academy – Intro to SQL for Accountants & non-DBA’s Feb 2017

      Cobaltsaas remove preview
      Academy – Intro to SQL for Accountants & non-DBA’s Feb 2017
      View this on Cobaltsaas >


      Zubin Gidwani
      Dynamic Budgets


    • Kim Peterson


      January 11, 2017 at 8:01 AM

      Don’t forget the great benefit as a member of the webinar Recordings.  You’ll find ones under Database Administrator and IT that would be great for you!  here you’ll find hundreds of hours of free training!

      Kim Peterson
      InterDyn BMI

    • Beat Bucher


      January 11, 2017 at 9:24 AM

      Hi Katie,

      Online training courses are always a good start (like the one offered by GPUG, and many of the webinars can even be downloaded from the library).

      An excellent learning place is also Victoria Yudin’s blog, where you’ll be able to find tons of excellent SQL scripts to solve most of your daily issues in GP. Check under the Resources menu..

      Good luck.

      Beat Bucher
      Business Analyst, Dynamics GP MVP
      Ultra-Electronics Forensic Technology Inc.
      Montreal QC/Canada
      Montreal QC GPUG Chapter Leader
      GP2013R2 / MR2012 CU14

    DSC Communities replied 6 years, 8 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!