Learn SQL and SRSS the Most Easiest Way

Hi, I need to learn SQL and SSRS to be able to create simple reports for Clients, Suppliers, Internal Execs.
This is not the path for my career but just would like to be able to know SQL 2008 and up to be able to create and deliver reports to respective persons.


Thanks
Henry
HelpMeWithSolutionsAsked:
Who is Participating?
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.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Good luck with that.  SQL is not an easy learning curve, so it's a faulty premise to say 'I want an easy way to learn SQL'.   Perhaps a better route would be to identify a person that does this as their day job, and bribe them with beer / money / babes / whatever it takes for them to teach you what they do.

Or you can learn like the rest of us be having to do it for a living, and take your own training and learn online.
Again, not easy.
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
Goodangel MatopeSoftware ArchitectCommented:
I would say the best way to learn is by practice. I would recommend getting CBT nuggets or something similar. My personal journey started waaaay back and  a book called SQL Server 2000 by Example remains my favourite SQL Server learning resource as it provided a very complete SQL Server experience. I am sure there are newer editions of the book, but they had very easy and concise examples from which I learnt a LOT.
0
PortletPaulfreelancerCommented:
BOOKS! by far the best self-education approach.

Books by Itzik Ben-Gan are highly regarded. eg these
              (disclosue: my sql learning pre-dates sql server so I haven't used those books myself)
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

HelpMeWithSolutionsAuthor Commented:
Thanks a bunch for the response guys.  I am not looking to learn SQL, and have it as a career.  I just need to learn enough to be able to create, manipulate basic to intermediate Reports for upper management.

If anyone can point me to the right directions; books, online training, hand-on, etc. would be much appreciated.
0
Goodangel MatopeSoftware ArchitectCommented:
I believe in order to be able to make basic to intermediate reports used in real life business, you need to learn real actual proper SQL, because you will be making actual real business reports. Chances are whatever system you want to generate reports from will be complex enough for it to matter that you learn SQL properly.

http://www.amazon.com/Microsoft-Server-2000-Programming-Example/dp/0789724499

http://www.cbtnuggets.com/it-training/programming-and-development/database-development
0
PortletPaulfreelancerCommented:
"report writers" who refuse to learn good SQL are a problem, they never last long on my projects or with the company I work for.

Reports that consume too much effort and are slow to produce are REALLY OBVIOUS (and easily measurable)

A "report writer" who uses good quality SQL is an asset that an employer (or client) does not want to lose.

Do yourself a favour, don't regard SQL as incidental to producing reports, instead consider it as a critical skill.

There are subsets of SQL that you don't need to be expert in (e.g. triggers):
But anything and everything related to SELECT is very relevant!
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>Do yourself a favour, don't regard SQL as incidental to producing reports, instead consider it as a critical skill.
Amen.  Hallelujah brother, praise the Lord and sing...

>"report writers" who refuse to learn good SQL are a problem
Agreed.  This is the equivalent of saying 'I like to play with toys'.
0
HelpMeWithSolutionsAuthor Commented:
Thank you for the motivation, unfortunately, SQL is not the path I prefer to continue.  However, at the same token, I will take all the advices, and start hitting the SQL books.
0
Mike EghtebasDatabase and Application DeveloperCommented:
Also checkout you tube videos or possibly signup with Lynda.com ($25/month) for all you can watch. After doing this studying books becomes much easier.

Mike
0
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
SSRS

From novice to tech pro — start learning today.

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.