This tutorial talks about a scene done in cinema4d, but most of the ideas can be used in any 3d program.  

If you find this site helpful, consider helping me learn blender and posting on this site with my Patreon Page.  

I made this image by following this tutorial.

I used this tutorial here, 

Beginner

He briefly explains the modifiers in 2.8.

Cool uses for several modifers.

Constraints

Beginner

This person has some great ideas on how to use constraints to keep an object to a path, rig a piston, rig a jet exhaust,  He uses the snap to curser shift s keyboard shortcut.  He has some parts which don't constrain properly, and he shows you how to fix those issues.  

Beginner

Intermediate

This person from decoded has all the basics of making a room.  He explains how get the camera settings  from a thirdparty plugin, and how to make the room, furniture, and lighting.  If you do this tutorial you should be able to make a very nice room.

Beginner

This person describes the whole process he did to make a fantasy landscape.  He blocked out the shapes for his idea, and then added some elements like a picture of a hiker, some landscapes, and textures them, and then lights, and adjusted his camera.    He then goes over all the steps he did in photoshop which were straight forward.  I'm sure you could use gimp or something like that also.  Overall a very nice tutorial.  The addition of photoshop really makes the image much nicer.

Inspiration

Beginner

Chong made a superb Tutorial in which he makes and animates a Sci Fi Corridor.  He models all the parts needed, (He uses a Boolean approach.)  An important tip is how he keeps the models to 1 meter, and sets the origin points to the lower right of the models so he can tile them later in geometry nodes.