Skip to content
Close
LOGIN
See how it works
Free Instructor Account
See how it works
Free Instructor Account
SOLUTIONS
LABS & ENVIRONMENTS
FEATURES
Courseware Catalog
CODIO FOR...
SUCCESS STORIES
COMMUNITY & FEEDBACK
ABOUT US
NEWS & RESEARCH
HELP & SUPPORT
MySQL

MySQL

An introduction to databases and learning SQL with native Codio content containing fully auto-graded assessments.

Select Ready-Made Modules to Build Your Course

Use checkboxes to select modules, drag them to rearrange course structure, click + to add assignments and modules.

Constructing Knowledge Through SQL Coding

Our MySQL computer science course content emphasizes students applying and exploring the information  presented within the context of PostgreSQL databases. To provide a thorough introduction to SQL, a code editor accompanies each page with new concepts so students can see for themselves how the computer responds to code. In addition, the content provides code snippets to get students started as well as suggested avenues for investigation.

In order to maximize their benefit from this course, students should possess a basic understanding of thePython programming language. You will use data structures like lists, tuples, and dictionaries to help manage SQL query results. Students will use Python to establish connections to a database, execute SQL queries, and manage the data returned by these queries. This involves using specific libraries (like PyGreSQL), creating connection objects, and executing SQL commands through cursor objects or the custom Db.query wrapper provided by PyGreSQL.

Auto-Graded Assessments and Instant Learner Feedback

Students receive immediate, rich feedback. In addition to correctness feedback (i.e. right or wrong), students will also see an explanation with the complete solution.

There are a wide variety of questions - all of which are auto-graded, giving students a sense of their understanding of the material right after they are introduced to it and as they attempt harder and harder problems. Auto-graded assessments also include five coding exercises at the end of each module, where students are evaluated on the code they write.

Lowering the Barrier to Entry

The materials for this introductory SQL course are designed to align with the current needs of computer science education, meeting students at their level of understanding. Like any specialized community, computer science has its own jargon. The formal teaching of computer science should not burden students with the assumption that they are fluent in this special language. 

The material is presented in smaller units that are more manageable for the students. The same vocabulary and concepts are covered, but in a more approachable way - state things as plainly as possible, and, when appropriate, use images, tables, or lists.

Another way in which our intro to SQL programming content is more approachable is that it uses many small programs instead of one large program. Research shows that a variety of smaller problems increase student performance and reduce stress. Using many small programs leads to students spending a sufficient amount of time on their work, and they do not wait until the last moment to begin their work.

Encouraging Customization Through Modularity

This content is not a one-size-fits-all solution. Instead, it implements a modular format. Natural breakpoints occur in the curriculum where instructors can make necessary changes. Instructors can rename, re-order, or remove units and can author new material using Codio's powerful curriculum content authoring tools, giving complete flexibility when designing the learner's experience.

What's Included