SQL Exposure/Self Training

Well I have had a bit of an overwhelming SQL introduction in one of my recent deployments of a clients server. In the past we have never had to deal with it because the support staff for the product using it always maintained it. Well it went south with them and I had to figure it out as I went but it left me with the wild notion that I cannot depend on the support group to help. I need to learn SQL quite simply. I know its a vast amount of knowledge, best practices etc and there are a ton of paid options for training on this. What I need is a tool set or site or DIY learning method of learning the basics of SQL, how to administer it and maintain it from a introduction standpoint. Does anyone have any suggestions for learning this or a good path to follow in picking it up?

I have used sites like Codeacademy in the past etc but even they have went to paid versions now. Looking for some get started info.

Thanks in advance!
LVL 5
James BunchSystems EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulEE Topic AdvisorCommented:
nb: "SQL" is not an abbreviation for "Microsoft SQL Server". "Structured Query Language" is a standard and not owned by Microsoft.
1
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Check out the article I wrote on this ... SQL Server Training
1
James BunchSystems EngineerAuthor Commented:
Ok great I will look at it in the AM. Thanks for the link. I will keep open for a bit to see if anyone else has something to offer.

nb: "SQL" is not an abbreviation for "Microsoft SQL Server". "Structured Query Language" is a standard and not owned by Microsoft.
What?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

PortletPaulEE Topic AdvisorCommented:
Well I have had a bit of an overwhelming SQL introduction in one of my recent deployments of a clients server.

I'm sorry you had an initiation of fire with your recent SQL Server experience (well I assume it is SQL Server because you have that topic).  I'm also sorry I didn't make myself clear earlier, but there is a tendency amongst SQL Sever users to use the term "SQL" to mean a product provided by Microsoft. In written communication this gets very confusing, so I try (however inadequately)  to point out this problem.
2
Nitin SontakkeDeveloperCommented:
Here are few other options...

Microsoft Virtual Academy - https://mva.microsoft.com

SQL Server Central - www.sqlservercentral.com - in particular have a look at their Stairway series.

Also, free ebooks available from Microsoft Press

Free 3 months subscription to both WintellectNow and PluralSight if you register for the Microsofts DevEssentials Program, which is free too!

And almost forgot about virtually tons of videos available at YouTube.
1
Nitin SontakkeDeveloperCommented:
@PortletPaul,

This is synonymous to, here in India, people often stating a photo copy of an original document being "Xerox copy"!
0
Pawan KumarDatabase ExpertCommented:
The more SQL your write the more you will LEARN. That's the MANTRA.

I suggest below training's for you -

12 FREE ONLINE COURSES
https://blogs.technet.microsoft.com/cansql/2013/10/31/11-free-sql-server-2012-online-training-courses-to-sharpen-your-skills/

VIDEO LESSIONS
http://pragmaticworks.com/Training

SOLVE SQL PUZZLES/COMPLEX QUERIES
https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
As Paul Porter stated, do you want to learn SQL or SQL Server?
If the first, then you just need to learn the Query Language that will work in most of the well known database management systems.
If the latter, then which role are you going to do? Developer? Administration? Engineering? Architecture?
And do you only need to learn about the SQL Server engine or other tools also, like Reporting Services, Integration Services or Analysis Services?
0
James BunchSystems EngineerAuthor Commented:
Thanks for all of the information listed. I apologize for my delay as work kept me busy lately.

I want to learn the SQL language to understand it better but more importantly a couple clients use programs that use things like SQL Express or mySQL, Microsoft SQL 2017. I am trying to find a way to work in that type of environment comfortably and understand what a support group may be doing if needing to do anything. Trying to keep myself from flying blind with watching them.

My role is an MSP. So I handle the issues with a business IT needs and liason between developers or customer support of applications etc.
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Please provide us some feedback on our comments, as at first glance multiple experts have answered your original question as you asked it shy of writing a book.  In my case I wrote an entire article on it, with a link in my comment.

Keep in mind that there is a decent learning curve in SQL Server, so stating that you want to learn the language from scratch and immediately be able to speak on it to clients may not be an abundantly realistic expectation.   Especially if you have a job description that does not use SQL Server on a regular basis.  

Also what's an MSP?  From my perspective MSP is the airport fifteen miles east of my house.
0
James BunchSystems EngineerAuthor Commented:
Also what's an MSP?  From my perspective MSP is the airport about fifteen miles east of my house.

Managed Service Provider. Long story short, a customer has a problem with anything technology related in their business it is my goal to figure out the issue and fix it. Sometimes that is within my knowledge and sometimes I have to reach out for support staff of products specific to the issue. Its a jack of all trades but the master of none position as IT Tech Support.

Please provide us some feedback on our comments, as at first glance multiple experts have answered your original question as you asked it shy of writing a book.

What type of feedback are you needing? I have had some great information shared on this discussion bored and as I stated originally from the first set of responses I would leave it open for a short period to see if anyone else had something to offer before closing the subject. I intend to award points and communicate those resources with the experts should I have questions about their links going forward.

Thank you all for the information and suggestions on training material!
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>a customer has a problem with anything technology related in their business it is my goal to figure out the issue and fix it.
I'm having a hard time coming up with an answer to this question, as you're asking us the 'fast track' from zero to being able to successfully troubleshoot, or at minimum a knowledge base of 'SQL Server for the non-Developer and DBA', and I don't know of any training offering out there that would specifically meet that need.   The market for such training is probably not that large.  My guess would be to contact some of the largest local IT training centers, or maybe the closest large university's college of engineering outreach program, and see if they have anything.

As a wild guess check out the PASS Summit 2017 session list, scroll down past the pre-cons, look at the Support offerings, and see if that is attractive enough to wait until next November and spend around four grand for a three-day technical conference.   Then add to the sessions the ability to walk through the vendors and converse with every one about topics that interest you.

>What type of feedback are you needing?
Ultimately it's your responsibility to state your question clearly, and not our responsibility to expand our answers so large that it covers it.   Keep in mind that your question is so general that one or a small set of comments probably won't cover it.

If you want to leave a question open for more info that's fine.
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Education

From novice to tech pro — start learning today.