Chapter 1: Database Development Environments
In This Chapter
Using Microsoft’s Access and SQL Server
Working with IBM DB2
Employing Oracle 11g
Using SQL Anywhere, PostgreSQL, and MySQL
Aside from organizations that locked themselves into a database environment before about 1985, for most applications, any organization that’s using a database system now is probably using a relational database system. Any relational database system that’s still around today uses a version of SQL for communication between users and data. Although several specialty database products serve specific niche markets, for general use, a relatively small number of database management system (DBMS) products have significant market share. These products are Access and SQL Server from Microsoft, DB2 from IBM, Oracle and MySQL from Oracle Corporation, SQL Anywhere from Sybase, and PostgreSQL from PostgreSQL Global Development Group.
In this chapter, I take a brief look at the popular relational DBMS products with regard to how they implement SQL.
Microsoft Access, like all relational DBMSes today, ...