The database tables can be found by first extracting the zip archive on your machine and then navigating to wp-content/uploads/backupbuddy_temp/xxxxxxx/ where the x's represent your backup's serial number. From there, you will be able to find the (.sql) files or the singular (.sql) file if you chose that setting. The names will be the same as they were on the WordPress site, but the singular database file will be titled, "db_1.sql".
By default, BackupBuddy will dump each sql table into their own respective (.sql) file which may help with some servers that cannot handle a singular database file due to its potential size.
If you wish to have the sql tables dumped into one (.sql) file, then this can be done within the BackupBuddy settings. To do this, navigate to Wp-Admin -> BackupBuddy -> Settings -> Advanced Settings / Troubleshooting -> Database and uncheck the option, "Use separate files per table (when possible)". This will force BackupBuddy to create one database file called, "db_1.sql".