Introduction to Databases

[llu94]

About You

Your Name: Lucas Lu & Charles Inwald

Twitter handle (optional):

The best way to reach out to you: LinkedIn: https://www.linkedin.com/in/charles-inwald/ && https://www.linkedin.com/in/lucas-l-0a00b3ab/ Email: lucasludev@gmail.com

A quick bio:

Lucas Lu and Charles Inwald are software engineers at Apple in New York City. Charles is a front end engineer with experience at startups and Lucas is an infrastructure engineer with experience in financial technology firms.

Your Talk

Title: Basics of Databases

What your talk is about:

This talk will be a quick primer on the theory and usage of databases with some demos. It is not meant to be comprehensive but a primer to get people interested in database design and optimization.

A discussion of the types of databases and their common usages and tradeoffs

1. Discussion of ACID principles vs BASE principles
2. Relational Databases, NoSQL databases: (Object oriented databases, Document Databases, Key-Value stores, Columnar databases, graph databases)

Discussion of the algorithms behind databases

1. Heap files, hash tables, sorted string tables, B+ trees
2. Database compaction (theory)

Administrative/Design demos using PostGresSQL

1. Database indexing
2. Database normalization
3. Database recovery

Q&A period

How long will your talk be?

• [ ] 5-15 minutes (lightning talk)
• [ ] 20-30 minutes
• [ ] 30-45 minutes
• [ X ] 60 minutes or more (includes Q&A time)

Meta

Do you need help crafting your talk?

• [ ] Yes
• [ X ] No

Meetup event Copy - Optional

Event Title:

Event Desciption:

[Danamitecoder]

Saw that you are already scheduled for April 2!