Demystifying PostgreSQL

Asher Snyder NOLOH

LAMP was originally Linux, Apache, MySQL, PHP. While L & A have become more flexible, most still use MySQL. With the recent acqusition by Oracle there's no better time to demystify PostgreSQL. For years PostgreSQL has had a reputation of being difficult, but this is the furthest from the truth. This presentation will cover installation, basic queries, stored procedures, triggers, full-text search

Intro to MySQL EXPLAIN

Ligaya Turmelle MySQL/Oracle

Just about anyone can write a basic SQL query for a table. Not everyone can write a *good* query though - that takes knowledge, practice and knowing how to understand what the optimizer is doing with the query. Learn the basics of query optimization so you keep your application engaging the user rather then showing the progress bar as they wait on the database.

MySQL Server Performance Tuning 101

Ligaya Turmelle MySQL/Oracle

Optimizing the queries you send to the database can greatly increase the database's performance, but what do you know about all those strange MySQL variables that can be played with to get even more power from the database? Join me as we go over some of the basics of the various MySQL settings you can twitch, tweak and massage to get the most out of your MySQL server.

SQL Injection Myths and Fallacies

Bill Karwin Karwin Software Solutions

The most massive crime of identity theft in history was perpetrated in 2007 by exploiting an SQL Injection vulnerability. This issue is one of the most common and most serious threats to web application security. In this presentation, you'll see some common myths busted, you'll get a better understanding of defending against SQL injection.