Light trails like a sparkler would involve a particle system. There are free video tutorials at digital tutors.com on the basics of a particle system. Making the particles glow however is a different story. Your maya docs will tell you what you can do with your particle systems.