The Structured English QUEry Language for databases turns 50 this year. In the world of Android development, databases play a crucial role in storing and managing data efficiently. With SQLite, it's possible to manage app data in relational databases on users' devices. However, with the plethora of object-relational mappers (ORMs) available, many developers don't know about - or just overlook - the raw power and flexibility offered by SQL - as we call SEQUEL nowadays. ORM libraries offer convenience, but they abstract away the underlying SQL, leaving developers unaware of the intricacies of database management.

Topics covered:

- SelectUpdateInsertDelete: the syntax and semantics of the 4 most commonly used SQL query types
- Data modelling for relational databases
- The technical database schema: tables, columns, views, keys and all the things!
- Advanced querying: getting complex datasets into and out of your database
- Managing database schemas on app updates
- Limitations of SQLite - and in particular SQLite on devices.
- Concurrency and security: is the database safe and secure? And can other apps access it? And what if my app sends multiple SQL queries to it at the same time?

By the end of this session, you'll walk away with a newfound appreciation for SQL and the confidence to use its full potential in your Android projects. As a side-effect, this talk will leave you with a much better understanding of what your backend dev teams might be dealing with when managing data on the server. It might even inspire you to dabble with server databases yourself and you'll be a more knowledgeable, all-round developer after attending this talk.

Let's learn about databases and SQL and let's celebrate 50 years of S̶E̶Q̶U̶E̶L̶ SQL.