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
229,001 already enrolled
Included with
(5,359 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.
Skills you'll gain
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
Illinois Tech
Why people choose Coursera for their career
Learner reviews
Showing 3 of 5359
5,359 reviews
- 5 stars
80.79%
- 4 stars
15.82%
- 3 stars
2%
- 2 stars
0.53%
- 1 star
0.83%
New to Mobile and Web Development? Start here.
Open new doors with Coursera Plus
Unlimited access to 7,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.