This is rather related to After Effects more than it is an issue with the program or tutorial. I like having opening sequences for some videos I make. Rather than still titles, I want something short, interesting, and that can introduce a short video clip.
I know there are some tutorials online for specific titles, but there are not many of these. Does anyone have any experience with this or does anyone have any resources they could recommend for me to look? I would like to learn how to compose my own from scratch and other source files. The problem is that I just do not have the eye for this. Where does one learn this? I searched for specific books or articles and I did not find any. Where do people who make them for film and TV learn the art?
Books and tutorials on line will help, but most people learn skills by "stealing" from others who have more experience. Get some time into a post house, offer to do assisting work for free with an experienced artist and learn from what you see. Also, a lot of hours spent in front of the computer, using the software to replicate what others are doing will help you develop your skills. Thake some examples that you like and try to replicate what you see. Breaking down a shot into it's elements and figuring out how to achieve tha effect or look will develop your thinking for motion graphics and visual effects.
I would suggest looking at other peoples work and their breakdowns about how they went about creating them. If you can get into a real place that does like Tudor says that would probably be even better. Two good places online to look is http://www.artofthetitle.com/ & http://www.watchthetitles.com/ . These two sites do an excellent job of presenting the titles and interviewing the creator so you get some real insight into their thought process.
I would also add that it's important to develop a good understanding of graphic design, typography and animation principles. You might look for a couple books like Robin Williams's The Non-Designer's Design Book, Ellen Lupton's Thinking with Type, and Angie Taylor's Design Essentials for the Motion Media Artist.
Principal & Designer at Keen Live
Motion Graphics, Widescreen Events, Presentation Design, and Consulting RenderBreak Blog - What I'm thinking when my workstation's thinking
Creative Cow Forum Host: Live & Stage Events