MS SQL self study

I.am.Sam

I.am.Sam

Honorary Master
Joined
Jun 14, 2011
Messages
97,866
Reaction score
17,291
Location
In your mind ...rent free
Hi Guys,

I need some help or info on how and what to study.

Im working in the BI space at the moment and my job role is basically creating reports. Now that is quiet easy so i want more of a challenge.

I have been on oracle courses and have studied abit of oracles PL/SQL but now i see there is more scope on the microsoft side.

Can someone help me with self study or what notes to use to study SQL and SSIS/SSRS/SSAS.

I havn't had any exposure to any of this and i cannot afford a course.

What i want to do is study on my own and apply for jobs.

If any of you has notes or links please do help cause i can google the stuff but not sure what is needed.

Appreciate the help
 
I self study "cowboy style" :-)

Get the express versions of everything MS SQL studio or if you have licenses get the full thing , Install it on a play PC/Server/VM.
Pick a project an make it work. You learn more that way, instead of reading stuff the whole time, and you also kind of build your own "Style" of doing things as you build skill.

Next time i want to accomplish something my brain automatically starts running through all the things i have done in the past, and i'm able to apply it to my line of work.

And yet i'm not a qualified MS SQL specialist

I'm also into report developing and SQL integration between other ERP systems,
I develop reports in Crystal Report, create SQL queries to extract data , all of the stuff i have been playing with out of "Enthusiasm" is really paying off.

I just need to get my but in line and get going on some courses too. (Lazy)
 
Google tutorials for some of the following topics, this will help you get on your feet.

1. Installing & Configuring MSSQL
2. Learn the tools (Sql Server Management Studio, Visual Studio (For SSIS/SSRS).
2. Creating & Maintaining databases (Rebuilding indexes, update statisitcs, DB Integrety check, using the Activity Monitor).
3. Security - Users & Roles
4. Create tables, Stored procedures, functions, views, triggers.
5. Indexes (very helpfull are the index DMV's in SQL 2005 and up), Statistics, Linked servers.
6. SSIS - start off with something like : Generate a flat file, copy that flat file to a destination, delete file. Use SSIS to ETL Data between MS SQL and Oracle. Import a Excel/Flat file into a database.
7. Database Engine tuning Advisor, SQL profiler
 
I'm coming from a MySQL background and didn't find it that hard to jump into MSSQL. Sure, there's a fair bit that's different but it's easy enough to learn.
You can either go along and use Google, or you could get yourself some books/ online tutorials.
 
great great stuff so far guys ...

i extract most data of our database by the reporting tool so i dont really write a query for it ...

@sbsp ..il google the MS SQL studio and hopefully get something
 
Last edited:
Get your employer to pay for the training, all that you mentioned fits right into the BI role you have and would further your specific role at the company, so it's a benefit for your employer.

You don't have to get certified (write the exams) but there are benefits to be certified that your employer could also then use and say "look, we a gold partner" or whatever
 
AcidRaZor said:
Get your employer to pay for the training, all that you mentioned fits right into the BI role you have and would further your specific role at the company, so it's a benefit for your employer.

You don't have to get certified (write the exams) but there are benefits to be certified that your employer could also then use and say "look, we a gold partner" or whatever
Click to expand...

my company doesnt use MS SQL and neither do we code or query in advanced SQL ...

i want to move and most companies want MS SQL developers ...so if i know something then its better than saying i know about it and never used it

our database maintenace is outsourced and the tables and data thats in there and as well as the reports that are here have been for a while. (before i joined)
 
AcidRaZor said:
Get your employer to pay for the training, all that you mentioned fits right into the BI role you have and would further your specific role at the company, so it's a benefit for your employer.

You don't have to get certified (write the exams) but there are benefits to be certified that your employer could also then use and say "look, we a gold partner" or whatever
Click to expand...

my company doesnt use MS SQL and neither do we code or query in advanced SQL ...

i want to move and most companies want MS SQL developers ...so if i know something then its better than saying i know about it and never used it

our database maintenace is outsourced and the tables and data thats in there and as well as the reports that are here have been for a while. (before i joined)
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X