Friday 4 October 2019
Workshop room
09:15–09:30
Check-in and morning tea/coffee
09:30–09:45
Introduction to the workshop and instructor; ice-breakers with participants
Swanand Pagnis
09:45–10:45
Session 1: Schema design and ancillary topics
Swanand Pagnis
10:45–11:30
Hands-on exercises on schema design and ancillary topics
Swanand Pagnis
11:30–11:50
Morning beverage break
11:50–13:00
Hands-on exercises on schema design and ancillary topics (continued)
Swanand Pagnis
13:00–13:50
Lunch break
13:50–15:00
Session 2: Design patterns, datatypes and constraints
Swanand Pagnis
15:00–16:00
Hands-on session: update the problem space; look at changing requirements; adapt design for changes.
Swanand Pagnis
16:00–16:30
Evening beverage break
16:30–17:30
Hands-on session: update the problem space; look at changing requirements; adapt design for changes (continued)
Swanand Pagnis
17:30–18:00
Q&A session; closing day 1
Swanand Pagnis
Saturday 5 October 2019
Workshop room
09:15–09:30
Check-in and morning tea/coffee
09:30–09:45
Recap of day 1; introducing workshop plan for day 2
Swanand Pagnis
09:45–10:45
Session 3: SQL -- learn how queries are constructed and composed.
Swanand Pagnis
10:45–11:30
Hands-on exercises: Write large and seemingly complex queries; understand top-down and bottom-up approaches of writing queries.
Swanand Pagnis
11:30–11:50
Morning beverage break
11:50–13:00
Hands-on exercises: Write large and seemingly complex queries and understand top-down and bottom-up approaches of writing queries. (Continued)
Swanand Pagnis
13:00–13:50
Lunch break
13:50–16:00
Hands-on exercises: Common performance concerns; tools to solve them including indexes and views
Swanand Pagnis
16:00–16:30
Evening beverage break
16:30–17:30
Session 4: Relational theory like ACID and MVCC
Swanand Pagnis
17:30–18:00
Q&A session; closing day 2
Swanand Pagnis
Hybrid access (members only)
Hosted by
We care about site reliability, cloud costs, security and data privacy