A lot of people have been asking me this question. But anyway I'm glad to hear that many of you are learning the piano! For resources I do not use any books but instead I would go to imslp and download the music sheet that I want to learn and listen to recordings of pianists playing it. I do not know what level you are playing at but I will share how I approached many of the pieces I learned.
Do nots:
I started playing around 2 years ago with around grade 2 sight reading skills I have learned when I was very little. As long as you can read very simple notes values, sharps, flats and neutral notes that was all I needed to start playing the piano. All my friend played "harder" pieces so, lazy as I was I tried to take a short cut by starting out by playing La Campanella. Many would cringe " ah here we go again another beginner playing difficult pieces that even seasoned pianists struggle to play". But I didn't care because I was in absolute affection for the piece. So with my mediocre sight reading skills I couldn't read this spaghetti except for the first line. In the end I resorted to mimicking others who played with synthesia on the top. I do not recommend using synthesia to learn as it just inhibits you from actually learning how to read the score and improving. I was able to play a full 2 mins but it was pretty awful so eventually I moved back to an easier piece.
Do's:
My first actual piece was - Chopin waltz in A minor, B 150. I would read the notes really slowly and tried to perfect each bar before moving on to the next. Started with my right hand to get the gist of rhythm and moved on to my left. I couldn't sight read fast so I'd always try to memorize my way through and kept on repeating the same passage over again. I would really recommend trying out his waltzs as the left hand is usually the same rhythm if that made sense. After practicing many different waltzs I moved on to more challenging waltzs; bear in mind I practiced over 2 hours a day. Before playing each piece I would always listen to many recordings on youtube over and over again to get the "feeling/rhythm" of the music.
From then I slowly moved up in difficulty, never down unless if there was a piece I really wanted to play. Even if there was a new technique or score I didn't know how to play or read eg. left hand trills and double sharps I would go to youtube to look at how others played the same part (not synthesia) and build up my knowledge. Now, I am able to sight read the ballade in g minor without any major discomfort. One more important thing that helped me a lot with my techniques was Paul Bartons youtube videos. His techniques imo is clinical and you should really check him out.
Wow this took longer than expected to write. Well hope this helped!