Skip to main content

Essentials of SQL: Extracting Data

Authors

Gove Allen, PhD
Brigham Young University
Gary Hansen, PhD
Brigham Young University
Robert Jackson, PhD
Brigham Young University

Editors

Amy Guan
Course Editor
Edition 1
(rev. 454)

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:

  1. Essentials of SQL: Extracting Data, which teaches students the SQL queries to read and extract information from a database.

  2. 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.

  • Any Device, Any Location, Any Time

    The course reader looks great on desktops, laptops, tablets, phones, and just about any other device. Students are able to read, watch, and listen how, where, and when they want.
  • Embedded, Customizable Assessments

    Your students complete assessments inline with the text, making for a seamless, engaging experience. As the instructor, you can customize existing assessments or create entirely new ones within the text.
  • Advanced Analytics

    Monitor the progress of your class collectively as well as students individually. Course analytics provide you with student engagement and performance in reading, videos, and assessments. Analytics help you focus directly on those topics or students that need it.
  • Flashcards

    Flashcards are a great way to learn the key terms. Each course comes pre-loaded with cards for every term. Students can also make their own to enhance their learning experience.
  • Searchable Glossary

    A searchable glossary is available at any point in the course reader, allowing students to search for any key term they want and jump straight to that word in the text - no matter where they're reading.
  • Highlights and Notes

    Students can highlight the text and make notes throughout the content using their touch screen or mouse.
  • Text, Video, Audio, Assessments

    Course content is provided in multiple ways, allowing your students to learn the way they learn. The HTML5-based course reader works like any other web page--the way the web was meant to be used.