/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Learning SQL for KACE

09/16/2015 2756 views
Hello all,

As I continue to get more and more requests from management to do modifications to our KACE environment, the more I need training in SQL. Especially that relates to KACE. Can anyone recommend a training program to learn SQL so I can do these custom modifications without having to pay Dell KACE professional services? Any help or tips you can provide would be much appreciated. I'm located in west Georgia, USA.

Thank you.
0 Comments   [ + ] Show comments

Comments



Community Chosen Answer

1
Download TOAD as a toolbox from Dell, this tool really helped us to get a grip on SQL when building queries etc
Answered 09/18/2015 by: Hobbsy
Red Belt

  • I will second TOAD. Great product.

All Answers

0
Here's a great place to start:

http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example

If you are attending the Software User Forum there will some SQL classes there.
Answered 09/16/2015 by: rockhead44
Red Belt

0
If you want to learn general MySQL skills then any class should be helpful. I'm a self learner so I use the MySQL documentation a lot. If you haven't already setup MySQL Workbench then I highly recommend doing that and start poking around in the tables. 
Answered 09/17/2015 by: chucksteel
Red Belt

0

Head First SQL: Your Brain on SQL -- A Learner's Guide


I purchased the above book and it helped me with some of the items I was struggling with. Using this book along with being able to test using my sql workbench really helped a lot.
If you are looking for a deep dive into SQL then there are a lot of online classes that you could take also. 

Answered 09/17/2015 by: scarpent
5th Degree Black Belt

This content is currently hidden from public view.
Reason: Removed by member request For more information, visit our FAQ's.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ