Introduction to Databases: MySQL

An introduction to databases and learning SQL with native Codio content containing fully auto-graded assessments. Help your students learn the basics of SQL server programming today.

Modules

  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
 

Instructors

Interested in evaluating MySQL coding material for your class? Sign up for a Free Instructor Account to access and customize this Codio Resource for free!

Learning from Mistakes

Beginners make mistakes, and making a mistake in the database can affect subsequent commands. This resource utilizes the MySQL cloud IDE to provide a way of resetting the database should users find themselves in need of a little help.

Auto-Graded Assessments

With the MySQL online terminal, 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

Learning programming in MySQL emphasizes students applying and exploring the information presented. The MySQL 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 MySQL code snippets to get students started as well as suggested avenues for investigation.

Lowering the Barrier to Entry

MySQL for students 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 spending a sufficient amount of time on their work, and they do not wait until the last moment to begin their work.

Is SQL difficult to learn?

Depending on a student’s programming background, SQL can be easy to learn, or much more complicated. Like any programming language, learning SQL is made easier by the ability to see how your coding impacts other code. This is where MySQL comes in. With features built in to help students learn, it’s the perfect choice to support your SQL database course.

Take a peek inside...

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

Ready To Get Started?

Try our code plagiarism checker with a free Codio Instructor Account to start taking advantage of our coding course resources!!