Structured query language (SQL) is used to set up the structure of the database, manipulate the data in the database, and query the database. This chapter will be dedicated to the data manipulation language (DML).
After reading the chapter, you will understand the concept of SQL and the logic of SQL statements. You will be able to write your own SQL queries and manipulate the data using this language. The complete reference of SQL can be found in the official PostgreSQL documentation at http://www.postgresql.org/docs/current/static/sql.html.
So the topics that we will cover in this chapter are as follows:
- SQL fundamentals
- Lexical structure
- Select
- Update
- Delete
Code examples in this chapter are based on the car portal database described in the previous chapters. The scripts to create the database and fill it with sample data can be found in the attached media. They are called schema.sql and data.sql. All the code examples from this chapter can be found in the examples.sql...