O'Reilly logo

Enterprise Applications Administration by Jeremy Faircloth

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4

Databases

This chapter focuses on databases and their relationship to enterprise applications. This chapter begins by discussing standard terminology associated with databases then quickly moves on to a discussion of SQL. Some of the more common operations including SELECT, INSERT, UPDATE, and DELETE statements for working with data and CREATE, ALTER, and DROP statements for working with database schemas are discussed. Database design topics including the concepts of OLTP versus OLAP database types, database normalization, how keys are used in databases, intersection tables, and indexes are all discussed and their usage given through numerous examples. Access control and database security are discussed in detail and various ways to protect ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required