O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

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 1: Database Development Environments

In This Chapter

arrow Using Microsoft’s Access and SQL Server

arrow Working with IBM DB2

arrow Employing Oracle 11g

arrow 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

Microsoft Access, like all relational DBMSes today, ...

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