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

Online Course

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

Taught by

Charles Severance

Related Courses

Reviews

5.0 rating, based on 1 reviews

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

  • 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 Never Stop Learning!

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

Sign up for free