• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 71
  • Last Modified:

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!
0
James Bunch
Asked:
James Bunch
  • 3
  • 3
  • 2
  • +3
3 Solutions
 
PortletPaulfreelancerCommented:
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 AnalystAuthor 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
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
PortletPaulfreelancerCommented:
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
 
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 AnalystAuthor 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 AnalystAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 3
  • 3
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now