Coursera Introduction to Structured Query Language (SQL)

University of Michigan via Coursera

  • Overview
  1. Coursera
    Platform:
    Coursera
    Provider:
    University of Michigan
    Effort:
    3-5 hours per week
    Length:
    4 weeks
    Language:
    English
    Credentials:
    Paid Certificate Available
    Part of:
    Web Applications for Everybody Specialization
    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

Share This Page



  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice