When I bought my first property a few years back I went through the following thought-process that might help you:
1. Understand the worst case scenario - I asked myself how much money I'll lose if it goes bad - I can't rent it, the market goes down 40%, etc. I came up with $20,000 loss for the type of SFH I intended to buy. Putting this "worst case" scenario on paper made it look less scary. It helped to quantify the opportunity vs. the risk - I am going to invest in RE so I can achieve financial freedom and I will risk $20,000 to do this.
2. Mitigate the risk - as a newbie I decided to put a larger down payment and keep reserves in my savings account to carry mortgage and expenses for around a year if the property is not rented. That helped me get to the comfort level I needed to get started and "just do it".
3. Have a strategy - for me, buying a single buy-and-hold or doing a one-time flip is very risky. But if you plan on buying 20 buy-and-holds over a 20 year period (which was my goal) than the risk is averaged even in extreme situations. You buy your first property now when the market is high but if the market crashes you will also buy a property 10 years from now when the market is low. Overall, some properties will perform better than others and your portfolio will do fine.
After I purchased my first property I realized it wasn't as scary as it seemed and that my worst-case scenario will probably never happen. I felt more confident, refinanced the property, took money out, and accelerated my plans.
Good luck!