A session profile is a group of sessions that you can apply to a member or members all in one go.
For example, let's say you have a swim group called tadpoles, and the tadpoles train on Monday, Wednesday and Saturday. You would create a session profile (Setup > Club > Session Profiles) called "Tadpoles" and add the Monday, Wednesday and Saturday sessions to it (assuming you have created the club sessions previously).
Now, if a member joins the Tadpoles group, all you need to do to add all the sessions to their profile is assign this session profile to them.
Open Members > Assign session profile, choose Select Profile, then select the club groups and/or individual members to update. Click Update.
This replaces all current session assignments for the selected members with the sessions in the profile. Check your selection before applying it.