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.



Introduction to Structured Query Language (SQL)
This course is part of Web Applications for Everybody Specialization

Instructor: Charles Russell Severance
Access provided by New York State Department of Labor
243,228 already enrolled
(5,444 reviews)
What you'll learn
Learn about the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation.
Learn to model many-to-many relationships like those needed to represent users, roles, and courses.
Details to know

Add to your LinkedIn profile
2 assignments
See how employees at top companies are mastering in-demand skills

Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate


Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

There are 4 modules in this course
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.
What's included
5 videos5 readings1 app item1 discussion prompt
We learn about single table queries and the basic syntax of the SQL language.
What's included
6 videos1 reading1 assignment1 app item
Covering database design with multiple tables, foreign keys, and the JOIN operation..
What's included
6 videos1 reading1 assignment1 app item
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
What's included
2 videos3 readings1 app item
Instructor

Offered by
Why people choose Coursera for their career




Learner reviews
5,444 reviews
- 5 stars
80.73%
- 4 stars
15.81%
- 3 stars
2.03%
- 2 stars
0.55%
- 1 star
0.86%
Showing 3 of 5444
Reviewed on Dec 3, 2018
Thank you for teaching assistants for helping me while I had questions and got stuck during the course. Thank you for Coursera and Dr Chuck and teaching assistants again for the opportunity to learn.
Reviewed on May 23, 2018
The course was very helpful to me in regard to designing structured databases. The concept was explained in a systematic manner and its use was demonstrated using simple examples.
Reviewed on Apr 25, 2020
Great course. The amazing thing about the instructor is that you will find something new and exciting in every course and that's why I loved this course and the remaining courses offered by Dr. Chuck.
Explore more from Computer Science
University of Colorado Boulder
Universidad Nacional Autónoma de México

Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy