Introduction to SQL – University of Michigan

Interested in learning SQL for free? This online course from the University of Michigan is the best place to start. Learn how to build a database and manage data with SQL queries.

SQL course description

In this course, you’ll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySQL Database. You’ll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you’ll learn to model many-to-many relationships like those needed to represent users, roles, and courses.

Course content

  • Installing PHP and SQL: Our first technical task is to work through the installation steps including installing a text editor, installing MAMP or XAMPP (or equivalent), creating a MySQL Database, and writing a PHP program.
  • Introduction to Structured Query Language (SQL): We learn about single table queries and the basic syntax of the SQL language.
  • Database Design: Covering database design with multiple tables, foreign keys, and the JOIN operation..
  • Many-To-Many: We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.

CS courses

Course details

  • Institution: University of Michigan
  • Course type: Free online course
  • Level: Beginner
  • Duration: 4 weeks
  • Language: English, Korean, Serbian
  • Certificate: Verified certificate available

START LEARNING


You may also like: 

Free Android Developer Fundamentals (Java) course

Free Android Basics in Kotlin Course – Google Developers

Recevez les meilleures opportunités par mail, deux à trois fois par semaine.

Voir toutes les offres d'emploi

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *

Ce site utilise des cookies afin d'améliorer votre expérience et optimiser nos services.