Console apps in Salesforce are a tab-based workspace suitable for fast-paced work environments. These helps to manage multiple records on a single screen, to reduce time spent clicking and scrolling to find, update, and create records quickly.
If you are interested to learn Salesforce from experienced instructors, I recommend this Salesforce Certification Course by Intellipaat that provides Instructor-led training, hands-on projects, and certification.
Also, check out this video on Salesforce: