In the first place, I disagree with your second half of the question. None can deliver functional software without doing usable code. It is true that you can obtain some certificates from online learning courses after completing a diploma, or degree in computer engineering fields or information technologies (IT) related courses in a leading university.
To decide the right software stack and relevant technologies, you must have some concepts clear regarding the software stacks like
Front-end Development Technologies
Back-end Development Technologies
Database Development Technologies in Demand
SQL and NoSQL Database Management Technologies.
You can get details in my recent blogs “Some Facts to Know about Full Stack Development” & “Want to Move to Full Stack Development but Not Sure Where to Start?”
Apart from these, you can gain a deep understanding and coding practices by online learning with eBooks, tutorials, and paid course.
Udacity, Lynda, Thinkful, Coursera, General Assembly and other myriads of eLearning software academies are providing such programs upon some fees. The leading universities across the globe, which have software engineering courses in their curricula are extending their reach beyond classroom walls and offer online as well as a combo of both world experiences.
The universities and government bodies are arranging camps to boost software learning for techies as well as tech-savvy but non-technical background people frequently. However, it is up to you take a suitable route or approaches to move in a direction to be a full stack developer.
Besides this theoretical knowledge, you must have real-world experiences by working on different projects, which are demanding skills in various software stacks. By working with experts and their contributions/mentoring, you also can get expertise on different trendy software stacks and go ahead to be a Full Stack Software Developer.
If you are thinking to join an ideal full stack development team in the USA, I cordially invite you to contact Perception System in San Jose, California. It has seasoned full stack developers with 17+ years of experiences. They have a rich portfolio boasting with many projects involved full stack developers. Moreover, you can learn which software stacks they have applied during their challenges project you should go through their case study section.