SQL All-in-One For Dummies, 4th Edition

Chapter 1

Database Development Environments

IN THIS CHAPTER

Using Microsoft Access and Microsoft SQL Server

Working with IBM Db2

Employing Oracle 18c

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, SQL Anywhere from SAP, and PostgreSQL from PostgreSQL Global Development Group.

In this chapter, I take a brief look at the popular relational DBMS products and how they implement SQL.

Microsoft Access

Microsoft Access, like all relational DBMS products today, uses ...