Q&A

Q1: What is database normalization?
A1: Database normalization is the process of designing databases so they conform to certain rules, which prevent various data storage and retrieval problems. Generally, the rules prevent unnecessary duplication of data in a database.
Q2: How do I know if the database I’m using supports SQL?
A2: The key word to look for is “relational.” Nearly all relational databases provide SQL support. The most popular databases—Oracle, Sybase, Informix, IBM DB/2, MySQL, Microsoft SQL Server, and even Microsoft Access—all support SQL to varying degrees.

Get Sams Teach Yourself CGI in 24 Hours, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.