Exam 98-364: MTA: Database Fundamentals-- Best Study Guide??

oxymoron5k

Hi all,
I am thinking about transitioning from a Systems Administrator (General IT Guy) to a SQL Career. I deal with SQL a lot with this current job so I have the environment and the potential work experience when I get to that point. Right now I just use the tech support.

1) What is the best study material for the MTA exam? I realllllly dont want to spend 1K for CBT Nuggets


2) What are your thoughts on the career change? I am hoping it will pay more.

Violated

I'm not sure what the best study material is, but Microsoft Virtual Academy has a course on Database Fundamentals. You can also get 3 months of PluralSight through the Visual Studio Dev Essentials. Either one should be good. After that, I would pursue the MCSA in SQL Server.

I was a DBA for a while, and I really miss it. You can definitely expect more money in the long run compared to Systems Administration.

oxymoron5k

Is a DBA the most common job for SQL guys? Also is the cert you think I should be going for if I want to dive into SQL?

Thanks!

Also what did you miss about it?

NotHackingYou

The official material is best for this course. I have taken this exam.
https://www.amazon.com/Exam-98-364-Database-Administration-Fundamentals/dp/0470889160/ref=sr_1_2?ie=UTF8&qid=1493310885&sr=8-2&keywords=98-364

oxymoron5k

Cool thanks!

Are you sure though? The reviews for that book are AWFUL.

Valerie38125

Hello
I am a newbie trying to get into the IT field and I was told getting a MTA certification will help me get a jump start in the database world. Do anyone have some good practice exams, as well as study guides, suggestions and/or notes that will help me with this process. Thank you

Valerie38125

Hello Did you find any good material to study for the database portion of the MTA exam?

oxymoron5k wrote: »

Cool thanks!

Are you sure though? The reviews for that book are AWFUL.

Cellshade

Hey Valerie I just did my MTA 98-364 and did a summary/notes from the book that you are more then welcome to. I cannot send pms though as far as I know.

Lakshmi Rekha Anand

I am also planning to do MTA. Cellshade, is it possible for you to share your summary notes to us?

Cellshade

No issues at all. These were some quick notes/summary from the book for MTA 98-364. I used the book and I also used W3school's SQL section to go through all the syntax it was invaluable.

Link to notes: https://goo.gl/2RbxFg

They are pretty simple but they do touch on everything the book does and a bit more.

Gavinsfc

Newbie here replying to an old thread... don't ban me [IMG]file:///C:/Users/dohertyg/AppData/Local/Temp/2/msohtmlclip1/01/clip_image001.gif[/IMG]

I'm going to be sitting the 98-364 exam soon, working in IT 5 years with 3 years as App Support using SQL.

Is using the Database Fundamentals videos on MS Virtual Academy enough to pass this exam for people with past experience?

scaredoftests

I helped me, though reading the book helped me as well.

Gavinsfc

Thanks for the reply. Would you say you would have passed just using the MVA videos?

Gavinsfc

Bump on that ^

Is the MVA tutorials enough to pass the 98-364 exam?

scaredoftests

No it wouldn't have (for me).

Gavinsfc

Any recommendations scaredoftests what resources to use?