You can use the Classic Console to perform tasks that would normally performed using SQL and the command line, including:
Creating and managing users and other account-level objects (if you have the necessary administrator roles).
Creating and using virtual warehouses.
Creating and modifying databases and all database objects (schemas, tables, views, etc.).
Loading data into tables.
Submitting and monitoring queries.
Changing your password and setting user preferences.
If you want to upgrade from the Classic Console to Snowsight, refer to Upgrading to Snowsight.