Back when we were making Tall Wall, Shiyu Liu (R&D/Pipeline Lead), had a tutorial call with Kandrea Zhou (Texture and Lighting Artist). This was the tutorial video made out of the video call recording, and was able to onboard around 6 texture artists who have never used Substance Painter before.
In this video, we covered how to set up the SP file for our project Tall Wall, basics navigations, 5 channels for texture painting, normal layer, texturing pipeline for Tall Wall, key to stylization, and exporting for Unreal Engine. After watching this video, you should be able to get started on painting your first stylized model texture in Substance Painter.

