Introduction to Structured Query Language (SQL)

Go to class
Write Review

Free Online Course: Introduction to Structured Query Language (SQL) provided by Coursera is a comprehensive online course, which lasts for 4 weeks long, 16 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from Coursera. Introduction to Structured Query Language (SQL) is taught by Charles Severance.

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.