If you already have a good variable speed drill that's fully charged with a masonry bit, you will be fine. If you're working on it during the evening you need a good work light. There isn't enough lighting in the living room area, and no lights in the bedroom.
The likely mistake you would make is maybe drill holes too far apart, or too close together. Just carefully trace out the holes.
You also need to put anchor plugs in the holes. Just make sure you drill the hole as deep the length of the screw.
I'm no Mike Holmes, but it's definitely something you can do on your own. It's part of home ownership, you have to do some work by yourself. I'm not suggesting you go changing light fixtures if you're not comfortable with electricity. But installing curtain rods isn't that difficult.
Good luck with the install. Sometimes even asking a good neighbor to help doesn't hurt.