I am a software developer that supports and develops an application that connects to both Oracle databases and SQL Server databases. I want to learn more about database administration.
In SQL Studio Manager you can open a connection to a server and then selected the master database and then run a statement like this:
CREATE Database TestDatabase
TestDatabase is then available to connect to on that database server.
However, with SQL Developer you have to connect to a database already created (rather than connecting to the server). Therefore how do you create a new database in SQL Developer?
I thought I would be able to find my answer by Googling. However, this was not the case. There seem to be hundreds of tutorials about creating tables but I cannot find any about creating a database.