Book Cover

Essentials of SQL: Extracting Data

Information Systems

Technology Application Modules

ISBN:

978-1-7339969-3-8

cfwf default

Essentials of SQL: Extracting Data

Gove Allen, PhD Gary Hansen Robert Jackson, PhD

This interactive learning resource is an inexpensive module utilizing real servers and databases. Students run live queries within the resource! Servers include SQL, MySQL, Oracle, and PostgreSQL. Robust, auto-graded assessments and the ability to write new SQL skills or connect your own database make this module really dynamic!

  • Free instructor demo access to full resource
  • Plug-and-play solution for instant adoption
  • Lifetime access for students

Course Objective

This interactive module lets students run live queries on real servers, with auto-graded assessments and the ability to connect personal databases.

Table of Contents

Introduction: Essentials of SQL Interactive Textbook Chapter 1: Databases and SQL: Everywhere for Everybody Chapter 2: Extracting Data: The Select Statement Chapter 3: Data Across Tables: The Join Statement Chapter 4: Compounding Data: The Aggregating Functions Chapter 5: Combining Queries: Queries with Subqueries Appendix

Request Free Access

Interested in using this resource in your course? Request free instructor access. Just tell us who you are and where you teach, and we’ll take care of the rest!

(students: reach out to your instructor for assistance with accessing your textbook, or view this walkthrough.)

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Made by proffessors, for professors

cfwf default

Auto-Graded Assessments

Customize assessments or create new ones. Assessments are completed online within the text and instantly graded with detailed feedback.

cfwf default

LMS Integration

Access courseware with single sign-on convenience using our LMS integration tools. Assignments, exams, and grades are automatically synced.

cfwf default

Instructor Materials

Take advantage of study plans, PowerPoint presentations, and test banks so that courses require minimal start-up time.

cfwf default

Micro-Credentials & Certificates

Allow your students to earn achievements in the classroom. Keep them engaged using ready-made badges and certificates, or create your own.

cfwf default

AI Virtual Assistant

Our AI Virtual Assistant transforms how students engage with content, offering features like multilingual translation, question answering, progress assessment, and much more.

Related Courses

Catalog
What is MyEducator?
How much does MyEducator cost?
How long do students have access, and what about updates?
Are resources customizable?
How long is setup—what is the adoption process?
What LMS do you integrate with?
Do you provide sample syllabi, guides, and other instructor materials?

Ready to get started?