SSDT packages your database into a .dacpac file. This is essentially a compiled version of your database schema. You can hand this file to an operations team, and they can deploy it to SQL Server or Azure SQL without ever seeing your source code.
SSDT is often preferred by developers because it applies software engineering best practices to database work: what is ssdt