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
237,940 already enrolled
Included with
(5,421 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,421 reviews
- 5 stars
80.75%
- 4 stars
15.81%
- 3 stars
2.02%
- 2 stars
0.55%
- 1 star
0.84%
Showing 3 of 5421
Reviewed on Jun 24, 2020
Good to learn the basics of SQL. Gives you a detailed and easy introduction to the vast world of the database. Recommended to every student who is thinking of learning RDBMS for projects.
Reviewed on May 22, 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 2, 2020
The course took place in a crystal clear, slow and steady path and the final yield is also quiet satisfying. The best course for a beginner in MySQL and Database management systems.
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.