What are the courses in architecture?

Need a good course on the application architecture, I would like most to focus around the real problems. Designing, selection of software and databases, selection of patterns and solutions. Is there anything similar from us, or from foreign training?
The reference to language is not important, in principle, a similar is likely to be bound to Java.
July 12th 19 at 17:31
2 answers
July 12th 19 at 17:33
Fowler patterns of enterprise applications pdf
In english: Martin Fowler. Patterns of enterprise applications architecture. - Orlo.Emmeri commented on July 12th 19 at 17:36
July 12th 19 at 17:35
Object-oriented design of software systems (Meyer)
Object-oriented analysis and design (Butch)
Code complete (McConnell)
The Autonomous art of testing with examples in C# (Osherow)
Domain-driven design (DDD). Structuring complex software systems (Evans)
Well and as already wrote "Patterns of enterprise applications" from Fowler

If you have little experience, much in these books is not clear to you

Find more questions by tags Designing softwareIT education