Site MapHelpFeedbackQuery formulation with SQL
Query formulation with SQL


Chapter 3 provided a foundation for using relational databases. Most importantly, you learned about connections among tables and fundamental operators to extract useful data. This chapter shows you how to apply this knowledge in using the data manipulation statements of SQL.

Much of your skill with SQL or other computer languages is derived from imitating examples. This chapter provides many examples to facilitate your learning process. Initially you are presented with relatively simple examples so that you become comfortable with the basics of the SQL SELECT statement. To prepare you for more difficult examples, two problem-solving guidelines (conceptual evaluation process and critical questions) are presented. The conceptual evaluation process explains the meaning of the SELECT statement through the sequence of operations and intermediate tables that produce the result. The critical questions help you transform a problem statement into a relational database representation in a language such as SQL. These guidelines are used to help formulate and explain the advanced problems presented in the last part of this chapter.










Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 4