Hello, I'm new to this community and looking forward to participating!
I consider myself just above a beginner with WP. I've created 6-8 basic sites in the past but have always just built them live. I'm embarking on a more complex membership site now and would like to know the best/easiest way to build and test the site prior to launching it live. I've researched methods for both creating separate directories off the / in your hosting account and doing it there, them moving to / when you're ready, vs building it on a local machine then uploading everything when you're done. My biggest concern is the complexity of the database issues and ensuring all links remain intact. I'm not an experienced sql or wp database person. Any suggestions would be greatly appreciated!