29 Sat 09:15 AM – 05:00 PM IST
30 Sun 09:15 AM – 05:00 PM IST
Work better with PostgreSQL. Understand and master the various tools you have at your disposal when working with a database. Level up your database skills.
Schema design and ancillary topics. We’ll start with a problem space, and come up with a solution for it. Design patterns, datatypes, constraints will help us get there. We will then update the problem space, look at changing requirements and adapting our design for changes. At the end of day one, we will have a well-designed schema and enough data to work with.
We will focus on SQL; learn how queries are constructed and composed. We’ll write large and seemingly complex queries and understand top-down and bottom-up approaches of writing queries. We will also look at common performance concerns and tools to solve them, like indexes and views. We’ll then cover some relational theory like ACID and MVCC.
Swanand is the Director of Engineering at Deserve Inc, and has been organising the Bangalore Ruby User group meet-ups for the last decade. Ruby and SQL are his top weapons of choice, amongst others. He lives by the “continuous improvement” value and encourages others to do so.