SQL Query on a Dataset I created in AB

Alan.P.39

I'm trying to find my footing in AB… and followed the course tutorial on including the full schemaName.tableName_version_number in the query. Does this mean I can only create a SQL query on the tables listed in the schema? Can I not create queries that references a customized dataset that I build or that has been shared in AB? How might I write a SQL query that references the Enrollment Details [Template] dataset for example?

And does including the version_number in the SQL query mean I will need to manually update all the queries as the versions are updated?