Attach AdventureWorks Data to Existing Database (No Admin Role)
You know what's really funny? This is exactly the kind of thing SSIS is designed to do.

You're probably going to run SSIS on your own desktop or laptop as you learn. SSIS is part of SQL Server Developer Edition, so you can install that for free on your laptop. It also comes with the SQL Server engine, obviously.

So attach the AdventureWorks db to your local SQL Server Developer Edition, and then use SSIS to move the contents of the local tables you want over to the server run by your IT department.

Congratulations, you have your first ETL project! Bad news though: you're also the client. You're probably a terrible boss.

If you want to learn something easier, start by using SSIS to import the contents of a spreadsheet or a text file into that target SQL Server instead.