Yes, Google Sync is a third party app that you install on your BlackBerry. It's middleware between your device address book/calendar and Google Address Book/Calendar.
It provides two-way wireless sync of calendar and contacts only.
Outlook sync is wired via USB cable and BlackBerry Desktop Software.
You can sync calendar, contacts, tasks and memos with this setup.