Databases are found in practically every aspect of our modern society. Consequently, almost every academic discipline has the need to utilize databases. Students and scholars must understand and be skilled in how to access data from a database. Such disciplines as statistics, accounting, science, social science, business, economics, technology, and any discipline that has a research element must include database skills and knowledge. Appropriate courses in these disciplines must teach the required database skills. The challenge is providing these skills to students without distracting from the primary objectives and knowledge requirements of the courses in the primary discipline.
This textbook is designed to meet that objective. It is designed to be embedded within another primary course without overloading the teacher or the students and without requiring a major tangent from the primary course topics. Its design is flexible in that it permits the teacher to either use class periods to discuss database topics or have the students learn the material outside of the classroom. It is a comprehensive course in that it includes instruction text, practice sandboxes, self-grading quizzes, and self-grading problem sets all with real-time database access.
There are two versions of this textbook:
Essentials of SQL: Extracting Data, which teaches students the SQL queries to read and extract information from a database.
Essentials Plus of SQL: Extracting and Updating Data, which teaches students the SQL queries to extract information plus the SQL to create and modify databases and tables. Students will also learn how to insert and update data. Each student has his or her own personal database sandbox.