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
239,636 already enrolled
Included with
(5,428 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
Recommended if you're interested in Mobile and Web Development
University of Colorado Boulder
Universidad Nacional Autónoma de México
Why people choose Coursera for their career




Learner reviews
5,428 reviews
- 5 stars
80.76%
- 4 stars
15.79%
- 3 stars
2.02%
- 2 stars
0.55%
- 1 star
0.86%
Showing 3 of 5428
Reviewed on Feb 2, 2024
This short specialization is WAY BETTER than the SQL specialization by UC Davis. OMG I wasted so much time on that 2 month certification when I could have learned way more on this one. Thank you!
Reviewed on Sep 12, 2020
Great coursera, So much to learn but hard to catch(It was totally new to me).I mean, really, a few days ago, I didn't even knew what SQL was and now I am getting it.Thank you very much.......
Reviewed on May 3, 2020
This course is best if you are new to MySQL. Dr. Chuck explains everything about how managing databases started and how it has evolved time to time. He explains everything from basics.
New to Mobile and Web Development? Start here.

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
Frequently asked questions
All software used in this course is free and open source and can be installed on Windows, Macintosh or Linux computers.
Yes - the textbook “The Missing Link: An Introduction to Web Development and Programming" is freely downloadable in PDF and ePub formats and print copies can be purchased if desired.
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
More questions
Financial aid available,