subject

Coursera: Introduction to Structured Query Language (SQL)

 with  Charles Severance
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.

0 Student
reviews
Cost Free Online Course (Audit)
Pace Upcoming
Subject Databases
Provider Coursera
Language English
Certificates Paid Certificate Available
Hours 8-10 hours a week
Calendar 4 weeks long
Sign up for free? Learn how

Disclosure: To support our site, Class Central may be compensated by some course providers.

+ Add to My Courses
FAQ View All
What are MOOCs?
MOOCs stand for Massive Open Online Courses. These are free online courses from universities around the world (eg. Stanford Harvard MIT) offered to anyone with an internet connection.
How do I register?
To register for a course, click on "Go to Class" button on the course page. This will take you to the providers website where you can register for the course.
How do these MOOCs or free online courses work?
MOOCs are designed for an online audience, teaching primarily through short (5-20 min.) pre recorded video lectures, that you watch on weekly schedule when convenient for you.  They also have student discussion forums, homework/assignments, and online quizzes or exams.

0 reviews for Coursera's Introduction to Structured Query Language (SQL)

Write a review

Class Central

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

Sign up for free