Skip to content

MySQL

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

Course Modules & Assignments

Basic SQL Statements - Intro to SQL and Relational Databases
- Data manipulations from python
- CRUD and Data Types
- Coding Exercises
Tables Relations - Tables Relations and Joins
- Diving into SELECT
- Extra Join Types
- Coding Exercises
Tables structure - Creating Tables Structure
- Tables references and alters
- Indexes, transactions and triggers
- Coding Exercises
Access Control - Users and Roles
- Access Configuration
- Secure Connections and Data Encryption
- Coding Exercises
Incident Management - Threats and Injections
- Audit and Monitoring
- Backups and Recovery
- Coding Exercises

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.