Use this SQL and Relational primer to get started.
SQLite is a light-weight standalone database. Look for documentation as well as downloads on the site.
Look here to access SQLite with C#, without Entity Framework. Use this reference to get an idea of raw access.
The Entity Framework makes it easy to create and manage data as well as structured queries.