I’m going against the grain. Since @Zee, @Robert8, and @Sheepdog556 have covered the bases on training, rental, and going with a gun owning friend/family, here’s my additional .02 cents. Is this a ccw gun?
Yes=Small caliber, midsize guns rule. Shield 9, Glock 43 etc.
No=Midsize .357 revolver. Ruger GP100, Smith and Wesson 686, etc. 4 inch barrel, can shoot anything from mouse fart .38’s, through flame thrower .357 mag. The heft, and size make them highly shoot able. The revolver simplicity makes them easy to learn.
Both=Glock 19, M&P 9 Compact, Ruger Security 9 rule the roost. 9mm is a proven round, these guns are small enough to carry, big enough to shoot all day.