This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.
1- does a checkpoint on the datafiles
ALTER TABLESPACE ... OFFLINE
does not perform a checkpoint, so that if the database is open, you may need to perform media recovery when bringing it online.
ALTER DATABASE DATAFILE ... OFFLINE