Free Trial
Join Class
Search:

MySQL

An introduction to databases using SQL with native Codio content containing fully auto-graded assessments

ADD TO MY ACCOUNT

Topics

  1. What is a Database
  2. Creating Databases and Inserting Data
  3. Altering Existing Databases and Updating Data
  4. Constraints and Keys
  5. Aggregate Functions

Learning from Mistakes

Beginners make mistakes, and making a mistake in the database can affect subsequent commands. This resource provides a way of resetting the database should user find themselves in need of a little help.

Auto-Graded Assessments

Students receive immediate, rich feedback. 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.

Constructing Knowledge Through Coding

MySQL emphasizes students applying and exploring the information presented. 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.

Lowering the Barrier to Entry

MySQL reflects the need for computer science education to meet students where they are. 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 this content is more approachable is that it is using 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 spend a sufficient amount of time on their work, and they do not wait until the last moment to begin their work. 

Take a peek inside...

  • Images help call out important details
  • Minimal text
  • Example code snippets that can be copied
  • Full IDE in the same browser window
  • Run code with a click of the button

mysql

 

Ready to Get Started?

Add this content to your Codio account!

ADD TO MY ACCOUNT