Read the sqlite SQL documentation. Then read the built-in Python library documentation. Or read the SQLAlchemy documentation, for a different way to interact with it. Build something.

https://docs.python.org/3/library/sqlite3.html

https://docs.sqlalchemy.org/en/13/core/tutorial.html

https://www.sqlite.org/lang.html