Schedule
Workshop: PostgreSQL Masterclass

Workshop: PostgreSQL Masterclass

A workshop for advancing your RDBMS skills

Tickets
  • Select Tickets
  • Payment
  • invoice
  • Attendee details

Total ₹0

Cancellation and refund policy

Memberships can be cancelled within 1 hour of purchase

Workshop tickets can be cancelled or transferred upto 24 hours prior to the workshop.

For further queries, please write to us at support@hasgeek.com or call us at +91 7676 33 2020.

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

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