The intermediate Armamentalist vocation in Dragon Quest VII: Fragments of the Forgotten Past for the Nintendo 3DS creates fighters who are comfortable with weapons as well as offensive magic. These magic knights specialize in elemental-based attacks that take up little to no MP.
How to become an Armamentalist: Visit Alltrades Abbey and make the switch after mastering the Warrior and Mage vocations. Warriors are powerful weapon-wielders, whereas Mages sling around elemental-based spells that target single and multiple enemies alike.
Stat boosts and detriments: Armamentalists enjoy a small boost to their Strength, but their lowered Resilience and HP reflects the more fragile Mage-based branch of their heritage. They do, however, get a small boost to their total MP, which should come in handy for your spellcasting needs.
Magic and Abilities Learned:
Level One: Bounce (Magic spells targeted at the user will reflect back at the caster. That includes healing spells!)
Level Two: Flame Slash (Inflict fire-based damage on one enemy)
Level Three: Kabuff / Insulate (Increase all party members' physical defense / Protect all party members against fire and ice attacks)
Level Four: Oomph / Lightning Slash (Double an ally's physical damage output for a while / Inflict lightning damage on an enemy)
Level Five: Zap / Kacrackle Slash (Call on lightning magic to fry one enemy / Inflict ice-based damage on one enemy)
Level Six: Kasnooze / Bazoom (Hit all foes with a powerful sleep spell / Take an enemy out of battle)
Level Seven: Kasizzle / Kafrizzle (Inflict moderate fire-based damage on a group of enemies / Inflict heavy fire-based damage on one enemy)
Level Eight: Miracle Slash (Restores some of the user's health according to the damage inflicted)
Usefulness: Armamentalists don't have as many multi-target attacks as their Mage brethren, but they're not lacking for them either. Plus, their weapon-based magic attacks have a low MP cost, and can be excellent for nailing down bosses and powerful single enemies with elemental weaknesses. Their decent attack power and skill with buffs make them a solid class that's hard to go wrong with.