Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

University of Michigan

Introduction to Structured Query Language (SQL)

University of Michigan via Coursera

Overview

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.

Syllabus

  • 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.
  • 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.

Taught by

Charles Severance

Reviews

4.0 rating, based on 2 Class Central reviews

4.8 rating at Coursera based on 4886 ratings

Start your review of Introduction to Structured Query Language (SQL)

  • Overall Study material is good everything is good. but this course is only for beginners.
    I already know sql and I enrolled in this course to make some fundamental clear about the advance topic on window function. But there is nothing about the advance topic.

    Excluding that overall study and everything is nice.
  • Solomon Agbodjan is taking this course right now and found the course difficulty to be medium.

    I am so much in love with the course and its whole structure . I wish and long for this swift study background on which I would build my database management studies. God bless the creators.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.