Clearing dummy data before launch

There are plugins that will do this for you (example). Whether it’s worth installing it and learning how to use it, depends on how many posts, pages and so on, you have.

If you have less than, say, a hundred you can use the screen options tab on posts, pages and users to select a high enough number to be shown on one page. Then simply select all and trash. This also works for media in the list mode (rather than default grid mode with infinite scroll).

I wouldn’t mess with the database for this. Unless you really have a lot of data to wipe that would be too time consuming to figure out for a one off job.