SQLite How to by Tag:
How to theme elgg with HTML and CSS only? [closed]
You can find the tutorial at Elgg Themes. And also, some example theme plugins. They recommend to develop themes as a plugin instead of changing the code of existing theme.