It is not difficult for professionals, but it will be difficult for friends who have never been exposed to video editing, or who are at a beginner level in video editing. The title of the film is made with an AE template, and some flash white\two-dimensional\
Many non-linear editing software can do special effects such as motion blur and transitions. In terms of software, Adobe's After Effects CS4 plus Premiere Pro CS4 can complete it. After Effects is used to do the special effects in the title sequence, including three-dimensional fonts and camera movement.
The one you provided is directly applied to the template. You can search and download AE templates online. Premiere is used for video editing and video special effects. Generally speaking, it depends on your foundation. If the foundation is weak, you should learn it first.
The application of AE and Premiere software. It takes more than one month of systematic study to produce works of this level.