Hi
I new at SQL i want to start learn because i see that i need that knowledge in solarwinds products. Can you guys recommend witch course to go ?
I took a Querying Microsoft SQL Server class. That opened the door for me to query the database and get those special reports that are always requested.
I'd also look into SWQL, it is pretty similar to SQL but with some Solarwinds touch to it.
I personally think it is best to go with SWQL as more and more modification and tweaking of the database will happen. Sometimes Tables and views change for performance reasons and your old scripts stop working after an upgrade.
I am also trying to learn and have found the Khan Academy course to be fairly easy to follow. It may not be the most in depth (not sure since I haven't finished the course), but it has helped me understand the logic behind what SQL does.
Where can you find SWQL training? Do you know any good place to look for?
As far as I have found there is the the wiki below and understanding how SQL works since is SQL with some added features
Home · solarwinds/OrionSDK Wiki · GitHub
SWQL is so close to SQL as to make it not worthwhile to teach separately. If you know basic SQL then you can make basic SWQL, and any advanced SQL doesnt work in SWQL. I taught myself everything I needed to know about SQL and SWQL by using this SQL Tutorial, the above mentioned github, and a lot of googling.
Step 1 is to download the orion SDK from the github and start looking at it with the queries you see other thwackers posting on here. It doesn't take long to be able to break them apart and see what they are doing in most cases.
For someone starting out to build database / SQL skills I find the following of great use !!!
(1) Rashid Khan’s course -- https://goo.gl/h1cmb4-- “SQL Server 101 : Microsoft SQL Server for Absolute Beginners” — deeply discounted video course, for the price of a lunch, and in less than 4 Hours – extremely concise and clear video lectures
(2) Khan Academy -- https://www.khanacademy.org/ – free online courses covering a wide range of disciplines, including the Intro to SQL course
Thanks for the tips !!