SQLite3 is a light-weight database which has already in-built support in Django.SQLite3 is available as a file which can be opened using the software called DB Browser for SQLite. (https://sqlitebrowser.org/dl/)
Migration is the process in which Django runs SQL queries depending on the database models defined in the migration files. With the help of migration, we create new tables, alter tables, create indices and do other CRUD(Create, Read, Update, Delete) operations.
When the initial migration is done, Django creates tables for apps like admin, auth, content types and sessions. It creates tables like auth_user which contains user information, auth_group contains group information, django_migrations contains migrations applied so far and the table django_session contains sessions created when a user does login.