Can a lecturer force you to learn a specific programming syntax / language? My class is currently further learning our relational database / SQL as part of the course.

The lecturer we have currently is restricting us to learning specifically Oracle SQL syntax rather than allowing us an option to using PostgreSQL, MySQL, SQLite, etc.

When we brought up our preference in the use of alternative systems due to working with those mentioned above in work placements or academic study from the year prior, we were talked down to for even discussing the matter.

Is this permissible within the UK to restrict students from using a preferred database syntax / software environment?



Edit to add: thank you for your insights and feedback. The post was made on behalf of myself and half a dozen class members who did not know the best route to address the matter, but now have a clearer understanding thanks to this community. For what it's worth, I can confidently say myself and my fellow students are confident with Oracle, MySQL and other SQL Basics from prior education, projects or employment and don't have an issue learning something new to keep progressing.
No, they can't. But they can make you fail the class.

Lecturers usually have free rein over the specifics of the material taught. Therefore they are free to choose any technology or dialect as long as it is within the area of the course.

Nobody can force you to study anything but if you want to pass his exam or the course by e.g. submitting lab problems, you have to play by their rules. 

They might not know any other dialect and therefore be only able to teach (and grade) Oracle SQL. Or they might consider it the best dialect, e.g., because of wide industry use.

Finally, although I would be annoyed by this as well, sometimes you have to suck it up and just pass the course. Lecturers that teach the same (obsolete) material for 20 years are unfortunately a reality in academia. At least you might learn what to avoid in the future.